From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc:
Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>,
Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>,
Andreas Pflug <pgadmin(at)pse-consulting(dot)de>,
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>,
pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Clean shutdown and warm standby
Date:
2009-05-28 22:09:24
Message-ID:
1493.1243548564@sss.pgh.pa.us (view raw or flat )
Thread:
2009-04-08 19:11:28 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-04-09 03:00:32 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-04-09 09:36:23 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-04-09 09:47:07 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-04-14 20:58:03 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-04-24 06:20:09 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-27 11:28:12 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-04-27 11:43:05 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-27 12:25:49 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-04-27 13:02:19 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-27 13:15:37 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2009-04-27 21:43:17 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2009-04-28 05:30:08 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-28 14:16:31 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-28 15:14:34 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
2009-04-28 15:22:18 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-04-28 15:35:36 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-05-27 21:35:21 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-05-28 11:04:25 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 13:06:15 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 13:19:33 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 13:29:27 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 13:52:44 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 14:08:03 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 14:21:42 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 14:41:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 15:02:13 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 15:16:12 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-05-28 15:36:10 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 15:50:10 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-05-28 16:06:13 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 16:16:35 from Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>
2009-05-28 16:41:17 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 16:58:04 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-28 21:47:14 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 22:09:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-05-29 18:23:29 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-29 18:46:25 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2009-05-29 19:45:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-29 18:54:02 from Robert Haas <robertmhaas(at)gmail(dot)com>
2009-05-29 20:37:47 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-30 00:16:49 from Euler Taveira de Oliveira <euler(at)timbira(dot)com>
2009-05-30 16:51:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2009-05-28 15:03:08 from Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Lists:
pgsql-hackers
Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> Thus there is no guarantee that this is sufficient to have archived all
> the files you would like to archive. The patch does not provide a clean
> shutdown in all cases and since you don't know what state its in, you
> are still forced to take external action to be safe, exactly as you do
> already.
> If I didn't already say, I came up with exactly the same solution 2
> years ago and then later explained it didn't work in all cases. I'm
> saying the same thing again here now.
What's your point? Surely the applied patch is a *necessary* component
of any attempt to try to ensure archiving is complete at shutdown.
I agree that it doesn't cover every risk factor, and there are some
risk factors that cannot be covered by Postgres itself. But isn't it
a step in a desirable direction?
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-05-28 22:16:56Subject : Re: pg_migrator and an 8.3-compatible tsvector data type Previous :From : Joshua TolleyDate : 2009-05-28 22:07:39Subject : Dtrace probes documentation
