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 /databases/postgresql14-client | |
| 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
Diffstat (limited to 'databases/postgresql14-client')
| -rw-r--r-- | databases/postgresql14-client/Makefile | 2 |
1 files changed, 1 insertions, 1 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) |