Hello all
I found a bug in pg_dump / pg_restore in the Release 7.1.2. I tried to
restore a database which was dumped with the following arguments:
pg_dump --blob -Fc mydb -f /home/backup/mydb.dump
Today I tried to restore the backup for testing purposes on an other
machine. The pg_restore complained about a table that does not exist. A
good thing that this was just a test. After recreating the table and
reloading the data in the newly created table the pg_dump/pg_restore
utility was working correctly again. A few days ago we added a additional
boolean attribute to that table with the alter table statement.
So, what is your advice to have secure backups? Is there a possiblity to
check wether a backup can properly be restored?
Best regards
Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti http://www.thinx.ch
ThinX networked business services Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~