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

Re: Installing LedgerSMB into a schema?


I am going to assume that you only have one db user used by LSMB.  I
am also going to assume that its username is ledgersmb.  If it is
something else, adjust the name of the schema accordingly.  If oyu
have multiple db users, this becomes more complex.

Create the schema.  Call this ledgersmb (or your db username).
run the following command in the sql directory of your ledgersmb install:
sed -ie 's/create table /create table ledgersmb./i' Pg-database.sql

Now try to load it.

This should work with LedgerSMB out of the box because Pg's default
search path starts at $username.

If you run into trouble with this or your situation is more complex,
let me know.

Best Wishes,
Chris Travers