From:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
To:
Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>,
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Command to prune archive at restartpoints
Date:
2010-06-09 07:21:08
Message-ID:
1276068068.12489.6512.camel@ebony (view raw or flat )
Thread:
2010-03-17 09:37:04 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-03-17 10:01:44 from Greg Stark <gsstark(at)mit(dot)edu>
2010-03-17 10:14:40 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-03-18 09:19:21 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-03-18 09:43:24 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-03-22 15:58:17 from Greg Stark <gsstark(at)mit(dot)edu>
2010-06-08 21:17:34 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-08 21:32:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-08 22:30:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-08 22:45:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-08 23:07:10 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-09 00:47:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-09 01:45:20 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-06-09 01:51:59 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-09 02:18:00 from Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
2010-06-09 02:58:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-09 07:19:29 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-09 02:00:41 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-09 07:21:08 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-10 07:18:08 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-10 07:28:25 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-10 14:17:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-10 14:38:20 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-10 15:19:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-10 15:33:25 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-10 19:24:41 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-10 19:49:00 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2010-06-10 20:09:05 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-13 16:22:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-11 18:18:57 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-12 18:00:03 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-12 20:51:48 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-13 16:31:31 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-13 17:04:28 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-13 18:25:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-13 18:51:14 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-13 19:03:58 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-14 04:02:39 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2010-06-14 10:21:35 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
2010-06-14 11:29:38 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2010-06-14 12:37:09 from Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
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
In response to
Responses
pgsql-hackers by date
Next :From: Dean RasheedDate: 2010-06-09 07:51:41Subject : Re: Invalid YAML output from EXPLAINPrevious :From : Simon RiggsDate : 2010-06-09 07:19:29Subject : Re: Command to prune archive at restartpoints
