Re: database backup - Mailing list pgsql-general

From Lamar Owen
Subject Re: database backup
Date
Msg-id 200207062303.12635.lamar.owen@wgcr.org
Whole thread Raw
In response to Re: database backup  (Doug Fields <dfields-pg-general@pexicom.com>)
Responses Re: database backup
List 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 by date:

Previous
From: Doug Fields
Date:
Subject: Re: Odd new symptom - database locking up on a query
Next
From: Martijn van Oosterhout
Date:
Subject: Re: database backup