Re: database backup - Mailing list pgsql-general

From Curt Sampson
Subject Re: database backup
Date
Msg-id Pine.NEB.4.44.0207081209410.476-100000@angelic.cynic.net
Whole thread Raw
In response to Re: database backup  (Doug Fields <dfields-pg-general@pexicom.com>)
Responses Date Data Type  ("Jillian Carroll" <jillian@koskie.com>)
Re: database backup  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
On Sat, 6 Jul 2002, Doug Fields wrote:

> >Then the shell script in the cron job can call pg_dump with the relevant
> >options
>
> If you want to "incrementalize" it, you could always keep a base, and diff
> the new dump against it, and store just the diff.

Actually, I was wondering just yesterday, is there any reason that
pg_dump should not be able to do an incremental dump? You could just
give it a transaction ID and say, "dump all changes from this ID."

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC




pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Postgre vs MySQL
Next
From: "Jillian Carroll"
Date:
Subject: Date Data Type