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
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
Precedence: bulk
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