From:
Simon Riggs <simon(at)2ndQuadrant(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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-29 18:23:29
Message-ID:
1243621409.31613.61.camel@ebony.2ndQuadrant (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
On Thu, 2009-05-28 at 18:09 -0400, Tom Lane wrote:
> 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?
Well, in one way, yes. I certainly encourage Guillaume to submit more
patches and for everybody to review them, as has been done. I turned up
late to the party on this, I know.
Regrettably, the patch doesn't remove the problem it was supposed to
remove and I'm highlighting there is still risk of data loss. I suggest
that we don't change any docs, and carefully word or even avoid any
release note inclusion to avoid lulling people into stopping safety
measures.
The patch doesn't cause any problems though so we don't need to remove
it either.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2009-05-29 18:35:59Subject : Re: information_schema.columns changes needed for OLEDB Previous :From : Tom LaneDate : 2009-05-29 18:16:26Subject : Re: [GENERAL] trouble with to_char('L')
