| From: | Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Subject: | Re: Non-superuser subscription owners |
| Date: | 2021-11-01 22:44:32 |
| Message-ID: | 6ADE0BED-0B46-4BF0-AEDC-0D2D08648945@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Nov 1, 2021, at 10:58 AM, Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> wrote:
>
> ALTER SUBSCRIPTION..[ENABLE | DISABLE] do not synchronously start or stop subscription workers. The ALTER command updates the catalog's subenabled field, but workers only lazily respond to that. Disabling and enabling the subscription as part of the OWNER TO would not reliably accomplish anything.
Having discussed this with Andrew off-list, we've concluded that updating the documentation for logical replication to make this point more clear is probably sufficient, but I wonder if anyone thinks otherwise?
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Zhang | 2021-11-01 22:46:39 | Re: postgres_fdw: commit remote (sub)transactions in parallel during pre-commit |
| Previous Message | Mark Dilger | 2021-11-01 22:42:06 | Re: Delegating superuser tasks to new security roles (Was: Granting control of SUSET gucs to non-superusers) |