From nobody Thu Jun 16 13:09:28 2022 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 00BA883B126; Thu, 16 Jun 2022 13:09:29 +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 4LP2ZJ6cVWz4pQd; Thu, 16 Jun 2022 13:09:28 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1655384968; 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=uhzyD3g+t/F+oNwmKdQCy0iQZKwFyjGENWO7n75Prqg=; b=lhd8ebnA5JiNOCSstNpPtHafoD2QKJdvTQmw6WVKFJG4iFF4wDaOXFmI4+/GG/4b76B6wz H5nfgZyhUsVvLknHWd/+oKfQbbVplCm1TCaeV9IOv54IDl5v+WjUtHb1Whg6Yd4HqCh1+k ie8OXkPNwJF14mwS9Nj0m6jy71M/n47y9QVmMBuPmysn6wJOG4nIqsDfi7+CBBCV5pvfnU WqKnzQzLMl2E78W/sneyavEDbSVvOd82gtyGE+ZNsQ0QEXhl9sAYt0/omqH8mkkKWRDjyW KpcP10CUjRqTWtXZ/pMhV7GgI3I57U9a6+lB4L7txO07hd2/QUT1uLskV2f2Lw== 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 C36863D7D; Thu, 16 Jun 2022 13:09:28 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 25GD9SYp029909; Thu, 16 Jun 2022 13:09:28 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 25GD9Sw3029908; Thu, 16 Jun 2022 13:09:28 GMT (envelope-from git) Date: Thu, 16 Jun 2022 13:09:28 GMT Message-Id: <202206161309.25GD9Sw3029908@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: e8704075ff79 - main - databases/postgresql14-server: update to 14.4 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: e8704075ff7970018fce6b7eeb03ca19dd44a303 Auto-Submitted: auto-generated ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1655384968; 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=uhzyD3g+t/F+oNwmKdQCy0iQZKwFyjGENWO7n75Prqg=; b=Onl5x4aqV5JUIxSzHWavUaqBfDU0CEro6hT3tPgK/Hay1WrfRMpy03LWX16KOZ0wi8ZgDk BslNun6/1B88OEVKqvFirIq4be9lEDIgQRoztXaS3WryQMaSCzADpZ/ZULDZ1E1aIaDJIc svNPpXLOLf3LPSUawSEjfM767yQvg7oiVWb7OBxD3UmeFeQP+CA8cacPBxcHeJ+95/BwqI w8zzPgcD0eHN4N4MR7y28haoscz89k/Zcx9TTdr1JPdQp2nIvzEO43JklqblEgnFFk4ska BQ5ZjdEO3QaSR8oEAYfEgwsbdxZce9qKLt+A0j7psZmQsWdFsAyMf/tsrivxTA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1655384968; a=rsa-sha256; cv=none; b=QtyW4n25xbZZvs1dNjtFX/5ksxTdPFdDANhyFpILW0MDxeZ/WvDGqhS7KqiqwB+u5UF+kJ cowdxGhRG77bx12aIXhRlKmt0O0BrEZvCPDI4tkWfA4yA6nli4pnG66r8tj/dMRPx56qiN weSEQTpFp8COyFtG7idS8f3A+6bDhfxEhHxBG8blEXQxkBh/mXRx90BrVrK9O1e+5FycN1 rjzAflwb4GeqXPvSmCXSk+Dj5rkWfuatONUFKPH16FP3fKV++v61LeioXOSkLz8A/MfEkE EuIJ5OWGCca66QQ4F74xcqAx34GL5gtA1xikprM5w9+NuMYw8/vsMycVb7D6Pw== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by girgen: URL: https://cgit.FreeBSD.org/ports/commit/?id=e8704075ff7970018fce6b7eeb03ca19dd44a303 commit e8704075ff7970018fce6b7eeb03ca19dd44a303 Author: Palle Girgensohn AuthorDate: 2022-06-14 18:59:36 +0000 Commit: Palle Girgensohn CommitDate: 2022-06-16 13:08:02 +0000 databases/postgresql14-server: update to 14.4 This release fixes an issue with all versions of PostgreSQL 14 that can lead to silent corruption of indexes. Since the release of PostgreSQL 14.0, there existed an issue with CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY that could cause silent data corruption in indexes. This issue is fixed in the upcoming PostgreSQL 14.4 release. If you ran either of these commands on any version of PostgreSQL 14 prior to 14.4, you may have experienced silent data corruption. You can use the pg_amcheck command with the --heapallindexed flag to detect this issue with B-tree indexes. If you need an immediate remediation for this issue before the PostgreSQL 14.4 release, you can run CREATE INDEX or REINDEX without CONCURRENTLY. You can also run the reindexdb command and use the --jobs flag for added parallelism, but do not use the --concurrently flag. Once PostgreSQL 14.4 is released, you can safely use CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY to manage your indexes, as well as the --concurrently flag on reindexdb. URL: https://www.postgresql.org/message-id/165473835807.573551.1512237163040609764%40wrigleys.postgresql.org --- databases/postgresql14-client/Makefile | 2 +- databases/postgresql14-server/Makefile | 4 ++-- databases/postgresql14-server/distinfo | 6 +++--- 3 files changed, 6 insertions(+), 6 deletions(-) diff --git a/databases/postgresql14-client/Makefile b/databases/postgresql14-client/Makefile index 45c1808aace5..02a463fc2dbd 100644 --- a/databases/postgresql14-client/Makefile +++ b/databases/postgresql14-client/Makefile @@ -1,7 +1,7 @@ # Created by: Palle Girgensohn PORTNAME= postgresql -PORTREVISION= 1 +PORTREVISION= 0 COMMENT= PostgreSQL database (client) diff --git a/databases/postgresql14-server/Makefile b/databases/postgresql14-server/Makefile index edf39b2192a3..84cb28982e07 100644 --- a/databases/postgresql14-server/Makefile +++ b/databases/postgresql14-server/Makefile @@ -1,9 +1,9 @@ # Created by: Marc G. Fournier -DISTVERSION?= 14.3 +DISTVERSION?= 14.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?= 1 +PORTREVISION?= 0 MAINTAINER?= pgsql@FreeBSD.org diff --git a/databases/postgresql14-server/distinfo b/databases/postgresql14-server/distinfo index 63454f8934b3..07c9b4b0ab12 100644 --- a/databases/postgresql14-server/distinfo +++ b/databases/postgresql14-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1652285702 -SHA256 (postgresql/postgresql-14.3.tar.bz2) = 279057368bf59a919c05ada8f95c5e04abb43e74b9a2a69c3d46a20e07a9af38 -SIZE (postgresql/postgresql-14.3.tar.bz2) = 22092190 +TIMESTAMP = 1655233048 +SHA256 (postgresql/postgresql-14.4.tar.bz2) = c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a +SIZE (postgresql/postgresql-14.4.tar.bz2) = 22094218