Re: Incremental backup

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Patrick Macdonald <patrickm(at)redhat(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Incremental backup
Date: 2003-02-14 10:28:51
Message-ID: vegp4vcvq9gvl6i65fv046rka0k7r8r4ls@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, 13 Feb 2003 19:24:13 -0500, Patrick Macdonald
<patrickm(at)redhat(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Brown 2003-02-14 10:58:49 Re: location of the configuration files
Previous Message Daniel Kalchev 2003-02-14 08:19:15 Re: [HACKERS] Changing the default configuration