Question regarding automatically paused streaming replication
От | Ian van der Linde |
---|---|
Тема | Question regarding automatically paused streaming replication |
Дата | |
Msg-id | JN3P275MB2050E4493B74A0B58277890CD2FA2@JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM обсуждение исходный текст |
Список | pgsql-general |
Hi everyone I run a PostgreSQL 14 environment with one primary and two standby instances with streaming replication. I recently had acase 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 replicationwould automatically pause without outside intervention? There was no change of the primary during this time (wedo not load balance queries to the standby nodes, they exist soley for HA). I manually resumed using the suggested commandand 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
В списке pgsql-general по дате отправления: