BUG #2524: Error while using pg_restore command

Started by Sudarshanalmost 20 years ago2 messagesbugs
Jump to latest
#1Sudarshan
sudharshan.prabhu@valtech.co.in

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

#2Magnus Hagander
magnus@hagander.net
In reply to: Sudarshan (#1)
Re: 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.

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