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
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 |