Lost oid restoring dump with blobs

Поиск
Список
Период
Сортировка
От Volkmar Wieners
Тема Lost oid restoring dump with blobs
Дата
Msg-id 200106211745.TAA14345@gator.hammerdeals.de
обсуждение исходный текст
Список 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.wieners@gmx.de
  hammerdeals.de AG        http://www.wieners.net
  Dortmund             +49-231-51980-25 (Fax -11)

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Problems upgrading from 7.1beta4 to 7.1.0
Следующее
От: "Yasuo Ohgaki"
Дата:
Сообщение: Re: Gradual increase in CPU utilization by postmaster