Re: Multi-tenant cluster

Scott Marlowe wrote:
> 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.

Thanks Scott.  Sorry to take so longing getting back.

This is a little too fine of a granularity for what I'm trying to do.

I have (will have) some databases in a cluster that represent different
tenants (company's, organizations).  In each database there will be
several schemas that hold the data for an application that is typically
done as a single database, in the public schema, in a cluster.


The thorniest issue I've come across is user(s) names for each
application in each database.  Plus a dba account per database.

Currently I'm using db1_dba, db1_dba, db1_rt_user, etc.  I understand I
can do something like rt_user@db1, dba@db2, ... but there are or could
be some problems with doing it this way.

So back to the books for me.


Again thanks,
Rod
--