X-Recipient: archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status: No, hits=-2.2 required=5.0	tests=AWL,BAYES_00,KHOP_RCVD_UNTRUST,KHOP_THREADED,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL,TW_PG,T_RP_MATCHES_RCVD
X-Spam-Check-By: sourceware.org
Message-ID: <50D5DD4F.6030602@cs.utoronto.ca>
Date: Sat, 22 Dec 2012 09:18:23 -0700
From: Ryan Johnson <ryan DOT johnson AT cs DOT utoronto DOT 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 AT cygwin DOT com>
CC: Andrey Repin <anrdaemon AT freemail DOT ru>
Subject: Re: Best practice for running pgsql under cygwin?
References: <50D4A8C6 DOT 7000505 AT cs DOT utoronto DOT ca> <611019184 DOT 20121222183650 AT mtu-net DOT ru>
In-Reply-To: <611019184.20121222183650@mtu-net.ru>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT 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