Re: pg_dump error

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump error
Date: 2011-11-18 07:30:41
Message-ID: 4EC609A1.7060905@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/17/11 11:01 PM, Mamatha_Kagathi_Chan(at)DELL(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2011-11-18 08:50:37 Re: convert text field to utf8 in sql_ascii database
Previous Message Venkat Balaji 2011-11-18 07:09:36 Re: Incremental backup with RSYNC or something?