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

From Ron Snyder
Subject Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)
Date
Msg-id F888C30C3021D411B9DA00B0D0209BE803BB9A35@cvo-exchange.cvo.roguewave.com
Whole thread Raw
Responses Re: Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Small changes to facilitate Win32 port
Next
From: Tom Lane
Date:
Subject: Re: Can't import large objects in most recent cvs (20020531 -- approx 1pm PDT)