From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | Nathan Bossart <nathandbossart(at)gmail(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PostgreSQL 16 Beta 1 release announcement draft |
Date: | 2023-05-21 16:51:05 |
Message-ID: | 2e2b33b7-38ac-bb49-8075-5c218bf34e53@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 5/19/23 10:57 AM, Nathan Bossart wrote:
> On Fri, May 19, 2023 at 12:17:50AM -0400, Jonathan S. Katz wrote:
>> PostgreSQL 16 continues to give users to the ability grant privileged access to
>> features without requiring superuser with new
>> [predefined roles](https://www.postgresql.org/docs/devel/predefined-roles.html).
>> These include `pg_maintain`, which enables execution of operations such as
>> `VACUUM`, `ANALYZE`, `REINDEX`, and others, and `pg_createsubscription`, which
>> allows users to create a logical replication subscription. Additionally,
>> starting with release, logical replication subscribers execute transactions on a
>> table as the table owner, not the superuser.
>
> [pg_use_]reserved_connections might also deserve a mention here. AFAICT
> it's the only new predefined role that isn't mentioned in the announcement.
> I'm okay with leaving it out if folks don't think it should make the cut.
I'm not sure how widely used this one would be, so I left it out.
However, open to other opinions.
Thanks,
Jonathan
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan S. Katz | 2023-05-21 17:07:38 | Re: PostgreSQL 16 Beta 1 release announcement draft |
Previous Message | Jonathan S. Katz | 2023-05-21 16:50:21 | Re: PostgreSQL 16 Beta 1 release announcement draft |