From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joseph M. Day <jday@gisolutions.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: Backup
Date: Wed, 23 Mar 2005 17:37:55 -0500
Message-ID: <15119.1111617475@sss.pgh.pa.us> (raw)
In-Reply-To: <006d01c52fe8$b91868f0$6402a8c0@homepc>
References: <006d01c52fe8$b91868f0$6402a8c0@homepc>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, jday@gisolutions.us
Subject: Re: Backup
In-Reply-To: <15119.1111617475@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox