Switching to PostgreSQL

Posted by Terence Ng on Aug 26, 2009; 3:26pm
URL: http://ofbiz.116.s1.nabble.com/Switching-to-PostgreSQL-tp164229.html

Hi,

I want a confirmation that switching to PostgreSQL 8.3 (new installation), in entityengine.xml

1) I should replace by "localpostnew" or "localpostgres", which one is correct???  Is "localpostnew"?
2) Except delagator name = "default", do I also have to replace the "localderby" in "default-no-eca" and "test"?
3) How about the "localderbyolap"?

<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" entity-eca-enabled="false" distributed-cache-clear-enabled="false">
        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
</delegator>

<delegator name="test" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localderby"/>
        <group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
</delegator>
<delegator name="other" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main">
        <group-map group-name="org.ofbiz" datasource-name="localpostgres"/>
</delegator>

Regards, Terence