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 > > > > > -- View this message in context: http://www.nabble.com/Users---Using-PostgreSQL-tf1009995.html#a5578960 Sent from the OFBiz - User forum at Nabble.com.
