postgresql1N: updated to 14.2, 13.6, 12.10, 11.15, and 10.20

PostgreSQL 14.2, 13.6, 12.10, 11.15, and 10.20 Released!

This update fixes over 55 bugs that were reported in the last several months. The issues listed below affect PostgreSQL 14. Some of these issues may also affect other supported versions of PostgreSQL.

Included in this release:

Fix for a low probability scenario of index corruption when a HOT (heap-only tuple) chain changes state during VACUUM. Encountering this issue is unlikely, but if you are concerned, please consider reindexing.
Fix for using REINDEX CONCURRENTLY on TOAST table indexes to prevent corruption. You can fix any TOAST indexes by reindexing them again.
The psql \password command now defaults to setting the password for the role defined by CURRENT_USER. Additionally, the role name is now included in the password prompt.
Build extended statistics for partitioned tables. If you previously added extended statistics to a partitioned table, you should run ANALYZE on those tables. As autovacuum currently does not process partitioned tables, you must periodically run ANALYZE on any partitioned tables to update their statistics.
Fix crash with ALTER STATISTICS when the statistics object is dropped concurrently.
Fix crash with multiranges when extracting variable-length data types.
Several fixes to the query planner that lead to incorrect query results.
Several fixes for query plan memoization.
Fix startup of a physical replica to tolerate transaction ID wraparound.
When using logical replication, avoid duplicate transmission of a partitioned table's data when the publication includes both the child and parent tables.
Disallow altering data type of a partitioned table's columns when the partitioned table's row type is used as a composite type elsewhere.
Disallow ALTER TABLE ... DROP NOT NULL for a column that is part of a replica identity index.
Several fixes for caching that correct logical replication behavior and improve performance.
Fix memory leak when updating expression indexes.
Avoid leaking memory during REASSIGN OWNED BY operations that reassign ownership of many objects.
Fix display of whole-row variables appearing in INSERT ... VALUES rules.
Fix race condition that could lead to failure to localize error messages that are reported early in multi-threaded use of libpq or ecpglib.
Fix psql \d command for identifying parent triggers.
Fix failures on Windows when using the terminal as data source or destination. This affected the psql \copy command and using pg_recvlogical with -f -.
Fix the pg_dump --inserts and --column-inserts modes to handle tables that contain both generated and dropped columns.
Fix edge cases in how postgres_fdw handles asynchronous queries. These errors could lead to crashes or incorrect results when attempting to run parallel scans of foreign tables.
For the full list of changes available, please review the release notes.

56 files changed, 82 insertions, 116 deletions

diff --git a/databases/postgresql10-client/Makefile b/databases/postgresql10-client/Makefile
index 8e0cde30978..966c4d313f1 100644
--- a/databases/postgresql10-client/Makefile
+++ b/databases/postgresql10-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.21 2021/12/08 16:03:42 adam Exp $
+# $NetBSD: Makefile,v 1.22 2022/02/11 08:31:20 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql10/Makefile.common"
diff --git a/databases/postgresql10-contrib/Makefile b/databases/postgresql10-contrib/Makefile
index fc7a92a4616..dca60e22efd 100644
--- a/databases/postgresql10-contrib/Makefile
+++ b/databases/postgresql10-contrib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.21 2021/12/08 16:03:42 adam Exp $
+# $NetBSD: Makefile,v 1.22 2022/02/11 08:31:20 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-contrib-/}
-PKGREVISION=	1
 COMMENT=	Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql10/Makefile.common"
diff --git a/databases/postgresql10-docs/Makefile b/databases/postgresql10-docs/Makefile
index c70f6826643..f1a107b840d 100644
--- a/databases/postgresql10-docs/Makefile
+++ b/databases/postgresql10-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.15 2022/02/11 08:31:20 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql10/Makefile.common"
diff --git a/databases/postgresql10-docs/PLIST b/databases/postgresql10-docs/PLIST
index 00f152e98e6..ee1ab5fc0f3 100644
--- a/databases/postgresql10-docs/PLIST
+++ b/databases/postgresql10-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.20 2021/11/16 10:14:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.21 2022/02/11 08:31:20 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -929,6 +929,7 @@ share/doc/postgresql/html/release-10-17.html
 share/doc/postgresql/html/release-10-18.html
 share/doc/postgresql/html/release-10-19.html
 share/doc/postgresql/html/release-10-2.html
+share/doc/postgresql/html/release-10-20.html
 share/doc/postgresql/html/release-10-3.html
 share/doc/postgresql/html/release-10-4.html
 share/doc/postgresql/html/release-10-5.html
diff --git a/databases/postgresql10-plperl/Makefile b/databases/postgresql10-plperl/Makefile
index bd35b95ba3b..e625012bcae 100644
--- a/databases/postgresql10-plperl/Makefile
+++ b/databases/postgresql10-plperl/Makefile
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.17 2021/12/08 16:03:43 adam Exp $
+#$ $NetBSD: Makefile,v 1.18 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff --git a/databases/postgresql10-plpython/Makefile b/databases/postgresql10-plpython/Makefile
index 4143ea5a7b0..2091e0a5fc7 100644
--- a/databases/postgresql10-plpython/Makefile
+++ b/databases/postgresql10-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.21 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.22 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff --git a/databases/postgresql10-pltcl/Makefile b/databases/postgresql10-pltcl/Makefile
index ad1e69edb19..10f84221bad 100644
--- a/databases/postgresql10-pltcl/Makefile
+++ b/databases/postgresql10-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.19 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server
diff --git a/databases/postgresql10-server/Makefile b/databases/postgresql10-server/Makefile
index ae11486df9a..994bd3159d7 100644
--- a/databases/postgresql10-server/Makefile
+++ b/databases/postgresql10-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.23 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql10/Makefile b/databases/postgresql10/Makefile
index be01650f89b..703088ec929 100644
--- a/databases/postgresql10/Makefile
+++ b/databases/postgresql10/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2021/12/08 16:03:42 adam Exp $
+# $NetBSD: Makefile,v 1.29 2022/02/11 08:31:20 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql10-client>=${PKGVERSION_NOREV}:../../databases/postgresql10-client
diff --git a/databases/postgresql10/Makefile.common b/databases/postgresql10/Makefile.common
index b5a8c965370..944f995621c 100644
--- a/databases/postgresql10/Makefile.common
+++ b/databases/postgresql10/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.31 2021/11/16 10:14:36 adam Exp $
+# $NetBSD: Makefile.common,v 1.32 2022/02/11 08:31:20 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=	postgresql-10.19
+DISTNAME=	postgresql-10.20
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql10/distinfo b/databases/postgresql10/distinfo
index 13452904b30..deb3f71059d 100644
--- a/databases/postgresql10/distinfo
+++ b/databases/postgresql10/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.25 2021/11/16 10:14:36 adam Exp $
+$NetBSD: distinfo,v 1.26 2022/02/11 08:31:20 adam Exp $
 
-BLAKE2s (postgresql-10.19.tar.bz2) = fc851119bc8796bb1d7a27313bbd685583c6667634d073795e1f3a06d336c0b6
-SHA512 (postgresql-10.19.tar.bz2) = 41b0f5026be7d563e41b54e9ea7199dd466a132d355be0b71a91d41f533d97fbf550eccf2a2ece3d60c5dab5921ebeea3ac4780c18c54b924df52d7423305a22
-Size (postgresql-10.19.tar.bz2) = 19261478 bytes
+BLAKE2s (postgresql-10.20.tar.bz2) = 3bdc7eed893b1e73b7170e527b12699ada8f90a844e876bb029ad4026bf95a55
+SHA512 (postgresql-10.20.tar.bz2) = 44cfca541947d58c70593b767d3c2423f20cc6904f3d4cea8f63c1802ccbc569130c4a2a15f1af152285926f6a200e13d59c21584295dafd6f6e74bd38251428
+Size (postgresql-10.20.tar.bz2) = 19371473 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql11-client/Makefile b/databases/postgresql11-client/Makefile
index bd9142495c8..f1fd1d9f76f 100644
--- a/databases/postgresql11-client/Makefile
+++ b/databases/postgresql11-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.18 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql11/Makefile.common"
diff --git a/databases/postgresql11-contrib/Makefile b/databases/postgresql11-contrib/Makefile
index 63f71c4fda2..912c4077b24 100644
--- a/databases/postgresql11-contrib/Makefile
+++ b/databases/postgresql11-contrib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.19 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-contrib-/}
-PKGREVISION=	1
 COMMENT=	Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql11/Makefile.common"
diff --git a/databases/postgresql11-docs/Makefile b/databases/postgresql11-docs/Makefile
index 393166b1ea3..adcfe3ae2d7 100644
--- a/databases/postgresql11-docs/Makefile
+++ b/databases/postgresql11-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.13 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql11/Makefile.common"
diff --git a/databases/postgresql11-docs/PLIST b/databases/postgresql11-docs/PLIST
index 6b2325432b1..a9a7f13b6fb 100644
--- a/databases/postgresql11-docs/PLIST
+++ b/databases/postgresql11-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2021/11/16 10:14:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.16 2022/02/11 08:31:21 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -959,6 +959,7 @@ share/doc/postgresql/html/release-11-11.html
 share/doc/postgresql/html/release-11-12.html
 share/doc/postgresql/html/release-11-13.html
 share/doc/postgresql/html/release-11-14.html
+share/doc/postgresql/html/release-11-15.html
 share/doc/postgresql/html/release-11-2.html
 share/doc/postgresql/html/release-11-3.html
 share/doc/postgresql/html/release-11-4.html
diff --git a/databases/postgresql11-plperl/Makefile b/databases/postgresql11-plperl/Makefile
index b482f90e803..2ad91eb628c 100644
--- a/databases/postgresql11-plperl/Makefile
+++ b/databases/postgresql11-plperl/Makefile
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.15 2021/12/08 16:03:44 adam Exp $
+#$ $NetBSD: Makefile,v 1.16 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff --git a/databases/postgresql11-plpython/Makefile b/databases/postgresql11-plpython/Makefile
index 60b1b1318ec..d470e86946d 100644
--- a/databases/postgresql11-plpython/Makefile
+++ b/databases/postgresql11-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.20 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff --git a/databases/postgresql11-pltcl/Makefile b/databases/postgresql11-pltcl/Makefile
index d36c7a473a4..485dd35bb17 100644
--- a/databases/postgresql11-pltcl/Makefile
+++ b/databases/postgresql11-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.17 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server
diff --git a/databases/postgresql11-server/Makefile b/databases/postgresql11-server/Makefile
index de3448c285b..b410e3e81d2 100644
--- a/databases/postgresql11-server/Makefile
+++ b/databases/postgresql11-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.20 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql11/Makefile b/databases/postgresql11/Makefile
index 861d9a7199a..6bcc6aff29a 100644
--- a/databases/postgresql11/Makefile
+++ b/databases/postgresql11/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2021/12/08 16:03:43 adam Exp $
+# $NetBSD: Makefile,v 1.21 2022/02/11 08:31:21 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-/}
-PKGREVISION=	2
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql11-client>=${PKGVERSION_NOREV}:../../databases/postgresql11-client
diff --git a/databases/postgresql11/Makefile.common b/databases/postgresql11/Makefile.common
index 15f31025953..3af83119f80 100644
--- a/databases/postgresql11/Makefile.common
+++ b/databases/postgresql11/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.24 2021/11/16 10:14:37 adam Exp $
+# $NetBSD: Makefile.common,v 1.25 2022/02/11 08:31:21 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql11-pltcl/Makefile
 # used by databases/postgresql11-server/Makefile
 
-DISTNAME=	postgresql-11.14
+DISTNAME=	postgresql-11.15
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql11/distinfo b/databases/postgresql11/distinfo
index 8893dd8d92c..6805c2c0805 100644
--- a/databases/postgresql11/distinfo
+++ b/databases/postgresql11/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.20 2021/11/16 10:14:37 adam Exp $
+$NetBSD: distinfo,v 1.21 2022/02/11 08:31:21 adam Exp $
 
-BLAKE2s (postgresql-11.14.tar.bz2) = 54eff3d77ba619e5c132e4617d16f9a3e2016306e5b8083e017deec1a26f7820
-SHA512 (postgresql-11.14.tar.bz2) = ab71461ee6fb4cdc5b4240f7ecd8af2497ce6780283fde2abf5951ffdb616bd0c8ed22b26fdfca402a346e663ff77c4d17f3284c9d700e6fd6795b2aec97c9be
-Size (postgresql-11.14.tar.bz2) = 20172910 bytes
+BLAKE2s (postgresql-11.15.tar.bz2) = e6f70c1693bba23c70127b0234494d2d7a43b4e5a0f80f26477090e4fff6e4fa
+SHA512 (postgresql-11.15.tar.bz2) = 1eba7bddee1edf034617102c1d61ad0aa1b58927dad63de1d054817966c4c9a1d7d3fa6f6896af3fe5a6880b09a6ec86be298256ee6ecc3705ff2654d3d00c74
+Size (postgresql-11.15.tar.bz2) = 20245750 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql12-client/Makefile b/databases/postgresql12-client/Makefile
index 62e2e1a8e08..2c0f23cd3eb 100644
--- a/databases/postgresql12-client/Makefile
+++ b/databases/postgresql12-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.20 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql12/Makefile.common"
diff --git a/databases/postgresql12-contrib/Makefile b/databases/postgresql12-contrib/Makefile
index 34c1c00e9a1..fe4bdd28d37 100644
--- a/databases/postgresql12-contrib/Makefile
+++ b/databases/postgresql12-contrib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.19 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-contrib-/}
-PKGREVISION=	1
 COMMENT=	Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql12/Makefile.common"
diff --git a/databases/postgresql12-docs/Makefile b/databases/postgresql12-docs/Makefile
index af1262dc078..c7658be0deb 100644
--- a/databases/postgresql12-docs/Makefile
+++ b/databases/postgresql12-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.13 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql12/Makefile.common"
diff --git a/databases/postgresql12-docs/PLIST b/databases/postgresql12-docs/PLIST
index 7372fd30150..ca9bcde9fd3 100644
--- a/databases/postgresql12-docs/PLIST
+++ b/databases/postgresql12-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2021/11/16 10:14:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2022/02/11 08:31:22 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -962,6 +962,7 @@ share/doc/postgresql/html/regress-tap.html
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-12-1.html
+share/doc/postgresql/html/release-12-10.html
 share/doc/postgresql/html/release-12-2.html
 share/doc/postgresql/html/release-12-3.html
 share/doc/postgresql/html/release-12-4.html
diff --git a/databases/postgresql12-plperl/Makefile b/databases/postgresql12-plperl/Makefile
index 616ad754e59..c12880ebca8 100644
--- a/databases/postgresql12-plperl/Makefile
+++ b/databases/postgresql12-plperl/Makefile
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.15 2021/12/08 16:03:45 adam Exp $
+#$ $NetBSD: Makefile,v 1.16 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server
diff --git a/databases/postgresql12-plpython/Makefile b/databases/postgresql12-plpython/Makefile
index 1925f904f8d..ed5a49e6ec3 100644
--- a/databases/postgresql12-plpython/Makefile
+++ b/databases/postgresql12-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.18 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server
diff --git a/databases/postgresql12-pltcl/Makefile b/databases/postgresql12-pltcl/Makefile
index 121bd06cdf5..f75ce671fed 100644
--- a/databases/postgresql12-pltcl/Makefile
+++ b/databases/postgresql12-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.17 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server
diff --git a/databases/postgresql12-server/Makefile b/databases/postgresql12-server/Makefile
index 966ec060c44..93d776f22c6 100644
--- a/databases/postgresql12-server/Makefile
+++ b/databases/postgresql12-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.19 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql12/Makefile b/databases/postgresql12/Makefile
index f25f2221a83..41148d73fde 100644
--- a/databases/postgresql12/Makefile
+++ b/databases/postgresql12/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.19 2021/12/08 16:03:44 adam Exp $
+# $NetBSD: Makefile,v 1.20 2022/02/11 08:31:22 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql12-client>=${PKGVERSION_NOREV}:../../databases/postgresql12-client
diff --git a/databases/postgresql12/Makefile.common b/databases/postgresql12/Makefile.common
index 78464396484..70f3e18520f 100644
--- a/databases/postgresql12/Makefile.common
+++ b/databases/postgresql12/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2021/11/16 10:14:37 adam Exp $
+# $NetBSD: Makefile.common,v 1.18 2022/02/11 08:31:22 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql12-pltcl/Makefile
 # used by databases/postgresql12-server/Makefile
 
-DISTNAME=	postgresql-12.9
+DISTNAME=	postgresql-12.10
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql12/distinfo b/databases/postgresql12/distinfo
index bf76350cf44..70e9a9e0d40 100644
--- a/databases/postgresql12/distinfo
+++ b/databases/postgresql12/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.14 2021/11/16 10:14:37 adam Exp $
+$NetBSD: distinfo,v 1.15 2022/02/11 08:31:22 adam Exp $
 
-BLAKE2s (postgresql-12.9.tar.bz2) = 49e63f4232284b7e3571ca903d0545be889342c15fec3729c4ab4adc16d53ba8
-SHA512 (postgresql-12.9.tar.bz2) = 11697d8283f5df5a9c74c2406e94d1b6da6df8358ad48f3b773825aab98e8395f9fd4e3fc8b1e6ebad3743c3dadbda8b795d4fe84a447d7913223e136cf2b88f
-Size (postgresql-12.9.tar.bz2) = 20904260 bytes
+BLAKE2s (postgresql-12.10.tar.bz2) = a8e9dac32b8460b4112e2ce2eb04ba7a5a7541b053dafda7d23a5dcc18b6f402
+SHA512 (postgresql-12.10.tar.bz2) = befedb14320aa033dc55bbb93bbbec4e67d9cfced63be0e4f631c7495a0fbc6fe280bd6d2fb941d7a2e6b2ac570b7f40d8db7f07a192a81bd9cd63c6c244a9c5
+Size (postgresql-12.10.tar.bz2) = 20990621 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql13-client/Makefile b/databases/postgresql13-client/Makefile
index 40c67db3037..1d88f60df96 100644
--- a/databases/postgresql13-client/Makefile
+++ b/databases/postgresql13-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.12 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql13/Makefile.common"
diff --git a/databases/postgresql13-contrib/Makefile b/databases/postgresql13-contrib/Makefile
index c1f7a25dcf8..7836578e1b4 100644
--- a/databases/postgresql13-contrib/Makefile
+++ b/databases/postgresql13-contrib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.12 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-contrib-/}
-PKGREVISION=	1
 COMMENT=	Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql13/Makefile.common"
diff --git a/databases/postgresql13-docs/Makefile b/databases/postgresql13-docs/Makefile
index 45b8fbedda1..8261efba4ba 100644
--- a/databases/postgresql13-docs/Makefile
+++ b/databases/postgresql13-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.9 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql13/Makefile.common"
diff --git a/databases/postgresql13-docs/PLIST b/databases/postgresql13-docs/PLIST
index 20eaf78b121..193f19b5a01 100644
--- a/databases/postgresql13-docs/PLIST
+++ b/databases/postgresql13-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2021/11/16 10:14:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2022/02/11 08:31:23 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -974,6 +974,7 @@ share/doc/postgresql/html/release-13-2.html
 share/doc/postgresql/html/release-13-3.html
 share/doc/postgresql/html/release-13-4.html
 share/doc/postgresql/html/release-13-5.html
+share/doc/postgresql/html/release-13-6.html
 share/doc/postgresql/html/release-13.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff --git a/databases/postgresql13-plperl/Makefile b/databases/postgresql13-plperl/Makefile
index 89402fc58e5..fa9bc3d2696 100644
--- a/databases/postgresql13-plperl/Makefile
+++ b/databases/postgresql13-plperl/Makefile
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.10 2021/12/08 16:03:46 adam Exp $
+#$ $NetBSD: Makefile,v 1.11 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server
diff --git a/databases/postgresql13-plpython/Makefile b/databases/postgresql13-plpython/Makefile
index f789d0c4ae0..2cac6f4c345 100644
--- a/databases/postgresql13-plpython/Makefile
+++ b/databases/postgresql13-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.12 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server
diff --git a/databases/postgresql13-pltcl/Makefile b/databases/postgresql13-pltcl/Makefile
index 5694c9c49a2..dd3d2537e89 100644
--- a/databases/postgresql13-pltcl/Makefile
+++ b/databases/postgresql13-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.11 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server
diff --git a/databases/postgresql13-server/Makefile b/databases/postgresql13-server/Makefile
index 5e29453fc93..754cab25365 100644
--- a/databases/postgresql13-server/Makefile
+++ b/databases/postgresql13-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.11 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql13/Makefile b/databases/postgresql13/Makefile
index ee60f67bf5c..7793e31bf67 100644
--- a/databases/postgresql13/Makefile
+++ b/databases/postgresql13/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2021/12/08 16:03:45 adam Exp $
+# $NetBSD: Makefile,v 1.11 2022/02/11 08:31:23 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql13-client>=${PKGVERSION_NOREV}:../../databases/postgresql13-client
diff --git a/databases/postgresql13/Makefile.common b/databases/postgresql13/Makefile.common
index f7e7fc53d43..f8c0bb1bb4f 100644
--- a/databases/postgresql13/Makefile.common
+++ b/databases/postgresql13/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2021/11/16 10:14:37 adam Exp $
+# $NetBSD: Makefile.common,v 1.11 2022/02/11 08:31:23 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql13-pltcl/Makefile
 # used by databases/postgresql13-server/Makefile
 
-DISTNAME=	postgresql-13.5
+DISTNAME=	postgresql-13.6
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql13/distinfo b/databases/postgresql13/distinfo
index f67ee575526..90f42e3f969 100644
--- a/databases/postgresql13/distinfo
+++ b/databases/postgresql13/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.11 2021/12/12 21:20:38 nros Exp $
+$NetBSD: distinfo,v 1.12 2022/02/11 08:31:23 adam Exp $
 
-BLAKE2s (postgresql-13.5.tar.bz2) = d57be90445afc8f6680aa3b0c7a314352437adc08f0a3559751b5036c59bd2a6
-SHA512 (postgresql-13.5.tar.bz2) = c76effbca8ee63be48fa3aeb39c7038221848fe83ca2afc4e0904ba8c6a50b89aa2ad37080d4e3be75e9bdc2d6ca6dfefcda334ef55a5e1a8954bb955ce905e5
-Size (postgresql-13.5.tar.bz2) = 21186674 bytes
+BLAKE2s (postgresql-13.6.tar.bz2) = 9441445ed8495e6f19955d8051829b471279dad9a1ecb8b59aed81786498a473
+SHA512 (postgresql-13.6.tar.bz2) = 2852726a3031b8d469f1c38f3019af02fc5afe40ec27b22288a29acefd30c63a98806bce88a214d0c2f9177f547b0b5010ad64e70bcbe2c2f1d97a27ae1984f8
+Size (postgresql-13.6.tar.bz2) = 21257213 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
diff --git a/databases/postgresql14-client/Makefile b/databases/postgresql14-client/Makefile
index c272f97e9ec..81accfd0e83 100644
--- a/databases/postgresql14-client/Makefile
+++ b/databases/postgresql14-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql14/Makefile.common"
diff --git a/databases/postgresql14-client/PLIST b/databases/postgresql14-client/PLIST
index 8130439a69d..406eafbd58a 100644
--- a/databases/postgresql14-client/PLIST
+++ b/databases/postgresql14-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2021/11/16 10:14:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2022/02/11 08:31:24 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -947,6 +947,7 @@ ${PLIST.nls}share/locale/el/LC_MESSAGES/initdb-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/libpq5-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/pg_amcheck-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/pg_archivecleanup-14.mo
+${PLIST.nls}share/locale/el/LC_MESSAGES/pg_basebackup-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/pg_checksums-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/pg_config-14.mo
 ${PLIST.nls}share/locale/el/LC_MESSAGES/pg_controldata-14.mo
diff --git a/databases/postgresql14-contrib/Makefile b/databases/postgresql14-contrib/Makefile
index 9c71a2c84c4..b0db5a9d9e9 100644
--- a/databases/postgresql14-contrib/Makefile
+++ b/databases/postgresql14-contrib/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-contrib-/}
-PKGREVISION=	1
 COMMENT=	Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql14/Makefile.common"
diff --git a/databases/postgresql14-docs/Makefile b/databases/postgresql14-docs/Makefile
index 0f75a6bfc40..6fbbbee8959 100644
--- a/databases/postgresql14-docs/Makefile
+++ b/databases/postgresql14-docs/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-docs-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database documentation
 
 .include "../../databases/postgresql14/Makefile.common"
diff --git a/databases/postgresql14-docs/PLIST b/databases/postgresql14-docs/PLIST
index 0020a72ae75..05808c13f32 100644
--- a/databases/postgresql14-docs/PLIST
+++ b/databases/postgresql14-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2021/11/16 10:14:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2022/02/11 08:31:24 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -986,6 +986,7 @@ share/doc/postgresql/html/regress-tap.html
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-14-1.html
+share/doc/postgresql/html/release-14-2.html
 share/doc/postgresql/html/release-14.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff --git a/databases/postgresql14-plperl/Makefile b/databases/postgresql14-plperl/Makefile
index c13ef28dfd7..10c5627519c 100644
--- a/databases/postgresql14-plperl/Makefile
+++ b/databases/postgresql14-plperl/Makefile
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.2 2021/12/08 16:03:47 adam Exp $
+#$ $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-plperl-/}
-PKGREVISION=	1
 COMMENT=	PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server
diff --git a/databases/postgresql14-plpython/Makefile b/databases/postgresql14-plpython/Makefile
index fb5be5df747..9a0b1c5414a 100644
--- a/databases/postgresql14-plpython/Makefile
+++ b/databases/postgresql14-plpython/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:47 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-plpython-/}
-PKGREVISION=	1
 COMMENT=	PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server
diff --git a/databases/postgresql14-pltcl/Makefile b/databases/postgresql14-pltcl/Makefile
index c052e6ec5b5..efbf48f7df0 100644
--- a/databases/postgresql14-pltcl/Makefile
+++ b/databases/postgresql14-pltcl/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:47 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-pltcl-/}
-PKGREVISION=	1
 COMMENT=	PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=	postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server
diff --git a/databases/postgresql14-server/Makefile b/databases/postgresql14-server/Makefile
index 566a7efff58..f3907b75c8b 100644
--- a/databases/postgresql14-server/Makefile
+++ b/databases/postgresql14-server/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2021/12/08 16:03:47 adam Exp $
+# $NetBSD: Makefile,v 1.3 2022/02/11 08:31:25 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-server-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database server programs
 
 # mips has no TAS implementation
diff --git a/databases/postgresql14/Makefile b/databases/postgresql14/Makefile
index cc8d788f785..905d3b67351 100644
--- a/databases/postgresql14/Makefile
+++ b/databases/postgresql14/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2021/12/08 16:03:46 adam Exp $
+# $NetBSD: Makefile,v 1.5 2022/02/11 08:31:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-/}
-PKGREVISION=	1
 COMMENT=	Robust, next generation, object-relational DBMS
 
 DEPENDS+=	postgresql14-client>=${PKGVERSION_NOREV}:../../databases/postgresql14-client
diff --git a/databases/postgresql14/Makefile.common b/databases/postgresql14/Makefile.common
index b4132b166d9..4242920176b 100644
--- a/databases/postgresql14/Makefile.common
+++ b/databases/postgresql14/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.2 2021/11/16 10:14:38 adam Exp $
+# $NetBSD: Makefile.common,v 1.3 2022/02/11 08:31:24 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql14-pltcl/Makefile
 # used by databases/postgresql14-server/Makefile
 
-DISTNAME=	postgresql-14.1
+DISTNAME=	postgresql-14.2
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql14/distinfo b/databases/postgresql14/distinfo
index c8cea046f52..9b883933259 100644
--- a/databases/postgresql14/distinfo
+++ b/databases/postgresql14/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.4 2021/11/16 10:14:38 adam Exp $
+$NetBSD: distinfo,v 1.5 2022/02/11 08:31:24 adam Exp $
 
-BLAKE2s (postgresql-14.1.tar.bz2) = 03b32a14ca1839581900b012c36d7aeaa4333e9a5024c75a3e7067bb4c0aff3d
-SHA512 (postgresql-14.1.tar.bz2) = 4a0bec157d5464bb9e5f5c0eb0efdede55526e03f6f4d660b87d161a47705eb152fa0878960b1581bce42a5ed28a1f457825ea54e8d22e34b5b8eb36473ceefd
-Size (postgresql-14.1.tar.bz2) = 21887101 bytes
+BLAKE2s (postgresql-14.2.tar.bz2) = 065346daa76b51cabcb161b800f5dbd44399525598868e8e0cafb431f4e2650e
+SHA512 (postgresql-14.2.tar.bz2) = 19aeb6528605dbcf5df84048b2eed8f54b202576134d3fe3900bb8f073179c4258d2581acd745887e7e6fa86ebdb5f7b159ffaa0a645d601efee7c5f7730456b
+Size (postgresql-14.2.tar.bz2) = 21964841 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9