Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...

[Kynn Jones <kynnjo@xxxxxxxxx>]

On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote:

On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones <kynnjo@xxxxxxxxx> wrote:
> When I try to run
> % psql
> as the postgres user, I get the error
> psql: FATAL:  no pg_hba.conf entry for host "[local]", user "postgres",
> database "postgres", SSL off
>
> I don't understand this error, since the pg_hba.conf file includes the line:
> local all all ident sameuser
> What could explain this behavior?

What do all the lines look like together?

The uncommented lines are:

local   all     yours_truly        password

host    all     yours_truly        0.0.0.1/0            md5

host    all     yours_truly        ::1/128              md5

local  all     all             ident sameuser

Thanks!

Kynn