Re: authentication error

On Tue, May 13, 2003 at 22:29:04 -0700,
jie zhang <jie(at)best(dot)com> wrote:
> 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

It looks like you are connecting via domain sockets and have not allowed
this for any users in pg_hba.conf. You probably want to change the local
line to:
local all trust

>
> 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 ?
> Please advice if you can.
>
> thanks in advance,
>
> Jie
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org