Horton

Re: Incremental backup

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: Patrick Macdonald <patrickm@redhat.com>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Martin Marques <martin@bugs.unl.edu.ar>, pgsql-hackers@postgresql.org
Date: 2003-02-14T10:28:51Z
Lists: pgsql-hackers 
On Thu, 13 Feb 2003 19:24:13 -0500, Patrick Macdonald
<patrickm@redhat.com> wrote:
>I know Oracle and DB2 have incremental backup in their arsenal (and iirc,
>SQL Server has something called "differential backup").  Whatever the name,
>it's a win at the enterprise level. 

"A differential backup copies only the database pages that have been
modified after the last full database backup."

This could be doable using XLogRecPtr pd_lsn in the page headers, but
I don't see an easy way to do it on a live database.

Servus
 Manfred