history file on replica and double switchover

Grigory Smolkin <g.smolkin@postgrespro.ru>

From: Grigory Smolkin <g.smolkin@postgrespro.ru>

To: Postgres hackers <pgsql-hackers@lists.postgresql.org>

Date: 2020-08-27T13:02:44Z

Lists: pgsql-hackers

Attachments

history_replica.patch (text/x-patch) patch
double_switchover.sh (application/x-shellscript)

Hello!

I`ve noticed, that when running switchover replica to master and back to 
replica, new history file is streamed to replica, but not archived,
which is not great, because it breaks PITR if archiving is running on 
replica. The fix looks trivial.
Bash script to reproduce the problem and patch are attached.

-- 
Grigory Smolkin
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Commits

Archive timeline history files in standby if archive_mode is set to "always".
- 40a8fb1e0f41 9.5.24 landed
- 7be02a3bf03a 9.6.20 landed
- 33441753820b 10.15 landed
- 462ff7966997 11.10 landed
- 4d342b9d4153 12.5 landed
- 059caf36c307 13.1 landed
- fd26f7823183 14.0 landed