Don't forget to flush XLOG_PARAMETER_CHANGE record.

MasaoFujii · MasaoFujii · commit 0af5fd82e0ca · 2014-03-26T02:38:14.000+09:00
Backpatch to 9.0 where XLOG_PARAMETER_CHANGE record was instroduced.
diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c
@@ -7955,6 +7955,7 @@ XLogReportParameters(void)
 		{
 			XLogRecData rdata;
 			xl_parameter_change xlrec;
+			XLogRecPtr	recptr;
 
 			xlrec.MaxConnections = MaxConnections;
 			xlrec.max_prepared_xacts = max_prepared_xacts;
@@ -7966,7 +7967,8 @@ XLogReportParameters(void)
 			rdata.len = sizeof(xlrec);
 			rdata.next = NULL;
 
-			XLogInsert(RM_XLOG_ID, XLOG_PARAMETER_CHANGE, &rdata);
+			recptr = XLogInsert(RM_XLOG_ID, XLOG_PARAMETER_CHANGE, &rdata);
+			XLogFlush(recptr);
 		}
 
 		ControlFile->MaxConnections = MaxConnections;

Original file line number	Diff line number	Diff line change
`@@ -7955,6 +7955,7 @@ XLogReportParameters(void)`
`7955`	`7955`	`{`
`7956`	`7956`	`XLogRecData rdata;`
`7957`	`7957`	`xl_parameter_change xlrec;`
	`7958`	`+ XLogRecPtr recptr;`
`7958`	`7959`
`7959`	`7960`	`xlrec.MaxConnections = MaxConnections;`
`7960`	`7961`	`xlrec.max_prepared_xacts = max_prepared_xacts;`
`@@ -7966,7 +7967,8 @@ XLogReportParameters(void)`
`7966`	`7967`	`rdata.len = sizeof(xlrec);`
`7967`	`7968`	`rdata.next = NULL;`
`7968`	`7969`
`7969`		`- XLogInsert(RM_XLOG_ID, XLOG_PARAMETER_CHANGE, &rdata);`
	`7970`	`+ recptr = XLogInsert(RM_XLOG_ID, XLOG_PARAMETER_CHANGE, &rdata);`
	`7971`	`+ XLogFlush(recptr);`
`7970`	`7972`	`}`
`7971`	`7973`
`7972`	`7974`	`ControlFile->MaxConnections = MaxConnections;`