From 18d938de7a99d698d33cc3a94507c8fe0a0005ab Mon Sep 17 00:00:00 2001 From: Fujii Masao Date: Thu, 24 Sep 2015 23:31:17 +0900 Subject: [PATCH] Make pg_controldata report newest XID with valid commit timestamp Previously pg_controldata didn't report newestCommitTs and this was an oversight in commit 73c986a. Also this patch changes pg_resetxlog so that it uses the same sentences as pg_controldata does, regarding oldestCommitTs and newestCommitTs, for the sake of consistency. Back-patch to 9.5 where track_commit_timestamp was added. Euler Taveira --- src/bin/pg_controldata/pg_controldata.c | 2 ++ src/bin/pg_resetxlog/pg_resetxlog.c | 4 ++-- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/src/bin/pg_controldata/pg_controldata.c b/src/bin/pg_controldata/pg_controldata.c index 704f72d3c5..32e1d81bf2 100644 --- a/src/bin/pg_controldata/pg_controldata.c +++ b/src/bin/pg_controldata/pg_controldata.c @@ -273,6 +273,8 @@ main(int argc, char *argv[]) ControlFile.checkPointCopy.oldestMultiDB); printf(_("Latest checkpoint's oldestCommitTs: %u\n"), ControlFile.checkPointCopy.oldestCommitTs); + printf(_("Latest checkpoint's newestCommitTs: %u\n"), + ControlFile.checkPointCopy.newestCommitTs); printf(_("Time of latest checkpoint: %s\n"), ckpttime_str); printf(_("Fake LSN counter for unlogged rels: %X/%X\n"), diff --git a/src/bin/pg_resetxlog/pg_resetxlog.c b/src/bin/pg_resetxlog/pg_resetxlog.c index c8c1ac3288..d7ac2ba271 100644 --- a/src/bin/pg_resetxlog/pg_resetxlog.c +++ b/src/bin/pg_resetxlog/pg_resetxlog.c @@ -665,9 +665,9 @@ PrintControlValues(bool guessed) ControlFile.checkPointCopy.oldestMulti); printf(_("Latest checkpoint's oldestMulti's DB: %u\n"), ControlFile.checkPointCopy.oldestMultiDB); - printf(_("Latest checkpoint's oldest CommitTs: %u\n"), + printf(_("Latest checkpoint's oldestCommitTs: %u\n"), ControlFile.checkPointCopy.oldestCommitTs); - printf(_("Latest checkpoint's newest CommitTs: %u\n"), + printf(_("Latest checkpoint's newestCommitTs: %u\n"), ControlFile.checkPointCopy.newestCommitTs); printf(_("Maximum data alignment: %u\n"), ControlFile.maxAlign); -- 2.40.0