2nd PostgreSQL server in WAL shipping cluster fails to start

From: Samuel VISCAPI <samuel(dot)viscapi(at)xelians(dot)fr>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: 2nd PostgreSQL server in WAL shipping cluster fails to start
Date: 2025-01-09 10:08:24
Message-ID: MR2P264MB0147200E004CB5C9FC761ACCFE132@MR2P264MB0147.FRAP264.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2025-01-09 11:11:19 Re: 2nd PostgreSQL server in WAL shipping cluster fails to start
Previous Message Teja Jakkidi 2025-01-09 06:19:53 Re: Credcheck max_auth_failure