RE: Users - Using PostgreSQL

Posted by Carl Gleisner on
URL: http://ofbiz.116.s1.nabble.com/Users-Using-PostgreSQL-tp137098p137103.html

Vinay,

from now on you are officially my hero. Step two of your personal tutorial really did the trick. Thank you Vinay.

I would also like to thank everyone else for being very kind and helpful. Guess that's just the way we open source people are.

Long live open source!

Vinay Agarwal wrote

The verification step, on opentaps.org won't work until pg_hba.conf is modified as specified and postgres has been restarted. Here's what I used just last week to setup postgres 8.1.4
Step 1:
-------
$ su postgres
$ createuser -W ofbiz
$ createdb ofbiz

Step 2:
-------
$psql
<postgres prompt> ALTER USER postgre PASSWORD '<passpostgres>';
<postgres prompt> ALTER USER ofbiz PASSWORD '<passofbiz>';
<postgres prompt> \q

Make sure the <passofbiz> is the same as in entity/config/entityengine.xml

Step 3:
-------
Edit pg_hba.conf to comment out all access lines at the bottom and adding this
host    all    all   127.0.0.1    255.255.255.255    password

Restart postgres typically by
   /etc/rc.d/init.d/postgresql restart

This turns off all local authentication (as in step 2) and requires password for any postgres access.

Step 4: verification
--------------------
$ psql -h localhost -U ofbiz -W

It prompts for password and you should be able to log in.

To reset database during development (THIS WILL DELETE ALL DATA FROM DATABASE)
------------------------------------------------------------------------------
$ psql -h localhost -U postgres -W
<enter password>
DROP SCHEMA PUBLIC CASCADE;CREATE SCHEMA PUBLIC AUTHORIZATION ofbiz;
\q

Regards,
Vinay Agarwal