Re: OFBIZ __ PostgreSQL

[mohd Viqar <mh...@gmail.com>]

In order to use postgresql do the following steps (Replace the example
database names, database user and its password by your application specific
names )
 
1. Create a database in postgresql example myDbName 
2. Create a database user ex dbUser identified by password ex dbPassword
3. Grant access to this dbUser on the database in this ex on myDbName
4. Create two more databases for olap and tenant ex olapDbName and
tenantDbName .
5. Grant access to dbUser on these two databases also.

Now after creating three databases and a db user change the
framework/entity/config/entityengine.xml file 

I am attaching a sample 
http://ofbiz.135035.n4.nabble.com/file/n4632956/entityengine.xml
entityengine.xml  file with above mentioned databases and database user.
have a look at the attached file and search for above mentioned example
database names to see how to and where to change.

 
After making above mentioned changes execute following commands.

1. Stop the ofbiz server if running.
2. Run ant download-PG-JDBC command
3. ant run-install.
4. startofbiz

Regards
Mohd Viqar


G.Ben wrote
> 
> Hi, 
> 
> I'm looking for some help about migrating from ofbiz derby database to
> postgresql database, and also how to create and set data directly from
> postgresql without having to pass by derby. 
> According to tutorials that I have, I can't find how they get connected to
> another database (postgres in my case) and defining entities there, and
> keep developing the application. 
> 
> P.S : * I'm using Eclipse IDE 
>        * I'm just a beginner in ofbiz so I have just few knowledge about
> the OFBiz environement. 
> 
> Thank you for you help :)
> 

--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4632956.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: OFBIZ __ PostgreSQL

["G.Ben" <g....@gmail.com>]

Thank you all for your help,

It worked finally.

Regards.

G.Ben.

--
View this message in context: http://ofbiz.135035.n4.nabble.com/OFBIZ-PostgreSQL-tp4632713p4633195.html
Sent from the OFBiz - User mailing list archive at Nabble.com.