On Thu, Apr 19, 2001 at 08:41:14PM -0400, Tom Lane wrote:
> 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.
>
It depends ... from 5 to 15 I guess. I'll write a wrapper around to
split the stuff in small chunks and post it here if I get it to work ...
Problem is: I need a working blob-backup before migrating to 7.1 or
I'll loose em while upgrading (There are 1000's of blobs I need to process here ...)
thnx,
peter
--
mag. peter pilsl
phone: +43 676 3574035
fax : +43 676 3546512
email: pilsl@goldfisch.at
sms : pilsl@max.mail.at
pgp-key available