From: | "Roderick A(dot) Anderson" <raanders(at)acm(dot)org> |
---|---|
To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Multi-tenant cluster |
Date: | 2009-01-14 17:30:17 |
Message-ID: | 496E2129.7080608@acm.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Scott Marlowe wrote:
> 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.
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(at)db1, dba(at)db2, ... but there are or could
be some problems with doing it this way.
So back to the books for me.
Again thanks,
Rod
--
From | Date | Subject | |
---|---|---|---|
Next Message | Thom Brown | 2009-01-14 19:14:10 | Change empty database from ASCII to UTF-8 encoded |
Previous Message | Merlin Moncure | 2009-01-14 16:46:29 | Re: Polymorphic "setof record" function? |