Re: authentication error - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: authentication error
Date
Msg-id 20030515164542.GA18010@wolff.to
Whole thread Raw
In response to authentication error  (jie zhang <jie@best.com>)
List pgsql-admin
On Tue, May 13, 2003 at 22:29:04 -0700,
  jie zhang <jie@best.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

pgsql-admin by date:

Previous
From: gdid@gmx.de (G. W.)
Date:
Subject: Backup without WAL files with Server shut down
Next
From: Stephan Szabo
Date:
Subject: Re: qestion