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
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 |