Fix bug in processing of checkpoint time for max_standby_delay. Latest

simonat2ndQuadrant · simonat2ndQuadrant · commit 4a24c9a06325 · 2010-05-15T07:14:43.000Z
log time was incorrectly set, typically leading to dates in the past,
which would cause more cancellations in Hot Standby on a quiet server.
diff --git a/src/backend/access/transam/xlog.c b/src/backend/access/transam/xlog.c
@@ -7,7 +7,7 @@
  * Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group
  * Portions Copyright (c) 1994, Regents of the University of California
  *
- * $PostgreSQL: pgsql/src/backend/access/transam/xlog.c,v 1.411 2010/05/14 07:11:48 sriggs Exp $
+ * $PostgreSQL: pgsql/src/backend/access/transam/xlog.c,v 1.412 2010/05/15 07:14:43 sriggs Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -5450,7 +5450,7 @@ recoveryStopsHere(XLogRecord *record, bool *includeThis)
 			CheckPoint	checkPoint;
 
 			memcpy(&checkPoint, XLogRecGetData(record), sizeof(CheckPoint));
-			recoveryLastXTime = checkPoint.time;
+			recoveryLastXTime = time_t_to_timestamptz(checkPoint.time);
 		}
 
 		/*

Original file line number	Diff line number	Diff line change
`@@ -7,7 +7,7 @@`
`7`	`7`	`* Portions Copyright (c) 1996-2010, PostgreSQL Global Development Group`
`8`	`8`	`* Portions Copyright (c) 1994, Regents of the University of California`
`9`	`9`	`*`
`10`		`- * $PostgreSQL: pgsql/src/backend/access/transam/xlog.c,v 1.411 2010/05/14 07:11:48 sriggs Exp $`
	`10`	`+ * $PostgreSQL: pgsql/src/backend/access/transam/xlog.c,v 1.412 2010/05/15 07:14:43 sriggs Exp $`
`11`	`11`	`*`
`12`	`12`	`*-------------------------------------------------------------------------`
`13`	`13`	`*/`
`@@ -5450,7 +5450,7 @@ recoveryStopsHere(XLogRecord record, bool includeThis)`
`5450`	`5450`	`CheckPoint checkPoint;`
`5451`	`5451`
`5452`	`5452`	`memcpy(&checkPoint, XLogRecGetData(record), sizeof(CheckPoint));`
`5453`		`- recoveryLastXTime = checkPoint.time;`
	`5453`	`+ recoveryLastXTime = time_t_to_timestamptz(checkPoint.time);`
`5454`	`5454`	`}`
`5455`	`5455`
`5456`	`5456`	`/*`