Date: Fri, 11 Aug 2023 07:52:05 GMT From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-branches@FreeBSD.org Subject: git: ff84b46c4188 - 2023Q3 - databases/postgresql??-*: Update to latest versions. Message-ID: <202308110752.37B7q5cP070758@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch 2023Q3 has been updated by girgen: URL: https://cgit.FreeBSD.org/ports/commit/?id=ff84b46c4188ae0b2094012ea4ef5220d31008b8 commit ff84b46c4188ae0b2094012ea4ef5220d31008b8 Author: Palle Girgensohn <girgen@FreeBSD.org> AuthorDate: 2023-08-10 13:55:07 +0000 Commit: Palle Girgensohn <girgen@FreeBSD.org> CommitDate: 2023-08-11 07:51:55 +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/ (cherry picked from commit 3554a40b0542d6b01a2a92dc78323880ac5aba3c) --- 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 a54841d63ddd..88af6e383017 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 - - - #------------------------------------------------------------------------------
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202308110752.37B7q5cP070758>