Re: Command to prune archive at restartpoints
From:
Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, 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-14 10:21:35
Message-ID:
87typ5c3tc.fsf@hi-media-techno.com (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
Fujii Masao <masao(dot)fujii(at)gmail(dot)com> writes:
> In SR, WAL files in the pg_xlog directory on the standby are recycled
> by every restartpoints. So your proposed function seems not to be helpful
> even if hot_standby = on.
Then I guess I'm at a loss here: what is the pg_archivecleanup utility
good for in a standby?
--
dim
In response to
Responses
pgsql-hackers by date
Next :From: Magnus HaganderDate: 2010-06-14 10:21:41Subject : Re: warning message in standbyPrevious :From : Bruce MomjianDate : 2010-06-14 10:16:58Subject : Re: warning message in standby
