Re: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc. - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.
Date
Msg-id 2487ddcd737d4fc8e408e87aa9ad4365eed3bbb3.camel@j-davis.com
Whole thread
In response to CREATE SUBSCRIPTION ... SERVER vs. pg_dump, etc.  (Noah Misch <noah@leadboat.com>)
Responses Re: POC: enable logical decoding when wal_level = 'replica' without a server restart
List pgsql-hackers
On Fri, 2026-07-10 at 12:59 -0700, Noah Misch wrote:
> An Opus 4.8 review of commit 8185bb5 found two pg_dump+restore
> failure
> scenarios, visible in the attached test patch.  (The patch also tests
> a
> REASSIGN OWNED finding, for which I started a distinct thread
> postgr.es/m/flat/20260710192533.4f.noahmisch@microsoft.com).
>
> Opus also emitted the attached report about these findings and
> others.  I
> didn't examine the others closely.  Finding-19, about invalidation
> callbacks,
> stood out as perhaps most exciting if true.

Partial patch series:

 0001: Finding 10 preexisting issue: Add missing lock release for 
       DROP OWNED BY (backport to 16)
 0002: Finding 10 & 15: Improve & document DROP SERVER CASCADE
 0003: Finding 3: Reject use_scram_passthrough for
       subscription connections.

Robert, can you take a look at 0001, which fixes an issue introduced in
6566133c5f? I don't think it's major but it can retain the lock for
longer.

Regards,
    Jeff Davis



Attachment

pgsql-hackers by date:

Previous
From: "Tristan Partin"
Date:
Subject: Re: Add pg_stat_kind_info system view
Next
From: Peter Smith
Date:
Subject: Re: PSQL schema "describe" \dn is not escaping quotes