RE: Users - Using PostgreSQL

Posted by Vinay Agarwal on
URL: http://ofbiz.116.s1.nabble.com/Users-Using-PostgreSQL-tp137098p137102.html

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