A Practical Multi-Tenant Cluster

Rod Anderson

From PostgreSQL Conference West Speakers

For the small business support person being able to provide PostgreSQL hosting for a small set of specific applications without having to build and support several Pg installations is necessary. By building a multi-tenant Pg cluster with one tenant per database and each application in it's own schema maintenance and support is much simpler. The issues that present themselves are how to provide and control dba and user access to the database and get the applications into their own schema. With this comes need to make logging in to the database (pg_hba.conf) as non-complex as possible.

AttachmentSize
Pg-Multi-tenant-DBs.pdf144.59 KB