Re: problems with pg_dumplo (was Re: backup with blobs) - Mailing list pgsql-general

From Peter Pilsl
Subject Re: problems with pg_dumplo (was Re: backup with blobs)
Date
Msg-id 20010420031229.D9719@i3.atat.at
Whole thread Raw
In response to Re: problems with pg_dumplo (was Re: backup with blobs)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: problems with pg_dumplo (was Re: backup with blobs)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: problems with pg_dumplo (was Re: backup with blobs)
Next
From: Tom Lane
Date:
Subject: Re: problems with pg_dumplo (was Re: backup with blobs)