From d97f1b4db2d9a09358d7e18e6e03db38ecebed93 Mon Sep 17 00:00:00 2001 From: "Jonathan S. Katz" Date: Sun, 21 May 2023 13:04:57 -0400 Subject: [PATCH] Added feedback to the PostgreSQL 16 Beta 1 release announcement MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Reviewed-by: Erik Rijkers Reviewed-by: Nathan Bossart Reviewed-by: Michael Alan Brewer Reviewed-by: Justin Clift Reviewed-by: Cédric Villemain --- releases/16/16beta1.md | 32 +++++++++++++++++--------------- 1 file changed, 17 insertions(+), 15 deletions(-) diff --git a/releases/16/16beta1.md b/releases/16/16beta1.md index 304cc2e..9e7f279 100644 --- a/releases/16/16beta1.md +++ b/releases/16/16beta1.md @@ -32,7 +32,7 @@ Logical replication lets PostgreSQL users stream data in real-time to other PostgreSQL or other external systems that implement the logical protocol. Until PostgreSQL 16, users could only create logical replication publishers on primary instances. PostgreSQL 16 adds the ability to perform logical decoding on a -standby instance, given users more options to distribute their workload, for +standby instance, giving users more options to distribute their workload, for example, use a standby that's less busy than a primary to logically replicate changes. @@ -61,7 +61,7 @@ to libpq, the client library for PostgreSQL. ### Developer Experience -PostgreSQL 16 continues to to implement the [SQL/JSON](https://www.postgresql.org/docs/devel/functions-json.html) +PostgreSQL 16 continues to implement the [SQL/JSON](https://www.postgresql.org/docs/devel/functions-json.html) standard for manipulating [JSON](https://www.postgresql.org/docs/devel/datatype-json.html) data, including support for SQL/JSON constructors (e.g. `JSON_ARRAY()`, `JSON_ARRAYAGG()` et al), and identity functions (`IS JSON`). This release also @@ -78,14 +78,14 @@ command to substitute the variables. ### Security features -PostgreSQL 16 continues to give users to the ability grant privileged access to +PostgreSQL 16 continues to give users the ability to 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 +`VACUUM`, `ANALYZE`, `REINDEX`, and others, and `pg_create_subscription`, 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. +starting with this release, logical replication subscribers execute transactions +on a table as the table owner, not the superuser. PostgreSQL 16 now lets you use regular expressions in the [`pg_hba.conf`](https://www.postgresql.org/docs/devel/auth-pg-hba-conf.html) and [`pg_ident.conf`](https://www.postgresql.org/docs/devel/auth-username-maps.html) @@ -97,12 +97,12 @@ a session. PostgreSQL 16 also adds support for Kerberos credential delegation, which allows extensions such as `postgres_fdw` and `dblink` to use the authenticated -credentials to connected to other services. This release also adds several new +credentials to connect to other services. This release also adds several new security-oriented connection parameters for clients. This includes [`require_auth`](https://www.postgresql.org/docs/devel/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH), where a client can specify which authentication methods it is willing to accept -from the server. You can now also set `sslrootcert` to `system` to specify that -PostgreSQL can use the trusted certificate authority (CA) store for that -operating system. +from the server. You can now set `sslrootcert` to `system` to instrcut +PostgreSQL to use the trusted certificate authority (CA) store provided by the +client's operating system. ### Operations @@ -125,17 +125,19 @@ support for both `lz4` and `zstd` compression. ### Other Notable Changes -For Windows installations, PostgreSQL 16 now supports a minimum version of -Windows 10. Additionally, PostgreSQL 16 removes the `promote_trigger_file` -option to enable the promotion of a standby. Users should use the -`pg_ctl promote` command or `pg_promote()` function to promote a standby. +PostgreSQL 16 removes the `promote_trigger_file` option to enable the promotion +of a standby. Users should use the `pg_ctl promote` command or `pg_promote()` +function to promote a standby. PostgreSQL 16 introduced the Meson build system, which will ultimately replace Autoconf. This release also adds foundational support for developmental features -that will be improved upon in future releases, including a developer flag to +that will be improved upon in future releases. This includes a developer flag to enable DirectIO and the ability to use logical replication to bidirectionally replicate between two tables when `origin=none` is specified in the subscriber. +For Windows installations, PostgreSQL 16 now supports a minimum version of +Windows 10. + Additional Features ------------------- -- 2.39.5