The following bug has been logged online:

Bug reference: 1743
Logged by: karthika
Email address: karthikaj (AT) virtusa (DOT) com
PostgreSQL version: 8.0.2
Operating system: Windows
Description: problem in pg_restore
Details:

When i executed the pg_restore -d sample -U postgres sample.bak

pg_restore: connecting to database for restore
Password:

pg_restore: [archiver (db)] connection to database "sample" failed: FATAL:
password authentication failed for user "postgres"
pg_restore: *** aborted because of error

Kindly mail me the solution to this problem.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend