Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group