On Fri, May 26, 2017 at 2:39 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > Yeah, I think this is quite suspicious. This seems to indicate that > not all WAL records are replicated before the switchover. What is the > value of "synchronous_commit" you are using? I think you somehow need > to ensure before switchover that all the WAL is replicated to ensure > this is not a setup problem.
It is so easy to corrupt a server because of an incorrect base backup flow or an incorrect switchover that it would be good first to understand how you are doing your switchover. Any corruption happening after a promotion, a failover or a switchover may be the top of the iceberg of what's on the data pages, and you may just see one symptom among other problems. Particularly, did you kill the master in any violent way after promoting the standby? Has the former master been able to perform at least once a clean shutdown checkpoint and has it been rewound? -- Michael -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
