The following bug has been logged online:
Bug reference: 1503
Logged by: Yavuz
Email address: stern_ix@yahoo.com
PostgreSQL version: 8.0.1
Operating system: windows 2000 sp4
Description: pg_restore cannot restore a backup
Details:
firstly i try a backup on Fedore Linux core2 with 8.0.1
pg_dump -f backup.tar -Ft -U postgres mydb
and and restore it with
createdb mydb2 -U postgres
pg_restore -d mydb2 backup.tar -U postgres
it works very fine
and i try this commands on win2000 service pack4 with postgresql 8.0.1
pg_dump -f backup.tar -Ft -U postgres mydb
works well and i can see the listing with
pg_restore -l backup.tar
and a create a database to restore with
createdb mydb2 -U postgres
its ok
but when i try
pg_restore -d mydb2 backup.tar -U postgres
i have an error like
"pg_restore:[archiver(db)] connection to database "mydb2" failed:
FATAL : password authentication failed for user "postgres""
i check my password on psql , pg_dump and other programs there is no problem