The following bug has been logged online:
Bug reference: 5751
Logged by: Michael Feldmann
Email address: michael(dot)feldmann(at)uni-muenster(dot)de
PostgreSQL version: 8.4.5
Operating system: Ubuntu
Description: pg_restore does not work correctly with BLOBs
I start with a database containing only a BLOB.
Then I dump this database with pg_dump -Fc
Then I create a new database testblob
and restore the dump with the command
pg_restore -v -c -d testblob -O blob.dump
This works as expected.
But if I try restore the same dump again
with the same command I get the error message
pg_restore: restoring BLOBS
pg_restore: [archiver] could not create large object 25213
pg_restore: *** aborted because of error
If I first drop the database testblob and then
create it again everything works fine.
It seems that pg_restore does not clean the
old database completely, despite the -c flag.
We ran into this problem when writing an
automated mirroring script.
ZIV, University of Muenster, Germany
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2010-11-12 15:03:26|
|Subject: Re: Re: [BUGS] BUG #5650: Postgres service showing as stopped when in fact it is running |
|Previous:||From: Bruce Momjian||Date: 2010-11-12 14:08:45|
|Subject: Re: Re: [BUGS] BUG #5650: Postgres service showing
as stopped when in fact it is running|