On 27 January 2017 at 09:59, Nikhil Sontakke <[email protected]> wrote: >>> But, I put the recovery process and the checkpointer process of the >>> standby under gdb with breakpoints on these functions, but both did >>> not hit CreateRestartPoint() as well as CheckPointGuts() when I issued >>> a promote :-| >> >> No end-of-recovery checkpoints happen at promotion since 9.3. You can >> still use fallback_promote as promote file to trigger the pre-9.2 (9.2 >> included) behavior. > > Ok, so that means, we also need to fsync out these 2PC XIDs at promote > time as well for their durability.
Why? The data files haven't been fsynced either at that point. If there is a bug there it doesn't just affect 2PC. What sequence of actions would cause data loss? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
