OFBiz 18.12 : Using external DB Postgresql

[Sandeep Singh]

Hi All,
          I am using OFBiz version 18.12 to configure it with a postgresql
10.6 database. I have the instructions from the following website(Section
'Database setup") to achieve the same.

https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide

After carrying put the steps, when I run "ofbiz --load-data" , the data is
not loaded in the postgresql DB but instead in the default derby database
itself.

Could someone please help me with what I could be mising here. Does the
version 18.12 some additional steps.

Thanks
--Sandeep
*"What we want to see is the child in pursuit of knowledge, and not
knowledge in pursuit of the child." -George Bernard Shaw*

[adityasharma]

Hi Sandeep,

Refer to these links:
https://cwiki.apache.org/confluence/display/OFBIZ/Setup+OFBiz+version+16.11.02+with+PostgreSQL+on+Windows
https://cwiki.apache.org/confluence/display/OFBIZ/Tune+your+PostgreSQL+installation
http://ofbiz.135035.n4.nabble.com/Current-PostgreSQL-Instructions-td4703200.html

Though it is for 16.11, it will work for 18.12 too. You will have to
configure it in entityengine.xml.

HTH

Thanks and Regards,
Aditya Sharma

On Mon, Oct 21, 2019 at 7:36 PM Sandeep Singh <[hidden email]> wrote:

> Hi All,
>           I am using OFBiz version 18.12 to configure it with a postgresql
> 10.6 database. I have the instructions from the following website(Section
> 'Database setup") to achieve the same.
>
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide
>
> After carrying put the steps, when I run "ofbiz --load-data" , the data is
> not loaded in the postgresql DB but instead in the default derby database
> itself.
>
> Could someone please help me with what I could be mising here. Does the
> version 18.12 some additional steps.
>
> Thanks
> --Sandeep
> *"What we want to see is the child in pursuit of knowledge, and not
> knowledge in pursuit of the child." -George Bernard Shaw*
>