X-Recipient:	archive-cygwin AT delorie DOT com
X-SWARE-Spam-Status:	No, hits=1.4 required=5.0 tests=AWL,BAYES_05,FREEMAIL_FROM,KAM_THEBAT,KHOP_THREADED,SPF_SOFTFAIL,TW_PG
X-Spam-Check-By:	sourceware.org
Date:	Sun, 23 Dec 2012 05:53:37 +0400
From:	Andrey Repin <anrdaemon AT freemail DOT ru>
Reply-To:	Andrey Repin <cygwin AT cygwin DOT com>
Message-ID:	<694164860.20121223055337@mtu-net.ru>
To:	Ryan Johnson <ryan DOT johnson AT cs DOT utoronto DOT ca>, cygwin AT cygwin DOT com
Subject:	Re: Best practice for running pgsql under cygwin?
In-Reply-To:	<50D5DD4F.6030602@cs.utoronto.ca>
References:	<50D4A8C6 DOT 7000505 AT cs DOT utoronto DOT ca> <611019184 DOT 20121222183650 AT mtu-net DOT ru> <50D5DD4F DOT 6030602 AT cs DOT utoronto DOT ca>
MIME-Version:	1.0
X-IsSubscribed:	yes
Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id:	<cygwin.cygwin.com>
List-Unsubscribe:	<mailto:cygwin-unsubscribe-archive-cygwin=delorie DOT com AT cygwin DOT 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

Greetings, Ryan Johnson!

> 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.

The answer remains the same - use virtual machines. Probably, with Linux.
Then you would be able to have pre-made system installations for every class,
and what more important, you could easily restore each VM to the state you
want it in for a next group of students taking the same class.


--
WBR,
Andrey Repin (anrdaemon AT freemail DOT ru) 23.12.2012, <05:51>

Sorry for my terrible english...


--
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

- Raw text -