I used this as a reference. Worked great; http://www.toivari.com/devblog/2010/06/16/configure-ofbiz-to-use-postgresql-server/
On Fri, Sep 24, 2010 at 9:07 AM, BJ Freeman <[email protected]> wrote: > if you follow the entityengine layout you will see that each has a different > db. > you need three seperate db in postgres > so copy the localpostnew > to localpostolap > localposttenant > each being a seperate postgres db. > > > cmunozjuste sent the following on 9/24/2010 5:13 AM: >> >> Hello, >> >> We are starting with OfBiz and we would like to use Postgres as the >> database. I configured the localpostnew datasource at the entityengine.xml >> file, and I changed in the default delegator this: >> >> <group-map group-name="org.ofbiz" datasource-name="localpostnew"/> >> <group-map group-name="org.ofbiz.olap" datasource-name="localpostnew"/> >> <group-map group-name="org.ofbiz.tenant" datasource-name="localpostnew"/> >> >> After running "ant run-install-extseed", everything is ok, except for the >> fact that the olap and tenant tables are missing on the new Postgres >> database. >> I have noticed that in the default configuration for Derby, three >> databases >> are used, one for tenant tables, one for olap tables and one for the rest. >> >> Is having three databases a must in Postgres, too? Our intention was to >> use >> one database for everything. >> >> Thanks a lot, >> >> Carlos > >
