Skip site navigation (1) Skip section navigation (2)

Re: pg_restore problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jules(dot)alberts(at)arbodienst-limburg(dot)nl
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_restore problem
Date: 2002-08-15 13:22:41
Message-ID: 22387.1029417761@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl> writes:
> This restores the OIDs of all my tables (as I expected), except the 
> BLOBs, lo_export(241803, '/tmp/foobar') says "ERROR inv_open large 
> object 241803 not found". This is a problem because I save the BLOBs 
> OID as a reference in other tables. Am I doing something wrong or is 
> this a known issue?

pg_restore should fix up OID references to BLOBs ... if they are in
columns of type OID (or type lo, if you've installed contrib/lo).
I suspect you stored all your OID references in integer columns?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2002-08-15 13:27:02
Subject: Re: FATAL 1:Sorry, too many clients
Previous:From: solDate: 2002-08-15 11:45:31
Subject: FATAL 1:Sorry, too many clients

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group