0001-Fix-pg_upgrade-to-detect-invalid-logical-replication.patch
application/octet-stream
Filename: 0001-Fix-pg_upgrade-to-detect-invalid-logical-replication.patch
Type: application/octet-stream
Part: 0
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch 0001
Subject: Fix pg_upgrade to detect invalid logical replication slots on PG19
| File | + | − |
|---|---|---|
| src/bin/pg_upgrade/info.c | 2 | 1 |
From 6a80958204364c94b511e7728f83281013cdbf06 Mon Sep 17 00:00:00 2001 From: Lakshmi N <lakshmin.jhs@gmail.com> Date: Mon, 20 Apr 2026 01:47:50 -0700 Subject: [PATCH] Fix pg_upgrade to detect invalid logical replication slots on PG19 --- src/bin/pg_upgrade/info.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/bin/pg_upgrade/info.c b/src/bin/pg_upgrade/info.c index 8c5679b8097..37fff93892f 100644 --- a/src/bin/pg_upgrade/info.c +++ b/src/bin/pg_upgrade/info.c @@ -743,7 +743,8 @@ get_old_cluster_logical_slot_infos_query(ClusterInfo *cluster) " confirmed_flush_lsn > last_pending_wal " "END as caught_up, " "invalidation_reason IS NOT NULL as invalid " - "FROM pg_catalog.pg_replication_slots, check_caught_up " + "FROM pg_catalog.pg_replication_slots " + "LEFT JOIN check_caught_up ON true " "WHERE slot_type = 'logical' AND " "database = current_database() AND " "temporary IS FALSE "; -- 2.43.0