Horton
Menu

Re: Command to prune archive at restartpoints

Simon Riggs <simon@2ndquadrant.com>

View thread
From: Simon Riggs <simon@2ndQuadrant.com>
To: Andrew Dunstan <andrew@dunslane.net>
Cc: Robert Haas <robertmhaas@gmail.com>, Greg Stark <gsstark@mit.edu>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-06-09T07:21:08Z
Lists: pgsql-hackers 
On Tue, 2010-06-08 at 18:30 -0400, Andrew Dunstan wrote:

> I prefer archive_cleanup_command. We should name things after their 
> principal function, not an implementation detail, IMNSHO.
> 
> More importantly, we should include an example in the docs. I created 
> one the other day  when this was actually bothering me a bit (see 
> <http://people.planetpostgresql.org/andrew/index.php?/archives/85-Keeping-a-hot-standby-log-archive-clean.html>). 
> That seemed to work ok, but maybe it's too long, and maybe people would 
> prefer a shell script to perl.

I submitted a patch to make the command "pg_standby -a %r"

That's a more portable solution, ISTM.

I'll commit that and fix the docs.

-- 
 Simon Riggs           www.2ndQuadrant.com