Logical Replication - When to Enable Disabled Subscription and When to Create a New One - Mailing list pgsql-general

From Avi Weinberg
Subject Logical Replication - When to Enable Disabled Subscription and When to Create a New One
Date
Msg-id DB9PR07MB718078C3864821B09A333839CB699@DB9PR07MB7180.eurprd07.prod.outlook.com
Whole thread Raw
List 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.

pgsql-general by date:

Previous
From: Avi Weinberg
Date:
Subject: Logical Replication - When to Enable Disabled Publication and When to Create a New One
Next
From: Jakub Jedelsky
Date:
Subject: Re: case insensitive collation of Greek's sigma