Thread: BUG #2524: Error while using pg_restore command

The following bug has been logged online:

Bug reference:      2524
Logged by:          Sudarshan
Email address:      sudharshan.prabhu@valtech.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

> The following bug has been logged online:
>=20
> Bug reference:      2524
> Logged by:          Sudarshan
> Email address:      sudharshan.prabhu@valtech.co.in
> PostgreSQL version: 8.0
> Operating system:   Windoes-XP
> Description:        Error while using pg_restore command
> Details:=20
>=20
> When i run the pg_restore command
>=20
> "pg_restore -d db1 -v -h localhost -p 5432 -U postgres db2.backup"
>=20
> I get the following error
>=20
> pg_restore: [archiver (db)] connection to database "db1"=20
> failed: FATAL:=20
> password authentication failed for user "postgres"
>=20
> I checked and rechecked the password and it seems correct. I=20
> also saw so many threads on "pg_restore" but could not find=20
> suitable answer for this.
>=20
> Ealiest help greatly appreciated.

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