Re: Multi-tenant cluster

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Roderick A(dot) Anderson" <raanders(at)acm(dot)org>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multi-tenant cluster
Date: 2008-12-24 16:52:24
Message-ID: dcc563d10812240852r383f9ec8y11fd86654afe1154@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson <raanders(at)acm(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-12-24 16:54:59 Re: need some help with pl-pgsql
Previous Message Emanuel Calvo Franco 2008-12-24 16:36:39 Compiling 8.4devel on OpenSolaris2008.11 with SunStudioExpress