.A new module stream: `postgresql:15` RHEL 9.2 introduces `PostgreSQL 15` as the `postgresql:15` module stream. `PostgreSQL 15` provides a number of new features and enhancements over version 13. Notable changes include: * You can now access `PostgreSQL` JSON data by using subscripts. Example query: + ---- SELECT ('{ "postgres": { "release": 15 }}'::jsonb)['postgres']['release']; ---- * `PostgreSQL` now supports multirange data types and extends the `range_agg` function to aggregate multirange data types. * `PostgreSQL` improves monitoring and observability: ** You can now track progress of the `COPY` commands and Write-ahead-log (WAL) activity. ** `PostgreSQL` now provides statistics on replication slots. ** By enabling the `compute_query_id` parameter, you can now uniquely track a query through several `PostgreSQL` features, including `pg_stat_activity` or `EXPLAIN VERBOSE`. * `PostgreSQL` improves support for query parallelism by the following: ** Improved performance of parallel sequential scans. ** The ability of SQL Procedural Language (`PL/pgSQL`) to execute parallel queries when using the `RETURN QUERY` command. ** Enabled parallelism in the `REFRESH MATERIALIZED VIEW` command. * `PostgreSQL` now includes the SQL standard `MERGE` command. You can use `MERGE` to write conditional SQL statements that can include the `INSERT`, `UPDATE`, and `DELETE` actions in a single statement. * `PostgreSQL` provides the following new functions for using regular expressions to inspect strings: `regexp_count()`, `regexp_instr()`, `regexp_like()`, and `regexp_substr()`. * `PostgreSQL` adds the `security_invoker` parameter, which you can use to query data with the permissions of the view caller, not the view creator. This helps you ensure that view callers have the correct permissions for working with the underlying data. * `PostgreSQL` improves performance, namely in its archiving and backup facilities. * `PostgreSQL` adds support for the `LZ4` and `Zstandard` (`zstd`) lossless compression algorithms. * `PostgreSQL` improves its in-memory and on-disk sorting algorithms. * The updated `postgresql.service` systemd unit file now ensures that the `postgresql` service is started after the network is up. The following changes are backwards incompatible: * The default permissions of the public schema have been modified. Newly created users need to grant permission explicitly by using the `GRANT ALL ON SCHEMA public TO myuser;` command. For example: + ---- postgres=# CREATE USER mydbuser; postgres=# GRANT ALL ON SCHEMA public TO mydbuser; postgres=# \c postgres mydbuser postgres=$ CREATE TABLE mytable (id int); ---- * The `libpq` `PQsendQuery()` function is no longer supported in pipeline mode. Modify affected applications to use the `PQsendQueryParams()` function instead. See also https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#using-postgresql_configuring-and-using-database-servers[Using PostgreSQL]. To install the `postgresql:15` stream, use: [literal] ---- # dnf module install postgresql:15 ---- If you want to upgrade from an earlier `postgresql` stream within RHEL 9, migrate your `PostgreSQL` data as described in https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#migrating-to-a-rhel-9-version-of-postgresql_using-postgresql[Migrating to a RHEL 9 version of PostgreSQL]. For information about the length of support for the `postgresql` module streams, see the link:https://access.redhat.com/support/policy/updates/rhel-app-streams-life-cycle[Red Hat Enterprise Linux Application Streams Life Cycle].