On Fri, May 19, 2023 at 12:17:50AM -0400, Jonathan S. Katz wrote: > Attached is a draft of the release announcement for PostgreSQL 16 Beta 1. > The goal of this announcement is to get people excited about testing the > beta and highlight many of the new features.
Thanks! > 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. -- Nathan Bossart Amazon Web Services: https://aws.amazon.com
