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

Differential backup

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Differential backup
Date: 2010-04-27 13:30:14
Message-ID: 1272375014.4161.7260.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-hackers
Thinking about allowing a backup to tell which files have changed in the
database since last backup. This would allow an external utility to copy
away only changed files.

Now there's a few ways of doing this and many will say this is already
possible using file access times.

An explicit mechanism where Postgres could authoritatively say which
files have changed would make many feel safer, especially when other
databases also do this.

We keep track of which files require fsync(), so we could also keep
track of changed files using that same information.

Is this route worthwhile? Or in some way unacceptable?

-- 
 Simon Riggs           www.2ndQuadrant.com


Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-04-27 13:50:44
Subject: Re: Differential backup
Previous:From: Simon RiggsDate: 2010-04-27 13:20:53
Subject: Re: recovery_connections cannot start

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