Hello,
I had posted my problem before but guess it didnt get
thru correctly. Sorry for the repeatation :)
I am facing a strange problem with pg_hba.conf. I know
I am doing something very stupid.
I had a user kirk who had a pg server running under
him. We had a database by the name kirk and everything
was fine. Then he left the job and we had a new user.
We started the pg using initdb and gave all permission
to the data directory to joe(new user). Now we cant
seem to start login to the server at all.
createuser, createdb etc. all giving the same error:
No entry defined in pg_hba.conf for localhost, user
jor, database template1.
I have checked pg_hba.conf and I have the sentence:
host all all 192.168.0.0 255.255.255.255 trust
but for no avail.
in postresql.conf i have tcp_socket set to true.
What I am doing wrong? In despair..
Regards,
Karam
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail