Dear all,
Some years ago I set up a two PostgreSQL 13 nodes cluster on Debian 11. This cluster uses the Write-Ahead Log Shipping method. I’ve just been told the second server (in standby mode) is down and refuses to start again with the following error message (roughly translated from French) :
2025-01-09 09:46:35.742 CET [3147382] FATAL: could not receive data from WAL stream: ERROR: segment requested from transaction journal, 000000010000000D000000D6, has already been removed
2025-01-09 09:46:40.745 CET [3147395] LOG: journal flow started from primary at D/D6000000 on timeline 1
2025-01-09 09:46:40.745 CET [3147395] FATAL: could not receive data from WAL stream : ERROR: segment requested from transaction journal, 000000010000000D000000D6, has already been removed
2025-01-09 09:46:45.749 CET [3147397] LOG: journal flow started from primary at D/D6000000 on timeline 1
2025-01-09 09:46:45.749 CET [3147397] FATAL: could not receive data from WAL stream : ERROR: segment requested from transaction journal, 000000010000000D000000D6, has already been removed
2025-01-09 09:46:50.753 CET [3147424] LOG: journal flow started from primary at D/D6000000 on timeline 1
2025-01-09 09:46:50.753 CET [3147424] FATAL: could not receive data from WAL stream : ERROR: segment requested from transaction journal, 000000010000000D000000D6, has already been removed
Would you have any idea how to fix this issue ?
Best regards,
Samuel
