The following bug has been logged online: Bug reference: 5751 Logged by: Michael Feldmann Email address: michael.feldm...@uni-muenster.de PostgreSQL version: 8.4.5 Operating system: Ubuntu Description: pg_restore does not work correctly with BLOBs Details:
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. Best Regards Michael Feldmann --- ZIV, University of Muenster, Germany -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs