On Thu, 2026-07-23 at 03:00 +0000, Hayato Kuroda (Fujitsu) wrote: > Hi hackers, > > > My primitive idea for fix is to introduce a new TOC entry to record > > the OWNER > > command, in the pg_dump. Unlike the normal CREATE SUBSCRIPTION, > > this entry > > can be handled as RESTORE_PASS_POST_ACL. > > I'm locally working on the idea and will post tomorrow. > > So here is a patch. While coding, I found another issue that TOC > entry for > "SUBSCRIPTION TABLE" may not be skipped in case of --no- > subscriptions. > This can be an issue when: > > 1) there are tuples in pg_subscription_rel, > 2) pg_dump is done with --binary-upgrade then > 3) pg_restore is done with --no-subscription. >
Thank you! There's a related discussion here: https://www.postgresql.org/message-id/[email protected] Regards, Jeff Davis
