Bug in pg_dump/pg_restore
От | |
---|---|
Тема | Bug in pg_dump/pg_restore |
Дата | |
Msg-id | Pine.LNX.4.33.0110192108220.24135-100000@standbyme.thinx.ch обсуждение исходный текст |
Список | pgsql-general |
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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
В списке pgsql-general по дате отправления: