Re: Backup

"Joseph M. Day" <jday@gisolutions.us> writes:
> It looks like pg_dump is the equivalent of a full backup, but
> how do I keep the equivalent of a Incremental, or Differential backup.

The only built-in mechanism for incremental backups at the moment is
archiving WAL logs via PITR.  See
http://www.postgresql.org/docs/8.0/static/backup-online.html

> To keep the same functionality, I will need a full backup once a week,
> and a differential once a day.

You might consider rsync'ing the database, though I'm not sure what sort
of performance that will give.

            regards, tom lane