Re: Incremental Backup Script

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Gregor Zeitlinger <gregor(dot)zeitlinger(at)torexretail(dot)de>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incremental Backup Script
Date: 2005-12-26 11:04:26
Message-ID: 1135595066.2964.660.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 2005-12-25 at 14:02 +0100, Gregor Zeitlinger wrote:
> as far as I have understood, the WAL backup that you control via
> "archive_command" is the PostgreSQL equivalent to what other databases
> let you do with an incremental backup

No it is not an incremental backup of changed data blocks, it is a
transactional log archival. So, other parts of your thinking are
slightly off - but not by much. The only way to do a partial recovery is
to follow the PITR notes.

Best Regards, Simon Riggs

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-12-26 12:03:27 Re: [Bizgres-general] WAL bypass for INSERT, UPDATE and
Previous Message Bruce Momjian 2005-12-26 05:15:12 Re: Fixing row comparison semantics