Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, Apr 14, 2009 at 12:22 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Kynn Jones <kynnjo@xxxxxxxxx> writes:
> 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:
>>> 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 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

That connection should certainly match the last line, and maybe the first
too; but it didn't find a match at all.  I conclude that this file isn't
actually what's driving the postmaster --- you are looking at the wrong
file, or you changed it and forgot to SIGHUP the postmaster, or you're
connecting to some other postmaster altogether, or some other mistake
not visible in the terms of this discussion.


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

 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux