restoring large objects - Mailing list pgsql-admin

From Marion McKelvie
Subject restoring large objects
Date
Msg-id MPEMKONPODHGLICHEKEGOEIMCOAA.marion@streamlet.co.uk
Whole thread Raw
Responses Re: restoring large objects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Please can anyone confirm (or otherwise) the situation with restoring large
objects?

I am running with 7.1.2 (I know it's old, but I don't have a lot of choice
given the application running on it), and have dumped the database with
the -b option.  However, the restoration process generates new ids for the
large objects which means the link between the data table referencing them
and the content of pg_largeobject is lost.  I have seen a reference in the
list archives to this being a bug, but can not find any reference to a
workround or resolution.  Does anyone know if there is one?

I have a separate newer installation on 7.3.4.  Is this still a problem on
the newer versions?

Many thanks for any assistance

Marion


pgsql-admin by date:

Previous
From: Daniel Rubio
Date:
Subject: Re: possible bug with sequences
Next
From: Tom Lane
Date:
Subject: Re: restoring large objects