From nobody Thu Aug 10 14:13:28 2023 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4RM86J4lYRz4mKXX; Thu, 10 Aug 2023 14:13:28 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4RM86J4ZDXz3VnH; Thu, 10 Aug 2023 14:13:28 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1691676808; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=n3fAKpa41no1QlAwaENdxhVe6E8xulgPUaphbOWvqmk=; b=AAg/1f3NwEOqi1b3n6leuRDabV8qJq3vDOt42PS9K9/suU7wMPl7syrjzi8Q8gaC3Ed0KC ET0MeCLuwMttz0nIhUHkzSSJ26AjFlOfIR5rZl4GVDVce2hILIXQ9fyCUfnzdqzY7i3aZa EhljAZfVsK/X+AV2aLW6mvCwIH6EQ1KWj03Xfy6VgGfRJgxgec+Ra0gt2pA5sI5Pi7DmVH LcbJWg9CarL7nOH+RVzc4iohSDxSXCV6HQUugdExeQOcK0BUlQP4Qx1ejM+9BCLk48i6FH emeKD7GyoWnScFMkTbt8D3KQtcc73PkPdztzkufbeJneamMhYz1LOmo63asPzw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1691676808; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=n3fAKpa41no1QlAwaENdxhVe6E8xulgPUaphbOWvqmk=; b=saYw1Ork4w+yjDBEMYcqVurvMxXweOAOO99+egkhs/x0CxeieIenE1LpJdDEYnuWIUJvjw CntjMrCGQvnb/xfySSe0MCVIH/bUVWYci4O6EUDhy7d1M1+6BPK3o70mjkQjKnJ+FJZidG WZPG/3+tsfkQpuNhQiULR54ZEiz6w0GBsbV9Q1HUygAtLBH7jpuMopzrjUz+pvgp1LVCWI AVw26ZFLqisLiVbG6J7I3QQZz4DvwF2jzvXGdgJzvePXAun47b/8aV1MR1UPO2xfIGaQv5 9rzDhU8bjxfe8eTss18042zQu5T2LLqk0ZZFBtL5CsW2bduwt6tO4yGk7BI5YQ== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1691676808; a=rsa-sha256; cv=none; b=xr/aQuewxg5fxl9jiP+8pV+24ZNCfByjt/HTC8kV4xOflh2RHE2++Sjc6IWeZIU3qsxX3f dYTYxCcmpABXne61g1owWHZRHbjXHH46qX/Uu21wZaGj3XEV5/Vqr/nQ/9Z2tgezY3L/tl SJKLXVasov7PVqV7cfKIpc13EE6/arQiLT8Bo15naeq7uVuLcKzShMpxCdLMXKrAxCVnkh hQnDCgCzMd5zZ+gD6fszNdqUTxzw2Ni017sMfwQfsV/aD0S6N99GNrg2mys0Vup9Ob1ERm yrpIuly6b9Pn9MZojWfxVDBrkjIlS9Im4Qz0VEC5ZLMqyN0pgQGpQ9140dQBZg== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4RM86J3dbLz10hX; Thu, 10 Aug 2023 14:13:28 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 37AEDSPK009002; Thu, 10 Aug 2023 14:13:28 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 37AEDS2L008999; Thu, 10 Aug 2023 14:13:28 GMT (envelope-from git) Date: Thu, 10 Aug 2023 14:13:28 GMT Message-Id: <202308101413.37AEDS2L008999@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Palle Girgensohn Subject: git: 3554a40b0542 - main - databases/postgresql??-*: Update to latest versions. List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: girgen X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 3554a40b0542d6b01a2a92dc78323880ac5aba3c Auto-Submitted: auto-generated The branch main has been updated by girgen: URL: https://cgit.FreeBSD.org/ports/commit/?id=3554a40b0542d6b01a2a92dc78323880ac5aba3c commit 3554a40b0542d6b01a2a92dc78323880ac5aba3c Author: Palle Girgensohn AuthorDate: 2023-08-10 13:55:07 +0000 Commit: Palle Girgensohn 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 - - - #------------------------------------------------------------------------------