Postgres do have example in entityengine.xml. Need to change localhost from IP address with user name and password.
Best Regards, -- Rishi Solanki *CTO, Mindpath Technology* Intelligent Solutions cell: +91-98932-87847 http://www.mindpathtech.com On Thu, Dec 12, 2019 at 7:01 PM Bagas Sanjaya <bagasdo...@gmail.com> wrote: > OK, but I use Postgres instead. > > So should I specify DB user name and password in connection URL, or > should they be skipped? > > On 12/12/19 19.31, Jacques Le Roux wrote: > > You have examples in entityengine.xml, just use the DNS or IP > > address.Look for jdbc-uri= in entityengine.xml. You might also change > > the port... > > > > Since OFBiz simply covers the JDBC driver you may refer to > > > > > https://stackoverflow.com/questions/14657036/how-to-connect-to-a-remote-database-with-jdbc > > > > > > or > > > > https://vladmihalcea.com/jdbc-driver-connection-url-strings/ > > > > HTH > > > > Jacques > > > > Le 12/12/2019 à 12:48, Bagas Sanjaya a écrit : > >> Hello all, > >> > >> How can I connect my OFBiz instance to remote database instance? > >> > >> Bagas > >> > > -- > An old man doll... just what I always wanted! - Clara > > -- > An old man doll... just what I always wanted! - Clara >