HomeFreeBSD

databases/postgresql??-*: Update to latest versions.

Description

databases/postgresql??-*: Update to latest versions.

PostgreSQL 15.4, 14.9, 13.12, 12.16, 11.21, and PostgreSQL 16 Beta 3
Released.

The PostgreSQL Global Development Group has released an update to all
supported versions of PostgreSQL, including 15.4, 14.9, 13.12, 12.16,
and 11.21, as well as the third beta release of PostgreSQL 16. This
release fixes two security vulnerabilities and over 40 bugs reported
over the last several months.

If you use BRIN indexes to look up NULL values, you will need to reindex
them after upgrading to this release. On PostgreSQL 12 and above, you
can use REINDEX CONCURRENTLY to avoid blocking writes to the affected
index and table, for example:

REINDEX INDEX CONCURRENTLY your_index_name;

Also, remove the patch for postgresql.conf.sample suggesting to turn off
update_process_title [1], since it is no longer a problem.

Release notes: https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/

[1]: https://commitfest.postgresql.org/19/1715/

(cherry picked from commit 3554a40b0542d6b01a2a92dc78323880ac5aba3c)

Details

Provenance
girgenAuthored on Aug 10 2023, 1:55 PM
Parents
R11:0d91f23298b5: databases/postgresql16-*: update to 16.beta2
Branches
Unknown
Tags
Unknown