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

On Thu, Apr 19, 2001 at 08:41:14PM -0400, Tom Lane wrote:
> Peter Pilsl <pilsl(at)goldfisch(dot)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(at)goldfisch(dot)at
sms : pilsl(at)max(dot)mail(dot)at

pgp-key available