From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Joseph M(dot) Day" <jday(at)gisolutions(dot)us> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Backup |
Date: | 2005-03-23 22:37:55 |
Message-ID: | 15119.1111617475@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
"Joseph M. Day" <jday(at)gisolutions(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2005-03-23 23:15:53 | Re: Clustering |
Previous Message | Jonathan Nalley | 2005-03-23 22:22:06 | Re: Any examples of companies using PG in high volume |