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

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Date: 2009-04-14 14:57:26
Message-ID: c2350ba40904140757m3b1fe3a9rf193786c133c01ed@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones <kynnjo(at)gmail(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-04-14 16:11:25 Re: Table dependencies
Previous Message Alvaro Herrera 2009-04-14 14:01:35 Re: how to disable autovaccum