Re: When pg_rewind success, the database can't startup - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: When pg_rewind success, the database can't startup
Date
Msg-id 20180619080057.GE31737@paquier.xyz
Whole thread Raw
In response to When pg_rewind success, the database can't startup  (hemin <min.he@ww-it.cn>)
Responses Re: When pg_rewind success, the database can't startup  (hemin <min.he@ww-it.cn>)
List pgsql-bugs
On Tue, Jun 19, 2018 at 03:56:15PM +0800, hemin wrote:
> I do not checkpoint before running pg_rewind, because the checkpoint
> of rewound primary node is obviously slow than the promoted standby,
> But I will try it later.

You need to run the checkpoint on the promoted standby.  That's actually
a critical thing to do to ensure consistency..  Of course this depends
on how you set max_wal_size.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: hemin
Date:
Subject: Re: When pg_rewind success, the database can't startup
Next
From: hemin
Date:
Subject: Re: When pg_rewind success, the database can't startup