On 2020/03/24 0:57, Fujii Masao wrote:
On 2020/03/24 0:17, Sergei Kornilov wrote:
Hello
You meant that the promotion request should cause the recovery
to finish immediately even if there are still outstanding WAL records,
and cause the standby to become the master?
Oh, I get your point. But yes, I expect that in case of promotion request
during a pause, the user (me too) will want to have exactly the current state,
not latest available in WALs.
Basically I'd like the promotion to make the standby replay all the WAL
even if it's requested during pause state. OTOH I understand there
are use cases where immediate promotion is useful, as you explained.
So, +1 to add something like "pg_ctl promote -m immediate".
But I'm afraid that now it's too late to add such feature into v13.
Probably it's an item for v14....
I pushed the latest version of the patch. If you have further opinion
about immediate promotion, let's keep discussing that!
Also we need to go back to the original patch posted at [1].
[1]
https://www.postgresql.org/message-id/flat/19168211580382...@myt5-b646bde4b8f3.qloud-c.yandex.net
Regards,
--
Fujii Masao
NTT DATA CORPORATION
Advanced Platform Technology Group
Research and Development Headquarters
