'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'... - Mailing list pgsql-general

From Kynn Jones
Subject 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Date
Msg-id c2350ba40904131301k455aba12xb0557642e690764a@mail.gmail.com
Whole thread Raw
Responses Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
List 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




pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Number Conversion Function
Next
From: aravind chandu
Date:
Subject: In memory Database for postgres