Re: Incremental Backup Script - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Incremental Backup Script
Date
Msg-id 1135595066.2964.660.camel@localhost.localdomain
Whole thread Raw
In response to Incremental Backup Script  ("Gregor Zeitlinger" <gregor.zeitlinger@torexretail.de>)
List 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





pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: [PATCHES] default resource limits
Next
From: Bruce Momjian
Date:
Subject: Re: Fixing row comparison semantics