From 3554a40b0542d6b01a2a92dc78323880ac5aba3c Mon Sep 17 00:00:00 2001 From: Palle Girgensohn Date: Thu, 10 Aug 2023 15:55:07 +0200 Subject: 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/ --- databases/postgresql15-server/Makefile | 2 +- databases/postgresql15-server/distinfo | 6 +++--- .../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 ----------- 3 files changed, 4 insertions(+), 15 deletions(-) (limited to 'databases/postgresql15-server') diff --git a/databases/postgresql15-server/Makefile b/databases/postgresql15-server/Makefile index 6dd6bcc49cb0..923aab8c9a02 100644 --- a/databases/postgresql15-server/Makefile +++ b/databases/postgresql15-server/Makefile @@ -1,4 +1,4 @@ -DISTVERSION?= 15.3 +DISTVERSION?= 15.4 # PORTREVISION must be ?= otherwise, all slave ports get this PORTREVISION and # not their own. Probably best to keep it at ?=0 when reset here too. PORTREVISION?= 0 diff --git a/databases/postgresql15-server/distinfo b/databases/postgresql15-server/distinfo index 96b03c9c614f..ba300024aefc 100644 --- a/databases/postgresql15-server/distinfo +++ b/databases/postgresql15-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1683631078 -SHA256 (postgresql/postgresql-15.3.tar.bz2) = ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932 -SIZE (postgresql/postgresql-15.3.tar.bz2) = 22819107 +TIMESTAMP = 1691487716 +SHA256 (postgresql/postgresql-15.4.tar.bz2) = baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9 +SIZE (postgresql/postgresql-15.4.tar.bz2) = 22850355 diff --git a/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample index a82826b3b5f1..9469421174a0 100644 --- a/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample +++ b/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample @@ -8,14 +8,3 @@ #log_destination = 'stderr' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog -@@ -464,7 +465,9 @@ - - #cluster_name = '' # added to process titles if nonempty - # (change requires restart) --#update_process_title = on -+ -+# On FreeBSD, this is a performance hog, so keep it off if you need speed -+update_process_title = off - - - #------------------------------------------------------------------------------ -- cgit v1.2.3