How to back up large objects?
От | Chris Carbaugh |
---|---|
Тема | How to back up large objects? |
Дата | |
Msg-id | 200010190335.XAA20568@regulus.blazenet.net обсуждение исходный текст |
Список | 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
В списке pgsql-general по дате отправления: