Joshua,
Is there any difference between a catalog and a cluster? As in, are
you saying a separate postmaster per user, as Tom Lane suggested in
the post I referenced earlier in this thread?
Off-hand, do you (or anyone else) see any showstoppers with the
implementation I laid out involving a bit of mucking with system
catalogs and the schema search path?
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Jul 11, 2005, at 12:01 PM, Joshua D. Drake wrote:
Although it is resource intensive, Command Prompt creates a new
catalog
owned by the user for each account. So on a given machine we will have
25 postgresql catalogs running on separate ports.
This has worked very well for us for the last couple of years.
Sincerely,
Joshua D. Drake
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org