Question regarding automatically paused streaming replication

From: Ian van der Linde <ian(at)ivdl(dot)co(dot)za>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Question regarding automatically paused streaming replication
Date: 2024-06-10 11:39:18
Message-ID: JN3P275MB2050E4493B74A0B58277890CD2FA2@JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone

I run a PostgreSQL 14 environment with one primary and two standby instances with streaming replication. I recently had a case where the streaming replication on one of the standby instances paused (seemingly automatically):

2024-06-01 01:11:38.482 CEST [4575476] @ app=LOG:  recovery has paused
2024-06-01 01:11:38.482 CEST [4575477] @ app=HINT:  Execute pg_wal_replay_resume() to continue.

The log messages around this time all look normal and there were no outages. Are there any circumstances under which replication would automatically pause without outside intervention? There was no change of the primary during this time (we do not load balance queries to the standby nodes, they exist soley for HA). I manually resumed using the suggested command and it's been running fine since (and it's been running for about a year until the pause without issue the other day).

For reference, the full environment consists of the three PostgreSQL nodes, with EnterpriseDB Enterprise Failover Manager (but as far as I can tell this didn't intervene at the time either), and three PgPool nodes.

Many thanks
Ian van der Linde

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Förtsch 2024-06-10 12:06:58 Vacuum backend with backend_xmin?
Previous Message Laurenz Albe 2024-06-10 09:21:42 Re: PG16.1 security breach?