Re: Non-superuser subscription owners

Mark Dilger <mark.dilger@enterprisedb.com>

From: Mark Dilger <mark.dilger@enterprisedb.com>

To: PostgreSQL-development <pgsql-hackers@postgresql.org>

Cc: Andrew Dunstan <andrew@dunslane.net>

Date: 2021-11-01T22:44:32Z

Lists: pgsql-hackers

> On Nov 1, 2021, at 10:58 AM, Mark Dilger <mark.dilger@enterprisedb.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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix possible crash in tablesync worker.
- b5c517379a40 16.0 landed
Display 'password_required' option for \dRs+ command.
- 19e65dff38bd 16.0 landed
Restart the apply worker if the 'password_required' option is changed.
- c1cc4e688b60 16.0 landed
Fix possible logical replication crash.
- e7e7da2f8d57 16.0 landed
Add new predefined role pg_create_subscription.
- c3afe8cf5a1e 16.0 landed
Expand AclMode to 64 bits
- 7b378237aa80 16.0 cited
More cleanup of a2ab9c06ea.
- 96a6f11c0625 15.0 landed
Respect permissions within logical replication.
- a2ab9c06ea15 15.0 landed
Improve table locking behavior in the face of current DDL.
- 2ad36c4e44c8 9.2.0 cited