Brendan
Here is what I do. If i have the database on a different server, I create a
new postgres setup with a name that reflects the server it is on.
Otherwise, I use the existing localpostgres. For example, if I have the
database server on data41, I have a database entry named data41postgres. I
just copy and past the localpostgres section, give it a new name and change
the settings to reflect the postgres insstall and location.
Then, all you have to do is change default entity reader:
<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"/>
</delegator>
to:
<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="data41postgres"/>
</delegator>
or, if you are running postgres on the same machine:
<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="localpostgres"/>
</delegator>
If you set up postgres to use ofbiz as the database name and user and
password as shown, your done. Otherwise, modify the ofbiz postgres settings
to mirror what you set up in postgres.
Here's a link with more complete instructions:
http://www.opentaps.org/index.php?option=com_content&task=view&id=38&Itemid=
62
Cheers
Skip
-----Original Message-----
From: Brendan Vogt [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 20, 2007 8:03 AM
To: [email protected]
Subject: OfBiz Database Installation
Hi,
I am new to this kind of setup. I am a C# programmer, and I am used to
clicking a couple of times then everything is installed and ready to go. I
am wanting to try out the OfBiz application.
After hours of trying to get the source code, I managed to download it. Now
I am following the installation steps as set out in:
http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setu
p+Guide
I am busy with the section under Database Setup. I have SQL Server 2005,
but want to use Postgres database. I have it installed as well. I have
added the JDBC driver .rar in the directory which they said I must. In the
${ofbiz install dir}/framework/entity/config/entityengine.xml file I have to
set my datasource. There is already many datasources added.
Question
Do I need to change any of the setting for the Postgres database datasource?
DO I keep the other datasources there?
Regards,
Brendan
