Strange pg_hba.conf error (repost) - Mailing list pgsql-general

From Karam Chand
Subject Strange pg_hba.conf error (repost)
Date
Msg-id 20040812153159.3385.qmail@web53908.mail.yahoo.com
Whole thread Raw
In response to Re: datpath error  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Strange pg_hba.conf error (repost)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Paramveer.Singh@trilogy.com
Date:
Subject: Re: pl pgsql grammer file contains error
Next
From: Raphael Bauduin
Date:
Subject: Re: history tables with only one function?