RE: pg_upgrade and logical replication

Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com>

From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>

To: 'Julien Rouhaud' <rjuju123@gmail.com>

Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Amit Kapila <amit.kapila16@gmail.com>

Date: 2023-04-06T04:49:59Z

Lists: pgsql-hackers

Dear Julien,

> I'm attaching a v3 to fix a recent conflict with pg_dump due to a563c24c9574b7
> (Allow pg_dump to include/exclude child tables automatically).

Thank you for making the patch.
FYI - it could not be applied due to recent commits. SUBOPT_* and attributes
in SubscriptionInfo was added these days.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED

Commits

pg_upgrade: Retrieve subscription count more efficiently.
- 73de50e13e39 17.0 landed
- 364509a2e7f9 18.0 landed
Fix random failure in 004_subscription.
- 677a45c4ae16 17.0 landed
Fix 004_subscription.pl to allow its usage in --link mode.
- f17529b71097 17.0 landed
Allow upgrades to preserve the full subscription's state.
- 9a17be1e244a 17.0 landed
Prevent startup of logical replication launcher during pg_upgrade
- 7021d3b17664 17.0 landed