| 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: | Whole Thread | Raw Message | 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 |