BUG #1503: pg_restore cannot restore a backup

From: "Yavuz" <stern_ix(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1503: pg_restore cannot restore a backup
Date: 2005-02-22 19:46:26
Message-ID: 20050222194626.5D11CF0B05@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 1503
Logged by: Yavuz
Email address: stern_ix(at)yahoo(dot)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

Browse pgsql-bugs by date

  From Date Subject
Next Message Nicolas Rachinsky 2005-02-22 19:49:05 BUG #1504: Wrong user is used for sequences through rules
Previous Message Thomas 2005-02-22 16:01:35 BUG #1502: hash_seq_search might return removed entry