From: Ian van der Linde <ian@ivdl.co.za>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Question regarding automatically paused streaming replication
Thread-Topic: Question regarding automatically paused streaming replication
Thread-Index: AQHat9jy9IGs2BQLIky9QiJjpgKyQQ==
Date: Mon, 10 Jun 2024 11:39:18 +0000
Message-ID:
 <JN3P275MB2050E4493B74A0B58277890CD2FA2@JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM>
Accept-Language: en-GB, en-US
Content-Language: en-GB
msip_labels:
authentication-results: dkim=none (message not signed)
 header.d=none;dmarc=none action=none header.from=ivdl.co.za;
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: JN3P275MB2050:EE_|CP7P275MB2368:EE_
x-ms-office365-filtering-correlation-id: d46357ea-a2b7-4fbd-0c95-08dc8941f6ce
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;ARA:13230031|1800799015|376005|366007|38070700009;
x-microsoft-antispam-message-info:
 =?iso-8859-1?Q?lbqI/wEZhLRyvI/PhE4YvDoLj7XMj01J9sUPBRI4JnCtFkk8aRVKh439GJ?=
 =?iso-8859-1?Q?jmYXLvD6+nQz1LsCPLOmrsBMVefbWw+wjcr3e+yLdKR9IwQPhQFOchr2lc?=
 =?iso-8859-1?Q?XznYQS+PHcCkJDTM2hOPUH4JcMNS/tsr4+yMBH8wU4lBHdL1jv89IXSeya?=
 =?iso-8859-1?Q?EeKBaiyZjgqYiLUbF5SoRJOGlzwP0JnctrXqIobT+QY+qz+AoaXZ26YCdq?=
 =?iso-8859-1?Q?GYpLJEj/d1jY5/I5ioH9h8j7MwODsZc2MsRHQEjgLqw2c5zr7mC2YeVsCa?=
 =?iso-8859-1?Q?lwyFJxkYZsJVuVGqJd7eHtyfACHfpp37RW2B0+/A6iZl6lVrXzqgrzRqaL?=
 =?iso-8859-1?Q?7uuPRX1WLwYulMXZtjL4uWzWgpZWz7Blt5N9rLRu4e+WffODwTlFQqjc7m?=
 =?iso-8859-1?Q?XXNk72YToIk6NYnpvdqGbuMLiXpIDhCE8GgOrfVhTWlJuEAyf+HpGDYi1P?=
 =?iso-8859-1?Q?UzgpRml1hczky21+haMpaisqOq4UOS7FBhY3HN0wrMYl338o+RCf//pAAr?=
 =?iso-8859-1?Q?DLEYMyNzTT6GfbMK0nNRo1WYSnvUO417uoycLDwKuAk3xt+kzRypoBgQ3R?=
 =?iso-8859-1?Q?eDPldTiWIgSatJTuGg+gfuEBxSJu7sRZCgSEmXq1OesUKFW+5nayb1d0pf?=
 =?iso-8859-1?Q?LfBQKjgAoTKmypL8utGyboU/uDul+YIcrdz/zf5KPIXUYuvFkLb4DzLhwg?=
 =?iso-8859-1?Q?tgJzxaGiIh9y4ltreB24QQ9Enooq6ft6hjs7u/TCRnDM5dMATEHhED0HNc?=
 =?iso-8859-1?Q?FBjwsbAqXTVwosCAZ0aIDMqFyE/OyDukX2ziUUjJ8FcoQ9X8q3eYGWAtrJ?=
 =?iso-8859-1?Q?O+zcFr2cjOYAYoLj3SPx1LOFXiDPc7NwG1JhlXNC47t85sj1/D8GjZyo+n?=
 =?iso-8859-1?Q?TNJYgeKuZXB1SeiSCtOGredmP9dqhYsVliVTo0ZV2G+GOdLREILaa7qYjJ?=
 =?iso-8859-1?Q?x7mEdDP4oE2WRi3u2OVKVjP8MLYiwOyliPcR6tTH/nLw4IjvH+iH/1l249?=
 =?iso-8859-1?Q?DxdKmiAnX+RsTp0zlhTcs3JlM3plSkknErRK0BzY7mT24/Ivwd3HVIqIBu?=
 =?iso-8859-1?Q?R3AVAXpXx8E+jUwGNPj939hMThaiqJpcKZzg57TNme2A3dJsUDa7Ipjd7e?=
 =?iso-8859-1?Q?qp3an6IyfzjK8we0MjQp/r+fFDn8lwgAHgOwJKUpN2M00Fc/S4qvkNAvSQ?=
 =?iso-8859-1?Q?s4itRoKha6q3N/xj25KkQFCMP8B2hT+sp5orsLtoO3P+NTk/1wy2bxE2F4?=
 =?iso-8859-1?Q?3iqwppvxBrkddftlbV9W5+gQ62WyrOvccRZqQSGL0wqHtt/28stfyYFSRo?=
 =?iso-8859-1?Q?Wl7JiGWboaxiUvNWj3kD0UFNfYN5Zx+Xxt9LRmoBCzbpVuL+9vrI6zblAb?=
 =?iso-8859-1?Q?j2ojWg1KRSNZUm79Hi7iwJYY/sOZ6zv8YGTUVfA/msmoXkmAqtJkY=3D?=
x-forefront-antispam-report:
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM;PTR:;CAT:NONE;SFS:(13230031)(1800799015)(376005)(366007)(38070700009);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0:
 =?iso-8859-1?Q?F03UJr+BHjejGd6RgwNFc/tYTvP9i2EmlccVxClSJiZqhMd+H7mGKZ4yD/?=
 =?iso-8859-1?Q?jqdSrOAkrml+Ys+mPWdrmhR+4k7qWGbiPxPB9cQJLChzPpxz68v0IxwCn0?=
 =?iso-8859-1?Q?b19Rky4Aur5Q/gzpDQv4CFFA7U599dUm5TW7iaOEttrReelWgMeFHB7psd?=
 =?iso-8859-1?Q?zOW7eVTqXT5ZyKN0YWtyy64WdSuWGLtYKkdoRLiMONZeIl6FWBPMg3Jr5n?=
 =?iso-8859-1?Q?zQzU9z8oMYdzleadCp+1HUJHLLyn2JTjNRJWCnagIUlENIFKcUkEHdbugH?=
 =?iso-8859-1?Q?lS4yRzP9EiLDMviPttBeCyNJAypRharuRJUYnlxjnz89TgVzdJ9zcpz/LO?=
 =?iso-8859-1?Q?1sW3bxw/kT/8Wr2pDEdhfsO/1/a7L6FT0tkQjlEHkCB2M+2ZAr6TYRlQNW?=
 =?iso-8859-1?Q?AANLDBZBpo/JBu7tJSSd+z/DJCJOySTZpm0/P810OjeQe9gfXy8yVbZWCM?=
 =?iso-8859-1?Q?blPKEp/qTcb504/ZvbcQCyN1IdAz0c1KUZqFRaPJak1N9Y2srAHM1MydB9?=
 =?iso-8859-1?Q?yy64OoWzRqepCH1+aGXNGffZTP8EK2PKyUUSiF+2GvlGT+rsGe7fLpVP9M?=
 =?iso-8859-1?Q?kd1unxCq3kxMX+UEkWrh9qjLbRALYRsIC21u3YgMUI6VYeIUo0QjL81xpT?=
 =?iso-8859-1?Q?IsuLXVbVywzW5TZzqPBy2QtgYpU/igCKJOUtwZP/Npcj8O2N/Po1c7aqig?=
 =?iso-8859-1?Q?332QJRMSeBWEqSwFE6AIinxhrAtdJtU9iirrCxyohw8f6ASml6jY/ZW3B4?=
 =?iso-8859-1?Q?WkSLjx16+ot1QdxqRN/5UgLqvfDsz7CttoX3oYJq0W10v0DDFvRfHwT1B/?=
 =?iso-8859-1?Q?VA4FcN9e+Eg5+BRrH4NhOq5oohtYRwVJ345H4jYqsmFOY1X6tKe9n6cxS5?=
 =?iso-8859-1?Q?ivWU5oO5pPZ/h6ON1pvo1+eKaMEz8kziDYOyiTMfIOi3VtYGub2119T5v5?=
 =?iso-8859-1?Q?1Wz0ZAUSTMQV/kDHUtlCaSniCnQ/OuL4B0NZb41b4pBgwQUCBq5w+kD5vh?=
 =?iso-8859-1?Q?RI+gnkKYkeWUxrLj38NSmNvLxIfU0DOdGXoIGl7elw30o3fmKqKFH1VKCC?=
 =?iso-8859-1?Q?s7cegbnvWUTuazGnC+ZwTyCrOzya3u/jj5W0smUOj5Es5okxHFUKcu/Oeh?=
 =?iso-8859-1?Q?0AuLXYBDAlkytetgjjkedDu7Z7NavfVwOHeZ7ogLbMmP8rIM6YAocy7hYY?=
 =?iso-8859-1?Q?Kv6GYYCJ5Jw6gJCIU3vwxeq/CHGx14fLHrrjLSx2XSAqw9DMUCT43/x747?=
 =?iso-8859-1?Q?uSdN8ucz59OsMSY336gLqXJz1oHIvHJkqZR1mX/bSKRsp0lAJUpH3pMXFS?=
 =?iso-8859-1?Q?982pYLq2JhnaGW80dIRS2znmHTpUMA24xc1vLfCQWMaFo/I0lYGHLOZc8D?=
 =?iso-8859-1?Q?1wH1N7I9bkl2dhOzupPDIgUvlGWbi7A4SUeVPo00K+HHByTckCVkX8O5ZB?=
 =?iso-8859-1?Q?LeQl/+k90eJHS6drmL5LaNF6bloAJn/Y5VJBufh/yXYIzjLvvoHyaxKD6G?=
 =?iso-8859-1?Q?+I6EBBD8f0+pTI0uft8W/xrQ0F/k5vpSmUofobaXTENALjO/UVNc2mr8bk?=
 =?iso-8859-1?Q?n0UmXhVjEqmY/xG6r0tCbFJqotc0SuqorKDVvvMILuVA19IWIDv+hUcL6p?=
 =?iso-8859-1?Q?muf6dSwa1GG60=3D?=
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: ivdl.co.za
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: d46357ea-a2b7-4fbd-0c95-08dc8941f6ce
X-MS-Exchange-CrossTenant-originalarrivaltime: 10 Jun 2024 11:39:18.5736
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: cb391425-a5a8-4091-b0a6-dbbca768783f
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: X++vMrsrk4ILYxHCl3UadbcHE+cexlqjdHIh/goHudzppXJRhSBeqvOX06mUDfJ8
X-MS-Exchange-Transport-CrossTenantHeadersStamped: CP7P275MB2368
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/JN3P275MB2050E4493B74A0B58277890CD2FA2%40JN3P275MB2050.ZAFP275.PROD.OUTLOOK.COM>
Precedence: bulk

Hi everyone=0A=
=0A=
I run a PostgreSQL 14 environment with one primary and two standby instance=
s with streaming replication. I recently had a case where the streaming rep=
lication on one of the standby instances paused (seemingly automatically):=
=0A=
=0A=
2024-06-01 01:11:38.482 CEST [4575476] @ app=3DLOG: =A0recovery has paused=
=0A=
2024-06-01 01:11:38.482 CEST [4575477] @ app=3DHINT: =A0Execute pg_wal_repl=
ay_resume() to continue.=0A=
=0A=
The log messages around this time all look normal and there were no outages=
. Are there any circumstances under which replication would automatically p=
ause without outside intervention? There was no change of the primary durin=
g this time (we do not load balance queries to the standby nodes, they exis=
t soley for HA). I manually resumed using the suggested command and it's be=
en running fine since (and it's been running for about a year until the pau=
se without issue the other day). =0A=
=0A=
For reference, the full environment consists of the three PostgreSQL nodes,=
 with EnterpriseDB Enterprise Failover Manager (but as far as I can tell th=
is didn't intervene at the time either), and three PgPool nodes. =0A=
=0A=
Many thanks=0A=
Ian van der Linde=