Re: Proposal: Incremental Backup - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Proposal: Incremental Backup
Date
Msg-id 20140807152528.GC17563@momjian.us
Whole thread Raw
In response to Re: Proposal: Incremental Backup  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: Proposal: Incremental Backup
List pgsql-hackers
On Thu, Aug  7, 2014 at 08:35:53PM +0900, Michael Paquier wrote:
> On Thu, Aug 7, 2014 at 8:11 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
> > There are some data which don't have LSN, for example, postgresql.conf.
> > When such data has been modified since last backup, they also need to
> > be included in incremental backup? Probably yes.
> Definitely yes. That's as well the case of paths like pg_clog,
> pg_subtrans and pg_twophase.

I assumed these would be unconditionally backed up during an incremental
backup because they relatively small and you don't want to make a mistake.

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + Everyone has their own god. +



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: A worst case for qsort
Next
From: Fabien COELHO
Date:
Subject: Re: Enhancing pgbench parameter checking