How to back up large objects?

From: Chris Carbaugh <cjtech2000(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to back up large objects?
Date: 2000-10-18 23:24:46
Message-ID: 200010190335.XAA20568@regulus.blazenet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I can't seem to figure out how to back up the large ogjects I have in my
DB.

Here's the situation:

I insert a large object (via PHP) into my DB. I also insert a record
into a table that uses the OID of the LO I inserted. I later expect to
pull the record out of the table, get the OID I stored of the LO, and
then export that object.

The question is: How do I backup the database including the large
objects? pg_dump doesn't seem to help me here. The only way I have
seen to access a large object is teh /lo_export command in psql.

so what is the common usage of large objects?

My main goal is a method of backing up a database that conists of a
table that stores the OID of the large objects, the large objects
themselves, and then restoring all of this to a new DB (whether it's on
the same machine or a different one). MInd you I have to have the
large objects maintain their origianl OID.

Any input appreciated.

Chris

--
"I think your slogan 'Liberty or Death' is splendid, and whichever one
you decide on will be all right with me." - Alexander Woollcott

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Larry Rosenman 2000-10-19 00:07:03 Re: [HACKERS] pg_connect error
Previous Message Neil Conway 2000-10-18 23:24:26 Re: MySQL PASSWORD('x') function workalike