From: | Gémes Géza <geza(at)kzsdabas(dot)sulinet(dot)hu> |
---|---|
To: | jie zhang <jie(at)best(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: authentication error |
Date: | 2003-05-14 20:24:15 |
Message-ID: | 3EC2A5EF.30101@kzsdabas.sulinet.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
jie zhang írta:
> Hi,
>
> I try to connect using psql test from localhost. I got:
> FATAL 1: No pg_hba.conf entry for host localhost, user postgres,
> database test
>
> I double checked that I have done the following:
> I started server using: postmaster -i -D /var/lib/pgsql/data >logfile
> 2>&1 &
>
> In my pg_hba.conf file I have:
> host all 127.0.0.1 255.255.255.0 trust
> local all reject
>
> Are there anything else I need to do ? or anything I did wrong ?
> I try to force the connection go through tcp/ip.
> Please advice if you can.
> thanks in advance,
>
> Jie
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Can you connect without a host option if yes then check your
postgresql.conf file (should be in the same dir as pg_hba.conf) check
for a line tcpip_socket = true if not found write it and then restart
the postmaster.
Good luck
Geza Gemes
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Mattarollo | 2003-05-14 20:31:41 | [URGENT] Problems recovering database |
Previous Message | jie zhang | 2003-05-14 19:35:11 | authentication error |