Re: problems with pg_dumplo (was Re: backup with blobs)

Peter Pilsl <pilsl@goldfisch.at> writes:
> pg_dumplo: lo_import: can't create inv object for ".//peter/blobtest/lo_oid/70643"

> When I comment the 70653-blob in the index-file, the error will come
> up at the next blob. When I try very often, the error will come up at
> an earlier blob or later.

Hmm.  About how many blobs are you able to import before the error
happens?

I believe that 7.0.* and before have some (platform dependent) limits on
the number of large objects touched in a single transaction.  It could
be that that's what you're running up against.  This problem is gone in
7.1.

            regards, tom lane