From: | Peter Pilsl <pilsl(at)goldfisch(dot)at> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problems with pg_dumplo (was Re: backup with blobs) |
Date: | 2001-04-20 01:12:29 |
Message-ID: | 20010420031229.D9719@i3.atat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-04-20 01:16:38 | Re: problems with pg_dumplo (was Re: backup with blobs) |
Previous Message | Hiroshi Inoue | 2001-04-20 01:04:40 | Re: How to configure iodbc access to local postgres db? |