Re: Non-superuser subscription owners

Amit Kapila <amit.kapila16@gmail.com>

From: Amit Kapila <amit.kapila16@gmail.com>

To: Robert Haas <robertmhaas@gmail.com>

Cc: Jeff Davis <pgsql@j-davis.com>, Andres Freund <andres@anarazel.de>, Mark Dilger <mark.dilger@enterprisedb.com>, Andrew Dunstan <andrew@dunslane.net>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2023-04-13T02:32:07Z

Lists: pgsql-hackers

On Wed, Apr 12, 2023 at 5:50 PM Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Tue, Apr 11, 2023 at 10:56 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > Anyway, I don't think as such there is any problem
> > with restarting the worker even when the subscription owner is a
> > superuser, so adjusted the check accordingly.
>
> LGTM.
>

Thanks. I am away for a few days so can push it only next week.

-- 
With Regards,
Amit Kapila.

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