Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump error

pg_dump error

From
Date:

 

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

Re: pg_dump error

From
John R Pierce
Date:
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
> 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