[rt-users] Customized PostgreSQL install?

[Roderick A. Anderson]

I am installing RT (3.8.8) where PostgreSQL is running on another system 
-- not a problem -- and the database (one of many company databases) 
already exists with a schema to hold the RT tables.  The roles (dba at acme 
, rt_user at acme) and their permissions are already set up as part of the 
database provisioning.

I don't see anyway other than change the code in rt-setup-database to 
connect to the 'company' database instead of template1 and just create 
the tables, views, etc. in the schema.

I'm wondering if anyone else is interested in using RT in a multi-tenant 
PostgreSQL database setup?  If there is I'll look at coding to make the 
database a 'configure' variable and the DSN method use it.

There are lots of other possibilities including:

* have the Pg superuser (postgres) check if the specified database 
exists and error out if not,
* Create the rt3 schema if necessary,
* create the rt_user role etc.

Thoughts, ideas?


\\||/
Rod
--