db dump: handling large objects

Поиск
Список
Период
Сортировка
От Doug Pinney
Тема db dump: handling large objects
Дата
Msg-id 99tn59$4m6$1@news.tht.net
обсуждение исходный текст
Список pgsql-admin
is there a good way to handle large objects when backing up a database?  the
way it looks is that the large objects are external files on the file system
and are just pointed to by entries in the table.  But it looks like when you
dump the database and then try to restore it, the object ids no longer synch
up.

It's been awhile since we had to deal with this problem but now I have to
create a backup plan.  How do you properly back up tables with large objects
(for restoring, or for transferring database to a different server)?

--Doug

p.s. or am i missing something?  or does recent versions of pgsql handle
this differently?




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

Предыдущее
От: "dhninh"
Дата:
Сообщение:
Следующее
От: Mathijs Brands
Дата:
Сообщение: Re: [HACKERS] Re: [PORTS] pgmonitor and Solaris