Re: Multi-tenant cluster - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Multi-tenant cluster
Date
Msg-id dcc563d10812240852r383f9ec8y11fd86654afe1154@mail.gmail.com
Whole thread Raw
In response to Multi-tenant cluster  ("Roderick A. Anderson" <raanders@acm.org>)
Responses Re: Multi-tenant cluster
List pgsql-general
On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson <raanders@acm.org> wrote:
> I've done some searching using Google and found a few papers and articles on
> multi-tenant databases.  I still have to read through many of them but there
> didn't appear to be much reference to using PostgreSQL in the ones I found.
>
> Can anyone suggest sources of information on this topic -- multi-tenant
> databases?

PostgreSQL can do this quite well.  There are a few ways of
approaching this.  The most separation can be achieved by setting up a
db per user and configuring pg_hba.conf for sameuser so that the user
connects to the database named for them only.

pgsql-general by date:

Previous
From: "Emanuel Calvo Franco"
Date:
Subject: Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress
Next
From: "Scott Marlowe"
Date:
Subject: Re: need some help with pl-pgsql