Обсуждение: Backup/restore large objects?

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

Backup/restore large objects?

От
CTN Production
Дата:
What is the best way to backup and restore large objects in the
database?  I don't think dump/dumpall can handle large objects or
certain column types like serial.  I hope there is a good way to do it
such that if I upgrade to a new version of postgresql, I will be able to
restore everything.  I understand that tar.gzing the data directory will
not work if the difference between versions changes too much.

Robert B. Easter
reaster@comptechnews.com  (please cc me here, thx).