Strange pg_hba.conf error (repost)

From: Karam Chand <karam_chand03(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Strange pg_hba.conf error (repost)
Date: 2004-08-12 15:31:59
Message-ID: 20040812153159.3385.qmail@web53908.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2004-08-12 16:02:34 Re: Replication options?
Previous Message Jan Wieck 2004-08-12 15:30:08 Re: pl pgsql grammer file contains error