diff options
| author | Palle Girgensohn <girgen@FreeBSD.org> | 2022-06-14 18:59:36 +0000 |
|---|---|---|
| committer | Palle Girgensohn <girgen@FreeBSD.org> | 2022-06-16 13:08:02 +0000 |
| commit | e8704075ff7970018fce6b7eeb03ca19dd44a303 (patch) | |
| tree | e43551537c6f723c0bd851ebf41e34f771984d55 | |
| parent | 817e9c1c4a67a3c41b032a76214d5675140477ec (diff) | |
| download | ports-e8704075ff7970018fce6b7eeb03ca19dd44a303.tar.gz ports-e8704075ff7970018fce6b7eeb03ca19dd44a303.zip | |
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
| -rw-r--r-- | databases/postgresql14-client/Makefile | 2 | ||||
| -rw-r--r-- | databases/postgresql14-server/Makefile | 4 | ||||
| -rw-r--r-- | 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 |