Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)

From: Ron Snyder <snyder(at)roguewave(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)
Date: 2002-05-31 21:44:54
Message-ID: F888C30C3021D411B9DA00B0D0209BE803BB9A35@cvo-exchange.cvo.roguewave.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm trying to determine if database growth (with LO) that I'm seeing during
a pg_restore is fixed by the patch identified at
http://archives.postgresql.org/pgsql-hackers/2002-04/msg00496.php , but when
I attempt to restore from a 7.2.1 created dump into my newly created
7.3devel database, I get this:

pg_restore: [archiver (db)] could not create large object cross-reference
table:

I didn't find any mention of this on the hackers mail archive, so I thought
I'd pass it on.

The dump file was created with:
pg_dump --blobs --format=c --quotes --oids --compress=5 quickview >
quickview.dump

and restored with:
pg_restore -d quickview < quickview.dump
(although I don't think either of those are the problem, because we've used
those command lines successfully with 7.2 and 7.2.1 w/o problems).

If nobody else is having this problem I'll see if I can create a small test
case. (my dump file is 10 gigs)

-ron

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-05-31 22:24:08 Re: Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)
Previous Message Tom Lane 2002-05-31 17:22:32 Re: Small changes to facilitate Win32 port