On Tue, Apr 14, 2009 at 2:53 PM, Alvaro Herrera
wrote:
> Kynn Jones escribió:
>
> > Is there a general way to get positive confirmation that a particular
> > pg_hba.conf has been re-read upon bouncing the server with
>
> SHOW hba_file;
That's handy. Thanks!
Kynn
Kynn Jones escribió:
> Is there a general way to get positive confirmation that a particular
> pg_hba.conf has been re-read upon bouncing the server with
SHOW hba_file;
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
On Tue, Apr 14, 2009 at 12:22 PM, Tom Lane wrote:
> Kynn Jones writes:
> > On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe >wrote:
> >> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones wrote:
> >>> as the postgres user, I get the error
> >>> psql: FATAL: no pg_hba.conf entry for host "[local]", use
Kynn Jones writes:
> 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
Well, you could strace the postmaster and see what files it reads
in response to the signal.
regards, tom l
Kynn Jones writes:
> On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe wrote:
>> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones wrote:
>>> as the postgres user, I get the error
>>> psql: FATAL: no pg_hba.conf entry for host "[local]", user "postgres",
>>> database "postgres", SSL off
>> What do all t
On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe wrote:
> On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones 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
> >
>
On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones 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 th
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