From:
Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To:
Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc:
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.
Date:
2011-03-07 09:47:20
Message-ID:
AANLkTik4tuG2EA6oeiov1=DO6UcDoARP45Lk+KGfy7HC@mail.gmail.com (view raw or flat )
Thread:
2011-03-06 22:51:56 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-06 23:09:53 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-03-06 23:28:45 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-07 07:29:48 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-07 07:48:11 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-07 07:54:19 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-07 13:30:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-03-07 14:02:44 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-07 14:21:46 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-03-07 14:29:04 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2011-03-07 15:03:10 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-03-07 15:13:46 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-07 15:46:52 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-07 15:51:49 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2011-03-07 16:09:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2011-03-18 09:27:13 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 13:16:24 from MARK CALLAGHAN <mdcallag(at)gmail(dot)com>
2011-03-18 13:30:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 13:40:22 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 14:37:26 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 16:03:03 from MARK CALLAGHAN <mdcallag(at)gmail(dot)com>
2011-03-18 14:19:18 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 14:52:13 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 15:43:38 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 15:47:46 from Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
2011-03-18 16:19:31 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 16:33:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 16:48:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 17:35:46 from Greg Stark <gsstark(at)mit(dot)edu>
2011-03-18 19:17:56 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 19:19:06 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 19:29:50 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 19:34:18 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 19:41:00 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 21:08:11 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2011-03-18 21:26:00 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-22 20:33:11 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-23 07:27:13 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-23 11:52:22 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-23 12:16:39 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-23 15:24:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 21:18:28 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 21:24:03 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 21:30:04 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 21:43:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 21:48:33 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 22:47:54 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-19 19:27:04 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-25 12:12:05 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-18 16:27:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-18 19:22:20 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 14:19:56 from Markus Wanner <markus(at)bluegap(dot)ch>
2011-03-18 15:52:18 from MARK CALLAGHAN <mdcallag(at)gmail(dot)com>
2011-03-07 15:04:22 from Aidan Van Dyk <aidan(at)highrise(dot)ca>
2011-03-07 14:55:11 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-03-06 23:28:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-03-06 23:36:30 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2011-03-06 23:38:30 from Jaime Casanova <jaime(at)2ndquadrant(dot)com>
2011-03-06 23:52:49 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-07 08:27:16 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-07 08:44:52 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-07 09:30:35 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-07 09:47:20 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-10 21:28:12 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 14:10:03 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-19 01:12:52 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-03-23 15:53:30 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-07 09:20:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-07 09:28:25 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-07 11:21:39 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-10 20:04:57 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-11 10:46:03 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-17 17:46:37 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-17 17:56:36 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 06:25:06 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-18 12:25:49 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 14:55:56 from Greg Stark <gsstark(at)mit(dot)edu>
2011-03-18 15:07:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 15:40:57 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-25 11:53:15 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-17 17:52:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-18 05:45:44 from Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
2011-03-18 07:52:07 from Simon Riggs <simon(at)2ndQuadrant(dot)com>
2011-03-18 12:16:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-03-10 20:44:33 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-committers pgsql-hackers
On Mon, Mar 7, 2011 at 6:30 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Mon, 2011-03-07 at 17:44 +0900, Fujii Masao wrote:
>
>> The above check should be required also after pg_ctl reload since
>> synchronous_standby_names can be changed by SIGHUP?
>> Or how about just removing that? If the patch I submitted is
>> committed,empty synchronous_standby_names and max_wal_senders = 0
>> settings is no longer unsafe.
>
> Ah, on reload. I plugged the gap only at startup.
>
> I'll fix by changing assign_synchronous_standby_names(), not by changing
> lots of other parts of code and making runtime check each COMMIT.
I don't think that the check of local variable for each COMMIT wastes the
cycle so much. Anyway, the reload of the configuration file should not
cause the server to end unexpectedly. IOW, GUC assign hook should
use GUC_complaint_elevel instead of FATAL, in ereport. The attached
patch fixes that, and includes two typo fixes.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
In response to
Responses
pgsql-hackers by date
Next :From: Thom BrownDate: 2011-03-07 09:57:18
Subject : Sync rep doc corrections
Previous :From : Heikki LinnakangasDate : 2011-03-07 09:31:22
Subject : Re: Composite Index Structure
pgsql-committers by date
Next :From: Fujii MasaoDate: 2011-03-07 11:21:39
Subject : Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication.
Previous :From : Simon RiggsDate : 2011-03-07 09:30:35
Subject : Re: [COMMITTERS] pgsql: Efficient transaction-controlled
synchronous replication.