Backup of a big DB with a lot of large objects

Поиск
Список
Период
Сортировка
От Milen A. Radev
Тема Backup of a big DB with a lot of large objects
Дата
Msg-id 32c009ea0611300812p4e5ed4acvf45537d1c70dfea0@mail.gmail.com
обсуждение исходный текст
Ответы Re: Backup of a big DB with a lot of large objects
Список pgsql-admin
We have a big DB that's backuped nightly using pg_dump in the custom
format. Most of its size are several thousand large objects. During
the dump of those LO the machine is heavily loaded so we are looking
for a way to "optimise" that part of backup process. We had an idea to
backup the DB but without the LO and to dump nightly only those LO
that were changed or added since the last backup. Unfortunately in
v8.1 (we use 8.1.5) there is no way to dump a whole database without
the LO.

Any ideas for a less taxing backup process?

--
Milen A. Radev

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

Предыдущее
От: Bradley Kieser
Дата:
Сообщение: Re: Out of file-descriptors message
Следующее
От: Steve Holdoway
Дата:
Сообщение: Re: Backup of a big DB with a lot of large objects