Scott Marlowe wrote:
On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson <raanders@xxxxxxx> 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
--
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
