The following bug has been logged online:

Bug reference: 2524
Logged by: Sudarshan
Email address: sudharshan.prabhu (AT) valtech (DOT) co.in
PostgreSQL version: 8.0
Operating system: Windoes-XP
Description: Error while using pg_restore command
Details:

When i run the pg_restore command

"pg_restore -d db1 -v -h localhost -p 5432 -U postgres db2.backup"

I get the following error

pg_restore: [archiver (db)] connection to database "db1" failed: FATAL:
password authentication failed for user "postgres"

I checked and rechecked the password and it seems correct. I also saw so
many threads on "pg_restore" but could not find suitable answer for this.

Ealiest help greatly appreciated.

Cheers
Sudarshan

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

This looks like a bug that has been fixed in the latest versions in both
the 8.0 and the 8.1 series. Upgrade to 8.0.8 or 8.1.4 and see if that
fixes it.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq