postgresql1[0-5]: Updated to 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23

PostgreSQL 15.1, 14.6, 13.9, 12.13, 11.18, and 10.23 Released!

Bug Fixes and Improvements

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

Included in this release:

Fix for updatable views for INSERT statements that include multi-row VALUES clauses with a DEFAULT set.
Disallow rules named _RETURN that are not ON SELECT rules.
Disallow use of MERGE on a partitioned table that has foreign-table partitions.
Fix for construction of per-partition foreign key constraints while doing ALTER TABLE ... ATTACH PARTITION, where previously incorrect or duplicate constraints could be built.
Fix for a planner failure with extended statistics on partitioned or inherited tables.
Fix bugs in logical decoding that could lead to memory leaks when replay starts from a point between the beginning of a transaction and the beginning of its subtransaction.
Fix issues with slow shutdown of replication workers by allowing interrupts in more places.
Disallow logical replication into foreign-table partitions.
Prevent crash in replication works after a SQL or PL/pgSQL function syntax error.
psql -c now exits with a nonzero status if the query is canceled.
Allow cross-platform tablespace relocation in pg_basebackup.
Fix pg_dump to include comments attached to some CHECK constraints.

31 files changed, 92 insertions, 62 deletions

diff --git a/databases/postgresql10-client/Makefile b/databases/postgresql10-client/Makefile
index 7351baf74bd..66368b9ec66 100644
--- a/databases/postgresql10-client/Makefile
+++ b/databases/postgresql10-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.29 2022/10/16 14:42:49 gdt Exp $
+# $NetBSD: Makefile,v 1.30 2022/11/13 09:34:24 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/10-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql10/Makefile.common"
diff --git a/databases/postgresql10-docs/PLIST b/databases/postgresql10-docs/PLIST
index c98524d23f3..6538e1c8584 100644
--- a/databases/postgresql10-docs/PLIST
+++ b/databases/postgresql10-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.23 2022/08/15 20:59:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.24 2022/11/13 09:34:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -932,6 +932,7 @@ share/doc/postgresql/html/release-10-2.html
 share/doc/postgresql/html/release-10-20.html
 share/doc/postgresql/html/release-10-21.html
 share/doc/postgresql/html/release-10-22.html
+share/doc/postgresql/html/release-10-23.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-server/PLIST b/databases/postgresql10-server/PLIST
index 1f854b42340..55b9b6c8c3b 100644
--- a/databases/postgresql10-server/PLIST
+++ b/databases/postgresql10-server/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/11/13 09:34:25 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -522,6 +522,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql10/Makefile.common b/databases/postgresql10/Makefile.common
index c6305aa3ab9..d990f07d715 100644
--- a/databases/postgresql10/Makefile.common
+++ b/databases/postgresql10/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.36 2022/10/16 14:42:49 gdt Exp $
+# $NetBSD: Makefile.common,v 1.37 2022/11/13 09:34: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/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=	postgresql-10.22
+DISTNAME=	postgresql-10.23
 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 66acf612682..53c83f618d0 100644
--- a/databases/postgresql10/distinfo
+++ b/databases/postgresql10/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.28 2022/08/15 20:59:35 adam Exp $
+$NetBSD: distinfo,v 1.29 2022/11/13 09:34:24 adam Exp $
 
-BLAKE2s (postgresql-10.22.tar.bz2) = 05e3691e0952c0b921ad07d23ed3b6c84829b2783c1f624fbb4d9328ede105a1
-SHA512 (postgresql-10.22.tar.bz2) = 2e1ea75be7696ffbbb947351a8e8e55aaf067f86ad318308499a6a58797f0bf86227ed33e257e261c5c71ebba2f73ba514ef195a2394b91414ce6a0c3ab62532
-Size (postgresql-10.22.tar.bz2) = 19455874 bytes
+BLAKE2s (postgresql-10.23.tar.bz2) = ec8bf9714192eb782d4c4b06879cb81979cb60eb88c91f74f29b8bfd6c1993ab
+SHA512 (postgresql-10.23.tar.bz2) = 9fd031cad0c3caacae105215167abd5dc4fdd15dea77a12cb0a977fab6e245e3fda163f202cc7786e50c69e5c3f180d32676a3b18ea30a9a14f0bcab56aa19dd
+Size (postgresql-10.23.tar.bz2) = 19485297 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 b885d2ddbcc..00b48efc6b0 100644
--- a/databases/postgresql11-client/Makefile
+++ b/databases/postgresql11-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile,v 1.26 2022/11/13 09:34:25 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/11-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql11/Makefile.common"
diff --git a/databases/postgresql11-docs/PLIST b/databases/postgresql11-docs/PLIST
index a5b74a96405..ce193b12e3c 100644
--- a/databases/postgresql11-docs/PLIST
+++ b/databases/postgresql11-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2022/08/15 20:59:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2022/11/13 09:34:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -963,6 +963,7 @@ share/doc/postgresql/html/release-11-14.html
 share/doc/postgresql/html/release-11-15.html
 share/doc/postgresql/html/release-11-16.html
 share/doc/postgresql/html/release-11-17.html
+share/doc/postgresql/html/release-11-18.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
@@ -1278,6 +1279,7 @@ share/doc/postgresql/html/sspi-auth.html
 share/doc/postgresql/html/standby-settings.html
 share/doc/postgresql/html/storage-file-layout.html
 share/doc/postgresql/html/storage-fsm.html
+share/doc/postgresql/html/storage-hot.html
 share/doc/postgresql/html/storage-init.html
 share/doc/postgresql/html/storage-page-layout.html
 share/doc/postgresql/html/storage-toast.html
diff --git a/databases/postgresql11-server/PLIST b/databases/postgresql11-server/PLIST
index b31e3ebe27a..9632f10de3f 100644
--- a/databases/postgresql11-server/PLIST
+++ b/databases/postgresql11-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2022/08/15 20:59:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:25 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -701,6 +701,7 @@ ${PLIST.nls}share/locale/ko/LC_MESSAGES/postgres-11.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/plpgsql-11.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/postgres-11.mo
 ${PLIST.nls}share/locale/pt_BR/LC_MESSAGES/plpgsql-11.mo
+${PLIST.nls}share/locale/ro/LC_MESSAGES/plpgsql-11.mo
 ${PLIST.nls}share/locale/ru/LC_MESSAGES/plpgsql-11.mo
 ${PLIST.nls}share/locale/ru/LC_MESSAGES/postgres-11.mo
 ${PLIST.nls}share/locale/sv/LC_MESSAGES/plpgsql-11.mo
@@ -1175,6 +1176,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql11/Makefile.common b/databases/postgresql11/Makefile.common
index f685271235e..c799f9774fe 100644
--- a/databases/postgresql11/Makefile.common
+++ b/databases/postgresql11/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.30 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile.common,v 1.31 2022/11/13 09:34:25 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.17
+DISTNAME=	postgresql-11.18
 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 2f5ba692a16..a1f666eb257 100644
--- a/databases/postgresql11/distinfo
+++ b/databases/postgresql11/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.24 2022/08/15 20:59:36 adam Exp $
+$NetBSD: distinfo,v 1.25 2022/11/13 09:34:25 adam Exp $
 
-BLAKE2s (postgresql-11.17.tar.bz2) = f2b3f901935956881192d727f0cf1b5b65188f97279f2269bf584b495a6fd873
-SHA512 (postgresql-11.17.tar.bz2) = 35304279c06577eca134581490710db976edeac8cca169d3436fcdce8eebb18159459ea3b5ef403f6a8efe85542726f9960c4ca653da4619e081ce5869866032
-Size (postgresql-11.17.tar.bz2) = 20385599 bytes
+BLAKE2s (postgresql-11.18.tar.bz2) = f253b5805de3346c955da01667cd2c954363ff02ba9118f442868fcb1bda30e5
+SHA512 (postgresql-11.18.tar.bz2) = 17b4f9a0200814ae210076a677b9c68375d896bb1817b4f8b327ee208da9a1672625cdcbd213af2b01fe501a051436e9acf5cc9ed0a2b798f257d07b08cdf1b8
+Size (postgresql-11.18.tar.bz2) = 20428126 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 e7645d7e4c6..32aee0a6a2c 100644
--- a/databases/postgresql12-client/Makefile
+++ b/databases/postgresql12-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2022/10/10 12:06:19 gdt Exp $
+# $NetBSD: Makefile,v 1.28 2022/11/13 09:34:25 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/12-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql12/Makefile.common"
diff --git a/databases/postgresql12-client/PLIST b/databases/postgresql12-client/PLIST
index 05c0c7d90fd..533e32cf6f0 100644
--- a/databases/postgresql12-client/PLIST
+++ b/databases/postgresql12-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2022/08/15 20:59:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2022/11/13 09:34:25 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -976,6 +976,7 @@ ${PLIST.nls}share/locale/pl/LC_MESSAGES/ecpg-12.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/ecpglib6-12.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/pg_config-12.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/pg_controldata-12.mo
+${PLIST.nls}share/locale/pl/LC_MESSAGES/pg_ctl-12.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/pg_test_fsync-12.mo
 ${PLIST.nls}share/locale/pl/LC_MESSAGES/pg_test_timing-12.mo
 ${PLIST.nls}share/locale/pt_BR/LC_MESSAGES/ecpg-12.mo
diff --git a/databases/postgresql12-docs/PLIST b/databases/postgresql12-docs/PLIST
index 5563941ddac..c3e752cbbe0 100644
--- a/databases/postgresql12-docs/PLIST
+++ b/databases/postgresql12-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2022/08/15 20:59:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.14 2022/11/13 09:34:26 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -966,6 +966,7 @@ share/doc/postgresql/html/release-12-1.html
 share/doc/postgresql/html/release-12-10.html
 share/doc/postgresql/html/release-12-11.html
 share/doc/postgresql/html/release-12-12.html
+share/doc/postgresql/html/release-12-13.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
@@ -1280,6 +1281,7 @@ share/doc/postgresql/html/sslinfo.html
 share/doc/postgresql/html/sspi-auth.html
 share/doc/postgresql/html/storage-file-layout.html
 share/doc/postgresql/html/storage-fsm.html
+share/doc/postgresql/html/storage-hot.html
 share/doc/postgresql/html/storage-init.html
 share/doc/postgresql/html/storage-page-layout.html
 share/doc/postgresql/html/storage-toast.html
diff --git a/databases/postgresql12-server/PLIST b/databases/postgresql12-server/PLIST
index e9a44e6c34b..637844e6be9 100644
--- a/databases/postgresql12-server/PLIST
+++ b/databases/postgresql12-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2021/11/16 10:14:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:26 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -1192,6 +1192,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql12/Makefile.common b/databases/postgresql12/Makefile.common
index 0a1d2cc0620..2a4aaf16b8a 100644
--- a/databases/postgresql12/Makefile.common
+++ b/databases/postgresql12/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.23 2022/10/10 12:06:19 gdt Exp $
+# $NetBSD: Makefile.common,v 1.24 2022/11/13 09:34:25 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.12
+DISTNAME=	postgresql-12.13
 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 e6527e2970a..6b146f57bdf 100644
--- a/databases/postgresql12/distinfo
+++ b/databases/postgresql12/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.17 2022/08/15 20:59:37 adam Exp $
+$NetBSD: distinfo,v 1.18 2022/11/13 09:34:25 adam Exp $
 
-BLAKE2s (postgresql-12.12.tar.bz2) = d5fcd5f8ab9c605f67059da9029420cc89825d669c351f9e435d9a93e9e55b92
-SHA512 (postgresql-12.12.tar.bz2) = eeff79279ac11db04fdddeb2c52ba1ec6b549223b862222540e1f659fbfc3617130699c22694b465bde46b1a4a665c01aef70b68b86d80e58a5657efd019407d
-Size (postgresql-12.12.tar.bz2) = 21089064 bytes
+BLAKE2s (postgresql-12.13.tar.bz2) = d844dbb61b463277f48de83b063d97f2c9b9d4e5c61018fc529b523f3992dbc6
+SHA512 (postgresql-12.13.tar.bz2) = a502236dcc4c56645dd57ed3c920d996adace3bc3a855c869344c8580393ad4c6ad17503928564683817066f6e9c5794f3d214b5f8e3b900ebb23474673bac24
+Size (postgresql-12.13.tar.bz2) = 21114311 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 5cd4c25328a..ff75b7dc3fb 100644
--- a/databases/postgresql13-client/Makefile
+++ b/databases/postgresql13-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.21 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile,v 1.22 2022/11/13 09:34:26 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/13-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql13/Makefile.common"
diff --git a/databases/postgresql13-docs/PLIST b/databases/postgresql13-docs/PLIST
index 168d61b053b..9c81521dfd9 100644
--- a/databases/postgresql13-docs/PLIST
+++ b/databases/postgresql13-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2022/08/15 20:59:39 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2022/11/13 09:34:26 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -978,6 +978,7 @@ share/doc/postgresql/html/release-13-5.html
 share/doc/postgresql/html/release-13-6.html
 share/doc/postgresql/html/release-13-7.html
 share/doc/postgresql/html/release-13-8.html
+share/doc/postgresql/html/release-13-9.html
 share/doc/postgresql/html/release-13.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
@@ -1284,6 +1285,7 @@ share/doc/postgresql/html/sslinfo.html
 share/doc/postgresql/html/sspi-auth.html
 share/doc/postgresql/html/storage-file-layout.html
 share/doc/postgresql/html/storage-fsm.html
+share/doc/postgresql/html/storage-hot.html
 share/doc/postgresql/html/storage-init.html
 share/doc/postgresql/html/storage-page-layout.html
 share/doc/postgresql/html/storage-toast.html
diff --git a/databases/postgresql13-server/PLIST b/databases/postgresql13-server/PLIST
index 86a2482deb7..e8848183498 100644
--- a/databases/postgresql13-server/PLIST
+++ b/databases/postgresql13-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2021/11/16 10:14:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2022/11/13 09:34:26 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -1193,6 +1193,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql13/Makefile.common b/databases/postgresql13/Makefile.common
index 249df62b539..2e6b4f886f0 100644
--- a/databases/postgresql13/Makefile.common
+++ b/databases/postgresql13/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile.common,v 1.17 2022/11/13 09:34:26 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.8
+DISTNAME=	postgresql-13.9
 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 dd6e959efa9..a35d0c7199f 100644
--- a/databases/postgresql13/distinfo
+++ b/databases/postgresql13/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.15 2022/10/22 18:04:08 nros Exp $
+$NetBSD: distinfo,v 1.16 2022/11/13 09:34:26 adam Exp $
 
-BLAKE2s (postgresql-13.8.tar.bz2) = 234ac7daf17806f31c81f09542663c43f98e96f078aebb8354213d14ae3af86a
-SHA512 (postgresql-13.8.tar.bz2) = 3b39448b291342a5e9b610d410c222aeb85f8acf95632e73e138ae316133af3dadc795a6e706f6447f543cf10df3c786da4f1afa1d91489b50eb77e2d9ed5d84
-Size (postgresql-13.8.tar.bz2) = 21397381 bytes
+BLAKE2s (postgresql-13.9.tar.bz2) = 063a88e670c98acfa1f37c7819918f2563048d3c3e14ce1dc2c4f6d825ba4b2c
+SHA512 (postgresql-13.9.tar.bz2) = 7f226d917c97752a49bb603829789c02820d5a746e89bf879b63cad6ce22b0000762a2f5584af1a928fcb9a444abbf78f6fd8761898291830a21ac42b2d72858
+Size (postgresql-13.9.tar.bz2) = 21439045 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 005712c531b..84e7eddd54d 100644
--- a/databases/postgresql14-client/Makefile
+++ b/databases/postgresql14-client/Makefile
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile,v 1.12 2022/11/13 09:34:26 adam Exp $
 
 PKGNAME=	${DISTNAME:S/-/14-client-/}
-PKGREVISION=	1
 COMMENT=	PostgreSQL database client programs
 
 .include "../../databases/postgresql14/Makefile.common"
diff --git a/databases/postgresql14-docs/PLIST b/databases/postgresql14-docs/PLIST
index fa57fae89c2..1e2549ea22d 100644
--- a/databases/postgresql14-docs/PLIST
+++ b/databases/postgresql14-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2022/08/15 20:59:40 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:26 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -991,6 +991,7 @@ share/doc/postgresql/html/release-14-2.html
 share/doc/postgresql/html/release-14-3.html
 share/doc/postgresql/html/release-14-4.html
 share/doc/postgresql/html/release-14-5.html
+share/doc/postgresql/html/release-14-6.html
 share/doc/postgresql/html/release-14.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
@@ -1301,6 +1302,7 @@ share/doc/postgresql/html/sslinfo.html
 share/doc/postgresql/html/sspi-auth.html
 share/doc/postgresql/html/storage-file-layout.html
 share/doc/postgresql/html/storage-fsm.html
+share/doc/postgresql/html/storage-hot.html
 share/doc/postgresql/html/storage-init.html
 share/doc/postgresql/html/storage-page-layout.html
 share/doc/postgresql/html/storage-toast.html
diff --git a/databases/postgresql14-server/PLIST b/databases/postgresql14-server/PLIST
index c13aa3b9c47..7a5ccdff938 100644
--- a/databases/postgresql14-server/PLIST
+++ b/databases/postgresql14-server/PLIST
@@ -1,6 +1,4 @@
-${PLIST.llvm}${PLIST.gssapi}lib/postgresql/bitcode/postgres/libpq/be-gssapi-common.bc
-${PLIST.llvm}${PLIST.gssapi}lib/postgresql/bitcode/postgres/libpq/be-secure-gssapi.bc
-@comment $NetBSD: PLIST,v 1.4 2022/08/15 20:59:40 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2022/11/13 09:34:27 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -310,7 +308,9 @@ ${PLIST.llvm}lib/postgresql/bitcode/postgres/lib/rbtree.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/auth-scram.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/auth.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/be-fsstubs.bc
+${PLIST.llvm}${PLIST.gssapi}lib/postgresql/bitcode/postgres/libpq/be-gssapi-common.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/be-secure-common.bc
+${PLIST.llvm}${PLIST.gssapi}lib/postgresql/bitcode/postgres/libpq/be-secure-gssapi.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/be-secure-openssl.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/be-secure.bc
 ${PLIST.llvm}lib/postgresql/bitcode/postgres/libpq/crypt.bc
@@ -1216,6 +1216,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql14/Makefile.common b/databases/postgresql14/Makefile.common
index c397abe7fa7..affa639abfa 100644
--- a/databases/postgresql14/Makefile.common
+++ b/databases/postgresql14/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.8 2022/10/16 14:42:50 gdt Exp $
+# $NetBSD: Makefile.common,v 1.9 2022/11/13 09:34:26 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.5
+DISTNAME=	postgresql-14.6
 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 47241b213b6..b58edbe7c16 100644
--- a/databases/postgresql14/distinfo
+++ b/databases/postgresql14/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.8 2022/08/15 20:59:39 adam Exp $
+$NetBSD: distinfo,v 1.9 2022/11/13 09:34:26 adam Exp $
 
-BLAKE2s (postgresql-14.5.tar.bz2) = 047d0dda525a04a62f6ed74e00ac5efe694cb17630684de00dd6c4134f131175
-SHA512 (postgresql-14.5.tar.bz2) = 3051c5ab729f6a55952c6108098b022517398b1de64f7fefbdd6c806c7e2eb0637d00f3c98a6203c5bee654656528c4ff3530db5a69470e7888864c77900178a
-Size (postgresql-14.5.tar.bz2) = 22132996 bytes
+BLAKE2s (postgresql-14.6.tar.bz2) = 4e543cb810a85d2f522c22b296ae98c958363bf66e881f13d9883a5263302878
+SHA512 (postgresql-14.6.tar.bz2) = 133083eb5709ace65dd81d326a960654dd6cfb35b3e85a35f71763c59dad0052a561c2aa1d1f52652b4bf81ed71edd232f170d483989d65ca354e653331faf2e
+Size (postgresql-14.6.tar.bz2) = 22177474 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
diff --git a/databases/postgresql15-client/PLIST b/databases/postgresql15-client/PLIST
index 40bd138fab5..aba5f2328c2 100644
--- a/databases/postgresql15-client/PLIST
+++ b/databases/postgresql15-client/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2022/10/19 13:16:45 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2022/11/13 09:34:27 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -1010,9 +1010,25 @@ ${PLIST.nls}share/locale/fr/LC_MESSAGES/psql-15.mo
 ${PLIST.nls}share/locale/he/LC_MESSAGES/pg_config-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/ecpg-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/ecpglib6-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/initdb-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/libpq5-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_amcheck-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_archivecleanup-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_basebackup-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_checksums-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/pg_config-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/pg_controldata-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/pg_ctl-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_dump-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_resetwal-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_rewind-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_test_fsync-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_test_timing-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_upgrade-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_verifybackup-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pg_waldump-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/pgscripts-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/psql-15.mo
 ${PLIST.nls}share/locale/ja/LC_MESSAGES/ecpg-15.mo
 ${PLIST.nls}share/locale/ja/LC_MESSAGES/ecpglib6-15.mo
 ${PLIST.nls}share/locale/ja/LC_MESSAGES/initdb-15.mo
diff --git a/databases/postgresql15-docs/PLIST b/databases/postgresql15-docs/PLIST
index b5d49071479..6e3e6b4876c 100644
--- a/databases/postgresql15-docs/PLIST
+++ b/databases/postgresql15-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2022/10/19 13:16:45 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2022/11/13 09:34:27 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -999,6 +999,7 @@ share/doc/postgresql/html/regress-run.html
 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-15-1.html
 share/doc/postgresql/html/release-15.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff --git a/databases/postgresql15-server/PLIST b/databases/postgresql15-server/PLIST
index c471a80f171..5b24b97de4d 100644
--- a/databases/postgresql15-server/PLIST
+++ b/databases/postgresql15-server/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2022/10/19 13:16:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2022/11/13 09:34:27 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -737,6 +737,7 @@ ${PLIST.nls}share/locale/es/LC_MESSAGES/postgres-15.mo
 ${PLIST.nls}share/locale/fr/LC_MESSAGES/plpgsql-15.mo
 ${PLIST.nls}share/locale/fr/LC_MESSAGES/postgres-15.mo
 ${PLIST.nls}share/locale/it/LC_MESSAGES/plpgsql-15.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/postgres-15.mo
 ${PLIST.nls}share/locale/ja/LC_MESSAGES/plpgsql-15.mo
 ${PLIST.nls}share/locale/ja/LC_MESSAGES/postgres-15.mo
 ${PLIST.nls}share/locale/ka/LC_MESSAGES/plpgsql-15.mo
@@ -1216,6 +1217,7 @@ share/postgresql/timezone/Europe/Jersey
 share/postgresql/timezone/Europe/Kaliningrad
 share/postgresql/timezone/Europe/Kiev
 share/postgresql/timezone/Europe/Kirov
+share/postgresql/timezone/Europe/Kyiv
 share/postgresql/timezone/Europe/Lisbon
 share/postgresql/timezone/Europe/Ljubljana
 share/postgresql/timezone/Europe/London
diff --git a/databases/postgresql15/Makefile.common b/databases/postgresql15/Makefile.common
index f8330135f2d..6a566c0eae5 100644
--- a/databases/postgresql15/Makefile.common
+++ b/databases/postgresql15/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.2 2022/11/01 10:20:55 jperkin Exp $
+# $NetBSD: Makefile.common,v 1.3 2022/11/13 09:34:27 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/postgresql15-pltcl/Makefile
 # used by databases/postgresql15-server/Makefile
 
-DISTNAME=	postgresql-15.0
+DISTNAME=	postgresql-15.1
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql15/distinfo b/databases/postgresql15/distinfo
index d0e425586a1..eeca4b2f73a 100644
--- a/databases/postgresql15/distinfo
+++ b/databases/postgresql15/distinfo
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.1 2022/10/19 13:16:45 adam Exp $
+$NetBSD: distinfo,v 1.2 2022/11/13 09:34:27 adam Exp $
 
-BLAKE2s (postgresql-15.0.tar.bz2) = df7ad3bb4103bb2722b5acb57669d7e40dddaf7e7acad8eeb1bb8de819ccd1a1
-SHA512 (postgresql-15.0.tar.bz2) = 537d223be619d8b192756791cb614638f7188532f981e233bbfa8c0245adf5afe94ba5160d771af77f7d4ead41bcf346cbb2197e1358a6411ead06b19e29f120
-Size (postgresql-15.0.tar.bz2) = 22403741 bytes
+BLAKE2s (postgresql-15.1.tar.bz2) = f9a7da05d228f613866220913703a4404e07150e5c317dab2774666c406f42cb
+SHA512 (postgresql-15.1.tar.bz2) = 803900363106d2e343305e6d1546016b6a6a37bbd49d7a84a9a6467c1dc3fc4eb52698411af9c2178590c2f7680967466b1a211a76955dcec5445d0b8b254202
+Size (postgresql-15.1.tar.bz2) = 22666134 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9