Logical Replication - When to Enable Disabled Subscription and When to Create a New One

From: Avi Weinberg <AviW(at)gilat(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Logical Replication - When to Enable Disabled Subscription and When to Create a New One
Date: 2021-12-02 10:11:24
Message-ID: DB9PR07MB718078C3864821B09A333839CB699@DB9PR07MB7180.eurprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry, my previous mail had in the title Publication instead of Subscription
Hi All,

If I find a subscription in subenabled = false state. Is it safe to run ALTER subscription and put it in ENABLE state or it is better to drop and create it from scratch?

I'm trying to figure our what can cause subscription to be in subenabled = false state. If we know all the scenarios that can cause it to be disabled maybe we can determine when to enable the subscription and when to recreate it.

Thanks!
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.

Browse pgsql-general by date

  From Date Subject
Next Message Jakub Jedelsky 2021-12-02 13:26:39 Re: case insensitive collation of Greek's sigma
Previous Message Avi Weinberg 2021-12-02 10:07:34 Logical Replication - When to Enable Disabled Publication and When to Create a New One