Received: from mail2.desupernet.net (IDENT:qmailr@[204.249.184.37]) by hub.org (8.9.3/8.9.3) with SMTP id DAA59102 for ; Thu, 24 Jun 1999 03:10:07 -0400 (EDT) (envelope-from a222@redrose.net) Received: (qmail 16325 invoked from network); 24 Jun 1999 07:10:01 -0000 Received: from unknown (HELO linux.redrose.net) (208.170.178.155) by mail2.desupernet.net with SMTP; 24 Jun 1999 07:10:01 -0000 Received: from redrose.net (patrick@win98.redrose.net [192.168.1.5]) by linux.redrose.net (8.8.7/8.8.7) with ESMTP id DAA20924; Thu, 24 Jun 1999 03:15:09 -0400 Sender: patrick@linux.redrose.net Message-ID: <3771D551.40E9CF57@redrose.net> Date: Thu, 24 Jun 1999 02:50:57 -0400 From: Patrick Giagnocavo X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.0.35 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@hub.org" Subject: Best way to support many many users? Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I am setting up a web server with Postgres. I am trying to figure out how exactly to allow multiple users to each have their own "sandbox" without being able to interfere with other user's data. I am also a little concerned about performance issues (I have 256 MB RAM in my system to help with this). Is it more efficient to start up multiple postmaster processes on different ports, or run everything from one postmaster? Any tips, tricks, documentation etc very greatly appreciated. ./patrick a222@redrose.net