pg_dump error
Hi,
I am using PostgreSQL 9.0. It is installed on Windows XP. I am trying to take a backup of the database using pg_dump. But each time I give a command
Pg_dump pgdb > backup.sql
I am prompted for a password and I provided the database password. After this, I got an error as follows..
pg_dump: [archiver (db)] connection to database "pgdb" failed : FATAL: password authentication failed for user "windows user_name".
Can somebody please tell me what I should be doing to avoid this error?
Thanks,
Mamatha
On 11/17/11 11:01 PM, Mamatha_Kagathi_Chan@DELL.com wrote:
I am using PostgreSQL 9.0. It is installed on Windows XP. I am trying
to take a backup of the database using pg_dump. But each time I give a
commandPg_dump pgdb > backup.sql
I am prompted for a password and I provided the database password.
After this, I got an error as follows..pg_dump: [archiver (db)] connection to database “pgdb” failed : FATAL:
password authentication failed for user “windows user_name”.
add -U dbusername to the command line.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast