The following bug has been logged online:
Bug reference: 1503
Logged by: Yavuz
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
