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

From: Kynn Jones <kynnjo(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Date: 2009-04-13 20:01:36
Message-ID: c2350ba40904131301k455aba12xb0557642e690764a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Incidentally, is there a general way to get positive confirmation that a
particular pg_hba.conf has been re-read upon bouncing the server with

kill -HUP <PID>

?

TIA!

kynn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message aravind chandu 2009-04-13 20:06:17 In memory Database for postgres
Previous Message Merlin Moncure 2009-04-13 19:49:01 Re: Number Conversion Function