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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Pilsl <pilsl(at)goldfisch(dot)at>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: problems with pg_dumplo (was Re: backup with blobs)
Date: 2001-04-20 00:41:14
Message-ID: 23541.987727274@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Inoue 2001-04-20 01:04:40 Re: How to configure iodbc access to local postgres db?
Previous Message Peter Pilsl 2001-04-20 00:12:23 problems with pg_dumplo (was Re: backup with blobs)