Message-ID: <50D5DD4F.6030602@cs.utoronto.ca>
Date: Sat, 22 Dec 2012 09:18:23 -0700
From: Ryan Johnson <ryan.johnson@cs.utoronto.ca>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:17.0) Gecko/17.0 Thunderbird/17.0
MIME-Version: 1.0
To: Andrey Repin <cygwin@cygwin.com>
CC: Andrey Repin <anrdaemon@freemail.ru>
Subject: Re: Best practice for running pgsql under cygwin?
References: <50D4A8C6.7000505@cs.utoronto.ca> <611019184.20121222183650@mtu-net.ru>
In-Reply-To: <611019184.20121222183650@mtu-net.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm
Sender: cygwin-owner@cygwin.com
Mail-Followup-To: cygwin@cygwin.com

On 22/12/2012 7:36 AM, Andrey Repin wrote:
> Greetings, Ryan Johnson!
>
>> I'm trying to set up pgsql for classroom instruction, which means I need
>> to allow students to connect to my machine, preferably with no OS-level
>> privileges and minimal database privileges.
> If your class is about setting up the server, you should really use virtual
> machines.
> If it's about using SQL on already running server, it makes no difference, if
> you've your server as Cygwin port or native application - clients will never
> know.
>
>> Setting up the database roles looks straightforward enough, but I'm having
>> trouble figuring out how to secure the machine.
> It is unclear to me, why you need to let students access the machine.
Most student work will be done on private installs of pgsql, which they 
can set up however they'd like.

However, we're going to do classroom demos at times, including one where 
we have fun with different isolation levels; I'll need multiple students 
logged into the same database so they can mess with each others' 
interactive transactions.

Thanks,
Ryan


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple