pgsql: Archive timeline history files in standby if archive_mode is set - Mailing list pgsql-committers

From Fujii Masao
Subject pgsql: Archive timeline history files in standby if archive_mode is set
Date
Msg-id E1kNA2a-0001Gu-Ng@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Archive timeline history files in standby if archive_mode is set to "always".

Previously the standby server didn't archive timeline history files
streamed from the primary even when archive_mode is set to "always",
while it archives the streamed WAL files. This could cause the PITR to
fail because there was no required timeline history file in the archive.
The cause of this issue was that walreceiver didn't mark those files as
ready for archiving.

This commit makes walreceiver mark those streamed timeline history
files as ready for archiving if archive_mode=always. Then the archiver
process archives the marked timeline history files.

Back-patch to all supported versions.

Reported-by: Grigory Smolkin
Author: Grigory Smolkin, Fujii Masao
Reviewed-by: David Zhang, Anastasia Lubennikova
Discussion: https://postgr.es/m/54b059d4-2b48-13a4-6f43-95a087c92367@postgrespro.ru

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/4d342b9d41533df94b1b637d814333a716ec1050

Modified Files
--------------
doc/src/sgml/high-availability.sgml   | 3 ++-
src/backend/replication/walreceiver.c | 9 +++++++++
2 files changed, 11 insertions(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Fujii Masao
Date:
Subject: pgsql: Archive timeline history files in standby if archive_mode is set
Next
From: Fujii Masao
Date:
Subject: pgsql: Archive timeline history files in standby if archive_mode is set