Re: Avoiding shutdown checkpoint at failover
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-11-01T13:48:08Z
Lists: pgsql-hackers
Simon Riggs <simon@2ndQuadrant.com> writes: > The reason we run a shutdown checkpoint is to prevent needing to > re-enter recovery if we crash after promotion. That's *a* reason, it's not necessarily the only reason. This proposal worries me, especially your blithe dismissal of the timeline issues; but in any case I would not trust it without a detailed review of all WAL replay activities, which you don't sound to have done. regards, tom lane