Re: Backup - Mailing list pgsql-admin

From Tom Lane
Subject Re: Backup
Date
Msg-id 15119.1111617475@sss.pgh.pa.us
Whole thread Raw
In response to Backup  ("Joseph M. Day" <jday@gisolutions.us>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: "Jonathan Nalley"
Date:
Subject: Re: Any examples of companies using PG in high volume
Next
From: Andrew Sullivan
Date:
Subject: Re: Clustering