Received: from FW-INTERNAL.ubiquity.com ([202.138.193.106]) by postgresql.org (8.11.3/8.11.4) with SMTP id g165grE33522 for ; Wed, 6 Feb 2002 00:42:53 -0500 (EST) (envelope-from murray@efone.com) Received: (qmail 2459 invoked from network); 6 Feb 2002 09:35:21 -0000 Received: from unknown (HELO efone.com) (192.168.2.12) by fw-internal.ubiquity.com with SMTP; 6 Feb 2002 09:35:21 -0000 Message-ID: <3C605E9F.1090602@efone.com> Date: Wed, 06 Feb 2002 09:37:19 +1100 From: Murray Prior Hobbs Organization: eFone International Pty Ltd User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:0.9.2.1) Gecko/20010901 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: practical limitations to number of postgres user accounts Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/66 X-Sequence-Number: 6496 i want support many unique users in my database i have my own daemons for such things and i already know they scale to support millions of user accounts but it would be really convienient if i used the postgres authorisation system and created a unique user account for each of my users what practical limitations are there in postgres? what sort of user numbers have already been sucessfully implemented? any info welcome murray hobbs