From: | Herbert Liechti <Herbert(dot)Liechti(at)thinx(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Bug in pg_dump/pg_restore |
Date: | 2001-10-19 18:12:11 |
Message-ID: | 3BD06CFB.8000303@thinx.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 an 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 restored?
Best regards
Herbie
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Herbert Liechti http://www.thinx.ch
ThinX networked business services Adlergasse 5, CH-4500 Solothurn
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Kreen | 2001-10-19 18:25:15 | Re: Installing PostgreSQL on winNT |
Previous Message | Lily | 2001-10-19 18:06:28 | Charset problem |