pgsql: Fix issue with WAL archiving in standby. - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: Fix issue with WAL archiving in standby.
Date
Msg-id E1mOLXz-0000v9-CS@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix issue with WAL archiving in standby.

Previously, walreceiver always closed the currently-opened WAL segment
and created its archive notification file, after it finished writing
the current segment up and received any WAL data that should be
written into the next segment. If walreceiver exited just before
any WAL data in the next segment arrived at standby, it did not
create the archive notification file of the current segment
even though that's known completed. This behavior could cause
WAL archiving of the segment to be delayed until subsequent
restartpoints or checkpoints created its notification file.

To fix the issue, this commit changes walreceiver so that it creates
an archive notification file of a current WAL segment immediately
if that's known completed before receiving next WAL data.

Back-patch to all supported branches.

Reported-by: Kyotaro Horiguchi
Author: Fujii Masao
Reviewed-by: Kyotaro Horiguchi
Discussion: https://postgr.es/m/20200630.165503.1465894182551545886.horikyota.ntt@gmail.com

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b5ec22bf5e8f19964f7c7d7ef357ff947a38c7fc

Modified Files
--------------
src/backend/replication/walreceiver.c | 99 ++++++++++++++++++++++-------------
1 file changed, 62 insertions(+), 37 deletions(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Fix issue with WAL archiving in standby.
Next
From: Fujii Masao
Date:
Subject: pgsql: Fix issue with WAL archiving in standby.