Re: Why pg_dump 'trust' authentication fails under root and works under another user?

Поиск
Список
Период
Сортировка
От Jaroslav Záruba
Тема Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Дата
Msg-id AANLkTi=VQQiODWtE7P8mWLiG6M5KswidQiMFZa+P8T=c@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why pg_dump 'trust' authentication fails under root and works under another user?  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Why pg_dump 'trust' authentication fails under root and works under another user?
Список pgsql-admin
Дерево обсуждения
My pg_hba.conf looks like this:

local all     postgres        trust
host all postgres 192.168.1.0/24 md5
local all all ident
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

2011/3/24 Guillaume Lelarge <guillaume@lelarge.info>
Please, answer to the list.

(Wrong button, I'm sorry for that.)
 
Le 24/03/2011 09:13, Jaroslav Záruba a écrit :
> Yes, it is the password for PostgreSQL.
>
> pg_dump: [archiver (db)] connection to database "db123" failed: FATAL:
>  password authentication failed for user "postgres"
> FATAL:  password authentication failed for user "postgres"
>

The error message says the authentication method used isn't trust. Can
you tell us the complete content of your pg_hba.conf (without the
comments of course), and the exact command lines (the one that work and
the one that doesn't work).


--

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