[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Install to a scheme instead of a database
- Subject: Install to a scheme instead of a database
- From: "Roderick A. Anderson" <..hidden..>
- Date: Mon, 29 Sep 2008 13:30:47 -0700
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
--