On 11/17/11 11:01 PM, mamatha_kagathi_c...@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 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”.


add -U dbusername to the command line.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to