Re: database backup

Поиск
Список
Период
Сортировка
От Lamar Owen
Тема Re: database backup
Дата
Msg-id 200207062303.12635.lamar.owen@wgcr.org
обсуждение исходный текст
Ответ на Re: database backup  (Doug Fields <dfields-pg-general@pexicom.com>)
Ответы Re: database backup  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Saturday 06 July 2002 10:59 pm, Doug Fields wrote:
> If you want to "incrementalize" it, you could always keep a base, and diff
> the new dump against it, and store just the diff.

> Be sure to run the output through bzip2 (or gzip -9) to save space.

This doesn't work as well in practice as it would seem.  Due to funkiness, the
output of pg_dump isn't (or wasn't the last time I tried diffing dumps)
necessarily always in the same order.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11



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

Предыдущее
От: Doug Fields
Дата:
Сообщение: Re: Odd new symptom - database locking up on a query
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: database backup