diff options
authorPalle Girgensohn <girgen@FreeBSD.org>2022-06-14 18:59:36 +0000
committerPalle Girgensohn <girgen@FreeBSD.org>2022-06-16 13:08:02 +0000
commite8704075ff7970018fce6b7eeb03ca19dd44a303 (patch)
parent817e9c1c4a67a3c41b032a76214d5675140477ec (diff)
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
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
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>
# 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.
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