Re: PostgreSQL Hosting

From: "Thomas F(dot) O'Connell" <tfo(at)sitening(dot)com>
To: Joshua D(dot)Drake <jd(at)commandprompt(dot)com>
Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL Hosting
Date: 2005-07-11 18:13:58
Message-ID: A558DC25-7DC4-4241-AE09-D5BCB940B16B@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-07-11 18:24:34 Re: upgrading from 8.0 rc5
Previous Message snacktime 2005-07-11 17:58:00 upgrading from 8.0 rc5