FATAL: password authentication failed for user "postgres"

From: Sabn Coanda <s(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-general(at)postgresql(dot)org
Subject: FATAL: password authentication failed for user "postgres"
Date: 2011-11-03 13:02:38
Message-ID: j8u3f0$138s$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2011-11-03 13:34:01 Memory Issue
Previous Message Rodrigo Gonzalez 2011-11-03 12:18:46 Re: 9.1 replication on different arch