git: 3554a40b0542 - main - databases/postgresql??-*: Update to latest versions.
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
Date: Thu, 10 Aug 2023 14:13:28 UTC
The branch main has been updated by girgen:
URL: https://cgit.FreeBSD.org/ports/commit/?id=3554a40b0542d6b01a2a92dc78323880ac5aba3c
commit 3554a40b0542d6b01a2a92dc78323880ac5aba3c
Author: Palle Girgensohn <girgen@FreeBSD.org>
AuthorDate: 2023-08-10 13:55:07 +0000
Commit: Palle Girgensohn <girgen@FreeBSD.org>
CommitDate: 2023-08-10 14:13:24 +0000
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/postgresql11-server/Makefile | 2 +-
databases/postgresql11-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
databases/postgresql12-server/Makefile | 2 +-
databases/postgresql12-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
databases/postgresql13-server/Makefile | 2 +-
databases/postgresql13-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
databases/postgresql14-server/Makefile | 2 +-
databases/postgresql14-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
databases/postgresql15-server/Makefile | 2 +-
databases/postgresql15-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
databases/postgresql16-server/Makefile | 2 +-
databases/postgresql16-server/distinfo | 6 +++---
.../files/patch-src_backend_utils_misc_postgresql.conf.sample | 11 -----------
18 files changed, 24 insertions(+), 90 deletions(-)
diff --git a/databases/postgresql11-server/Makefile b/databases/postgresql11-server/Makefile
index 58c612dc589e..32158b898ac3 100644
--- a/databases/postgresql11-server/Makefile
+++ b/databases/postgresql11-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?= 11.20
+DISTVERSION?= 11.21
# 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/postgresql11-server/distinfo b/databases/postgresql11-server/distinfo
index cfa9c2b2178c..6a45ebd2846c 100644
--- a/databases/postgresql11-server/distinfo
+++ b/databases/postgresql11-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1683631074
-SHA256 (postgresql/postgresql-11.20.tar.bz2) = 3d7c8882f64a7e98534a044257dfee7abad77a5b7da12508d85d722b98b5acce
-SIZE (postgresql/postgresql-11.20.tar.bz2) = 20456483
+TIMESTAMP = 1691487688
+SHA256 (postgresql/postgresql-11.21.tar.bz2) = 07b0837471d5dd77b25166b34718f3ba10816b6ad61e691e6fc547cf3fcff850
+SIZE (postgresql/postgresql-11.21.tar.bz2) = 20467892
diff --git a/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
index a82826b3b5f1..9469421174a0 100644
--- a/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ b/databases/postgresql11-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
-
-
- #------------------------------------------------------------------------------
diff --git a/databases/postgresql12-server/Makefile b/databases/postgresql12-server/Makefile
index 9cb76e880f73..3d297bbc819d 100644
--- a/databases/postgresql12-server/Makefile
+++ b/databases/postgresql12-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?= 12.15
+DISTVERSION?= 12.16
# 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/postgresql12-server/distinfo b/databases/postgresql12-server/distinfo
index 9b52869a1c86..5d927a821ba8 100644
--- a/databases/postgresql12-server/distinfo
+++ b/databases/postgresql12-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1683631075
-SHA256 (postgresql/postgresql-12.15.tar.bz2) = bb5206e2864c1c4579938b96ea6096d155f22abf2d2cc2aa57571e3c4cb12b36
-SIZE (postgresql/postgresql-12.15.tar.bz2) = 21127306
+TIMESTAMP = 1691487695
+SHA256 (postgresql/postgresql-12.16.tar.bz2) = c5f1fff7a0f93e1ec3746417b0594290ece617b4995ed95b8d527af0ba0e38f3
+SIZE (postgresql/postgresql-12.16.tar.bz2) = 21140532
diff --git a/databases/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
index a82826b3b5f1..9469421174a0 100644
--- a/databases/postgresql12-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ b/databases/postgresql12-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
-
-
- #------------------------------------------------------------------------------
diff --git a/databases/postgresql13-server/Makefile b/databases/postgresql13-server/Makefile
index e23f70b4a118..7e7077c5454b 100644
--- a/databases/postgresql13-server/Makefile
+++ b/databases/postgresql13-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?= 13.11
+DISTVERSION?= 13.12
# 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/postgresql13-server/distinfo b/databases/postgresql13-server/distinfo
index d62375c0a985..6891e3a57315 100644
--- a/databases/postgresql13-server/distinfo
+++ b/databases/postgresql13-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1683631076
-SHA256 (postgresql/postgresql-13.11.tar.bz2) = 4992ff647203566b670d4e54dc5317499a26856c93576d0ea951bdf6bee50bfb
-SIZE (postgresql/postgresql-13.11.tar.bz2) = 21519655
+TIMESTAMP = 1691487702
+SHA256 (postgresql/postgresql-13.12.tar.bz2) = 0da1edcee3514b7bc7ba6dbaf0c00499e8ac1590668e8789c50253a6249f218b
+SIZE (postgresql/postgresql-13.12.tar.bz2) = 21542293
diff --git a/databases/postgresql13-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql13-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
index a82826b3b5f1..9469421174a0 100644
--- a/databases/postgresql13-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ b/databases/postgresql13-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
-
-
- #------------------------------------------------------------------------------
diff --git a/databases/postgresql14-server/Makefile b/databases/postgresql14-server/Makefile
index 32e9c386dbd5..1391498a64f5 100644
--- a/databases/postgresql14-server/Makefile
+++ b/databases/postgresql14-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?= 14.8
+DISTVERSION?= 14.9
# 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/postgresql14-server/distinfo b/databases/postgresql14-server/distinfo
index adf611d66417..5bf844b979ae 100644
--- a/databases/postgresql14-server/distinfo
+++ b/databases/postgresql14-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1683631077
-SHA256 (postgresql/postgresql-14.8.tar.bz2) = 39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
-SIZE (postgresql/postgresql-14.8.tar.bz2) = 22204905
+TIMESTAMP = 1691487709
+SHA256 (postgresql/postgresql-14.9.tar.bz2) = b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
+SIZE (postgresql/postgresql-14.9.tar.bz2) = 22207374
diff --git a/databases/postgresql14-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql14-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
index a82826b3b5f1..9469421174a0 100644
--- a/databases/postgresql14-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ b/databases/postgresql14-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
-
-
- #------------------------------------------------------------------------------
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
-
-
- #------------------------------------------------------------------------------
diff --git a/databases/postgresql16-server/Makefile b/databases/postgresql16-server/Makefile
index 3636ac7a04e8..3123cd927e9a 100644
--- a/databases/postgresql16-server/Makefile
+++ b/databases/postgresql16-server/Makefile
@@ -1,5 +1,5 @@
PORTNAME?= postgresql
-DISTVERSION?= 16beta2
+DISTVERSION?= 16beta3
# 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/postgresql16-server/distinfo b/databases/postgresql16-server/distinfo
index c5ee696409b9..78a17c56409c 100644
--- a/databases/postgresql16-server/distinfo
+++ b/databases/postgresql16-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1688468148
-SHA256 (postgresql/postgresql-16beta2.tar.bz2) = ba653197465180c93775b4949a89dc6fbfebae2a44587ae7168fdfd24f519b50
-SIZE (postgresql/postgresql-16beta2.tar.bz2) = 24300580
+TIMESTAMP = 1691487723
+SHA256 (postgresql/postgresql-16beta3.tar.bz2) = ffcf44e272662f6ac451a8d6d6ff951715db651c8d4907ec659cbde46abd52d3
+SIZE (postgresql/postgresql-16beta3.tar.bz2) = 24313365
diff --git a/databases/postgresql16-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql16-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
index a82826b3b5f1..9469421174a0 100644
--- a/databases/postgresql16-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ b/databases/postgresql16-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
-
-
- #------------------------------------------------------------------------------