[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Install to a scheme instead of a database



Should this go into the devel list instead?

Looking at the INSTALL document I see that LedgerSMB needs to be installed in a database which I've done before. Now I'd like to install it in as a scheme (ledgersmb) in a database (mycompany).

I can modify the SQL (creation) scripts and I assume(/hope) that if I do a

	set search_path=ledgersmb

for the ledgersmb_mycompany role the rest of the application code will handle it correctly. Right? I still have to look at the DBI code for any old SL oddities but was hoping someone more familiar with the code could give me a heads-up.

But I wonder how this will work with v1.3 and the new plan to use "database" roles. Since roles -- normally -- are not unique for each database but can be seen across the whole cluster there can be only one "john". And the same for "ledgersmb" role.

Would I be the only person providing DB (and therefore ledgersmb) access to multiple organizations using the same cluster?


TIA,
Rod
--