Re: Incremental Backups in postgres

On Tuesday 10 November 2009, akp geek <akpgeek@gmail.com> wrote:
> So Is it always good to have the backup using PG_dump instead of PITR or
> a combination of both
>

I like to do both. Ongoing PITR, daily base backups (by updating an rsync
copy), and weekly pg_dumps that in turn go to tape.

PITR gives a very recent restore point in the event of server loss. As
previously mentioned, the full (custom) backups let you restore individual
tables. They're also a lot smaller than base backups + WAL logs.

--
"No animals were harmed in the recording of this episode. We tried but that
damn monkey was just too fast."