Switching to PostgreSQL

[Terence Ng]

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

[c.schinzer]

It's all described in the technical setup document:
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide

however, just doing step (1) in your list of three will be sufficient, and
yes since you're on PostgreSQL 8.3 use localpostnew.

Make sure you have a user ofbiz on your PostgreSQL setup and a database
called the same as specifies in the "localpostnew" configuration (also ofbiz
in the default defs if I am not mistaken).
On PostgreSQL grant all permissions to the public user, too, and make sure
the database owner is "ofbiz".

Well, I guess that's it. Runs fine for me! Have fun.

Carsten


2009/8/26 ngterry <[hidden email]>

>
> 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>
> <!-- be sure that your default delegator (or the one you use) uses the same
> datasource for test. You must run "ant run-install" before running "ant
> run-tests" -->
> <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
> --
> View this message in context:
> http://www.nabble.com/Switching-to-PostgreSQL-tp25151425p25151425.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

--

Best

Carsten Schinzer

Waisenhausstr. 53a
80637 München
Germany