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
