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

Поиск
Список
Период
Сортировка
От Kynn Jones
Тема Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...
Дата
Msg-id c2350ba40904140757m3b1fe3a9rf193786c133c01ed@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: 'no pg_hba.conf entry for host "[local]", user "postgres", database "postgres"'...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Mon, Apr 13, 2009 at 4:54 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Mon, Apr 13, 2009 at 2:01 PM, Kynn Jones <kynnjo@gmail.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
 

В списке pgsql-general по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: how to disable autovaccum
Следующее
От: Kaarel Kitsemets
Дата:
Сообщение: Table dependencies