FATAL: password authentication failed for user "postgres"

Поиск
Список
Период
Сортировка
От Sabn Coanda
Тема FATAL: password authentication failed for user "postgres"
Дата
Msg-id j8u3f0$138s$1@news.hub.org
обсуждение исходный текст
Ответы Re: FATAL: password authentication failed for user "postgres"  (Robert Treat <rob@xzilla.net>)
Список pgsql-general
Hi,

I am using trust authentication since some years, but I need now to
authenticate the user for a specific application when connect to
postgresql database. I found "trust" ignores the password, so I changed
it in pg_hba.conf to "password".

My application is working now, but I have problems running the usual
maintenance scripts. For instance, when I am running pg_dump with
postgres user, it requires the password. The problem is it doesn't
accept the password I used in pgAdmin to connect to the same database
for the same database user.

What is wrong ?

My pg_hba.conf looks like:
local all all password
host all all 127.0.0.1/32 password

The command I am running is:
pg_dump <my_db_name> -F c -v -X disable-triggers -U postgres -h
127.0.0.1 -p 5432 -f ./test.backup

TIA,
Sabin

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

Предыдущее
От: Ronan Dunklau
Дата:
Сообщение: First "beta" of multicorn FDW on pgxn
Следующее
От: Robert Treat
Дата:
Сообщение: Re: Recommendations for SSDs in production?