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.
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 |