From: | Volkmar Wieners <volkmar(at)hammerdeals(dot)de> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Lost oid restoring dump with blobs |
Date: | 2001-06-21 17:45:41 |
Message-ID: | 200106211745.TAA14345@gator.hammerdeals.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi!
I've a restoring problem with a pg-db contains images stored in blobs: I want
to copy the whole content of the db with a dump-file from a solaris
to a linux server (both postgresql 7.1.2). While inserting the dump
(created by pg_dump) pg_restore changes all "oids" of the blobs into new
ones. So I've no access to the blobs anymore because the old "oids" stored
in the tables. Is there a chance to tell pg_restore: "leave the original
oids untouched"?
I've alredy tried tar or archiver format (-Ft and -Fc), -o and -N in
many combination without success. Thanx for any advice!
cu,
Volkmar
--
Volkmar Wieners volkmar(dot)wieners(at)gmx(dot)de
hammerdeals.de AG http://www.wieners.net
Dortmund +49-231-51980-25 (Fax -11)
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis | 2001-06-21 19:28:40 | Re: rename a table |
Previous Message | Tom Lane | 2001-06-21 14:56:54 | Re: Problems upgrading from 7.1beta4 to 7.1.0 |