Thread

Re: Proposal: GUC to control starting/stopping logical subscription workers

SATYANARAYANA NARLAPURAM <satyanarlapuram@gmail.com> — 2025-09-09T20:16:12Z

HI Bharat,


>
> If I understand correctly, the end effect is similar to disabling all
> subscriptions. Why not just add ALTER SUBSCRIPTION ... DISABLE for all
> subscriptions in the failover work flow? Migration of logical
> replication slots docs says so -
> https://www.postgresql.org/docs/18/logical-replication-upgrade.html.
>

The scenarios I am talking in this case are no major version upgrade, but
PITR and Standby promotion cases.
Server is in read only mode (catalog cannot be updated) before promotion
and subscriptions cannot be disabled.



> --
> Bharath Rupireddy
> PostgreSQL Contributors Team
> RDS Open Source Databases
> Amazon Web Services: https://aws.amazon.com
>