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

Re: Command to prune archive at restartpoints

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Command to prune archive at restartpoints
Date: 2010-06-10 20:09:05
Message-ID: 1276200545.23257.8560.camel@ebony (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, 2010-06-10 at 22:49 +0300, Heikki Linnakangas wrote:
> On 10/06/10 22:24, Dimitri Fontaine wrote:
> > Heikki Linnakangas<heikki(dot)linnakangas(at)enterprisedb(dot)com>  writes:
> >> Maybe we could add a new pg_cleanuparchive binary, but we'll need some
> >> discussion...
> >
> > Would this binary ever be used manually, not invoked by PostgreSQL? As
> > it depends on the %r option to be given and to be right, I don't think
> > so.
> 
> Hmm, actually it would be pretty handy. To make use of a base backup, 
> you need all the WAL files following the one where pg_start_backup() was 
> called. We create a .backup file in the archive to indicate that 
> location, like:
> 
> 00000001000000000000002F.00000020.backup
> 
> So to clean up all WAL files older than those needed by that base 
> backup, you would simply copy-paste that location and call 
> pg_cleanuparchive:
> 
> pg_cleanuparchive /walarchive/ 00000001000000000000002F

OK, sounds like we're on the same thought train.

Here's the code.

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Development, 24x7 Support, Training and Services

Attachment: pg_archivecleanup.tar
Description: application/x-tar (10.0 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Greg SmithDate: 2010-06-10 20:15:44
Subject: Re: Large (almost 50%!) performance drop after upgrading to 8.4.4?
Previous:From: Heikki LinnakangasDate: 2010-06-10 19:49:00
Subject: Re: Command to prune archive at restartpoints

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