X-Recipient: archive-cygwin@delorie.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 Reply-To: Andrey Repin Message-ID: <694164860.20121223055337@mtu-net.ru> To: Ryan Johnson , cygwin@cygwin.com Subject: Re: Best practice for running pgsql under cygwin? In-Reply-To: <50D5DD4F.6030602@cs.utoronto.ca> References: <50D4A8C6.7000505@cs.utoronto.ca> <611019184.20121222183650@mtu-net.ru> <50D5DD4F.6030602@cs.utoronto.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-IsSubscribed: yes Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm Precedence: bulk List-Id: List-Unsubscribe: List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.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@freemail.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