Обсуждение: Lost oid restoring dump with blobs

Поиск
Список
Период
Сортировка

Lost oid restoring dump with blobs

От
Volkmar Wieners
Дата:
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.wieners@gmx.de
  hammerdeals.de AG        http://www.wieners.net
  Dortmund             +49-231-51980-25 (Fax -11)