Date: Thu, 16 Jun 2022 13:09:28 GMT From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org Subject: git: e8704075ff79 - main - databases/postgresql14-server: update to 14.4 Message-ID: <202206161309.25GD9Sw3029908@gitrepo.freebsd.org>
next in thread | raw e-mail | index | archive | help
The branch main has been updated by girgen: URL: https://cgit.FreeBSD.org/ports/commit/?id=e8704075ff7970018fce6b7eeb03ca19dd44a303 commit e8704075ff7970018fce6b7eeb03ca19dd44a303 Author: Palle Girgensohn <girgen@FreeBSD.org> AuthorDate: 2022-06-14 18:59:36 +0000 Commit: Palle Girgensohn <girgen@FreeBSD.org> 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 <girgen@FreeBSD.org> 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 <scrappy@FreeBSD.org> -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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?202206161309.25GD9Sw3029908>