CVS commit: pkgsrc/databases

["Adam Ciarcinski" <adam%netbsd.org@localhost>]

Module Name:    pkgsrc
Committed By:   adam
Date:           Mon Nov 25 20:13:26 UTC 2024

Modified Files:
        pkgsrc/databases/postgresql13: Makefile.common distinfo
        pkgsrc/databases/postgresql13-docs: PLIST
        pkgsrc/databases/postgresql13-plperl: Makefile
        pkgsrc/databases/postgresql14: Makefile.common distinfo
        pkgsrc/databases/postgresql14-docs: PLIST
        pkgsrc/databases/postgresql14-plperl: Makefile
        pkgsrc/databases/postgresql15: Makefile.common distinfo
        pkgsrc/databases/postgresql15-docs: PLIST
        pkgsrc/databases/postgresql15-plperl: Makefile
        pkgsrc/databases/postgresql16: Makefile.common distinfo
        pkgsrc/databases/postgresql16-docs: PLIST
        pkgsrc/databases/postgresql16-plperl: Makefile
        pkgsrc/databases/postgresql17: Makefile.common distinfo
        pkgsrc/databases/postgresql17-docs: PLIST
        pkgsrc/databases/postgresql17-plperl: Makefile

Log Message:
postgresql1*: updated to 17.2, 16.6, 15.10, 14.15, 13.18, 12.22

PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22

The issues listed below affect PostgreSQL 17. Some of these issues may also affect other supported versions of PostgreSQL.

Restore functionality of ALTER ROLE .. SET ROLE and ALTER DATABASE .. SET ROLE. The fix for CVE-2024-10978 accidentally caused settings for role to not be applied if they came from non-interactive 
sources, including previous ALTER {ROLE|DATABASE} commands and the PGOPTIONS environment variable.
Restore compatibility for the timescaledb and other PostgreSQL extensions built using PostgreSQL prior to the 2024-11-14 release (17.0, 16.4, 15.8, 14.13, 13.16, 12.20, and earlier). This fix 
restores struct ResultRelInfo to its previous size, so that affected extensions don't need to be rebuilt.
Fix cases where a logical replication slot's restart_lsn could go backwards.
Avoid deleting still-needed WAL files during pg_rewind.
Fix race conditions associated with dropping shared statistics entries, which could lead to loss of statistics data.
Fix crash with ALTER TABLE when checking to see if an index's opclass options have changed if the table has an index with a non-default operator class.


To generate a diff of this commit:
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/postgresql13/Makefile.common
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/postgresql13/distinfo
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql13-docs/PLIST
cvs rdiff -u -r1.32 -r1.33 pkgsrc/databases/postgresql13-plperl/Makefile
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql14/Makefile.common \
    pkgsrc/databases/postgresql14/distinfo
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql14-docs/PLIST
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/postgresql14-plperl/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql15/Makefile.common
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql15/distinfo
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql15-docs/PLIST
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql15-plperl/Makefile
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/postgresql16/Makefile.common
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql16/distinfo
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql16-docs/PLIST
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql16-plperl/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17/Makefile.common \
    pkgsrc/databases/postgresql17/distinfo
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-docs/PLIST
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql17-plperl/Makefile

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/postgresql13/Makefile.common
diff -u pkgsrc/databases/postgresql13/Makefile.common:1.25 pkgsrc/databases/postgresql13/Makefile.common:1.26
--- pkgsrc/databases/postgresql13/Makefile.common:1.25  Sat Nov 16 10:13:47 2024
+++ pkgsrc/databases/postgresql13/Makefile.common       Mon Nov 25 20:13:24 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.25 2024/11/16 10:13:47 adam Exp $
+# $NetBSD: Makefile.common,v 1.26 2024/11/25 20:13: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/postgresql13-pltcl/Makefile
 # used by databases/postgresql13-server/Makefile
 
-DISTNAME=      postgresql-13.17
+DISTNAME=      postgresql-13.18
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql13/distinfo
diff -u pkgsrc/databases/postgresql13/distinfo:1.24 pkgsrc/databases/postgresql13/distinfo:1.25
--- pkgsrc/databases/postgresql13/distinfo:1.24 Sat Nov 16 10:13:47 2024
+++ pkgsrc/databases/postgresql13/distinfo      Mon Nov 25 20:13:24 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.24 2024/11/16 10:13:47 adam Exp $
+$NetBSD: distinfo,v 1.25 2024/11/25 20:13:24 adam Exp $
 
-BLAKE2s (postgresql-13.17.tar.bz2) = d57c2cd922c9096c27b7cda66291788fd2f6e5cf0532e677211d573507583623
-SHA512 (postgresql-13.17.tar.bz2) = 7a9ad8a32b4b156b510d98f6f89dcc4e8e6091281523ee4a4f0ca2cdaf9aba9b3ebffca3572a1ed45d551a4f552b874de389b246a17174c04a3abc5fd1bb2b7c
-Size (postgresql-13.17.tar.bz2) = 21681613 bytes
+BLAKE2s (postgresql-13.18.tar.bz2) = f065bc80be80a8368c55df5520a4f2b7d1cab81ce1ec30d9a76b326f59460ca2
+SHA512 (postgresql-13.18.tar.bz2) = 2694ff9402683c90ccfbb53a465f6b6a09702b9b5b44e2db84a3a41175427d889d1b823897fd361b04a53dd3596289822e36a77215cb45dd972d79850fbdb97b
+Size (postgresql-13.18.tar.bz2) = 21687645 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql13-docs/PLIST
diff -u pkgsrc/databases/postgresql13-docs/PLIST:1.18 pkgsrc/databases/postgresql13-docs/PLIST:1.19
--- pkgsrc/databases/postgresql13-docs/PLIST:1.18       Sat Nov 16 10:13:48 2024
+++ pkgsrc/databases/postgresql13-docs/PLIST    Mon Nov 25 20:13:24 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2024/11/16 10:13:48 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2024/11/25 20:13:24 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -979,6 +979,7 @@ share/doc/postgresql/html/release-13-14.
 share/doc/postgresql/html/release-13-15.html
 share/doc/postgresql/html/release-13-16.html
 share/doc/postgresql/html/release-13-17.html
+share/doc/postgresql/html/release-13-18.html
 share/doc/postgresql/html/release-13-2.html
 share/doc/postgresql/html/release-13-3.html
 share/doc/postgresql/html/release-13-4.html

Index: pkgsrc/databases/postgresql13-plperl/Makefile
diff -u pkgsrc/databases/postgresql13-plperl/Makefile:1.32 pkgsrc/databases/postgresql13-plperl/Makefile:1.33
--- pkgsrc/databases/postgresql13-plperl/Makefile:1.32  Sat Nov 16 12:03:34 2024
+++ pkgsrc/databases/postgresql13-plperl/Makefile       Mon Nov 25 20:13:24 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.32 2024/11/16 12:03:34 wiz Exp $
+# $NetBSD: Makefile,v 1.33 2024/11/25 20:13:24 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

Index: pkgsrc/databases/postgresql14/Makefile.common
diff -u pkgsrc/databases/postgresql14/Makefile.common:1.17 pkgsrc/databases/postgresql14/Makefile.common:1.18
--- pkgsrc/databases/postgresql14/Makefile.common:1.17  Sat Nov 16 10:13:48 2024
+++ pkgsrc/databases/postgresql14/Makefile.common       Mon Nov 25 20:13:24 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2024/11/16 10:13:48 adam Exp $
+# $NetBSD: Makefile.common,v 1.18 2024/11/25 20:13: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.14
+DISTNAME=      postgresql-14.15
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
Index: pkgsrc/databases/postgresql14/distinfo
diff -u pkgsrc/databases/postgresql14/distinfo:1.17 pkgsrc/databases/postgresql14/distinfo:1.18
--- pkgsrc/databases/postgresql14/distinfo:1.17 Sat Nov 16 10:13:48 2024
+++ pkgsrc/databases/postgresql14/distinfo      Mon Nov 25 20:13:24 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.17 2024/11/16 10:13:48 adam Exp $
+$NetBSD: distinfo,v 1.18 2024/11/25 20:13:24 adam Exp $
 
-BLAKE2s (postgresql-14.14.tar.bz2) = 82c134e972686a80270d5fad121fce67f081c74cb6f5c820f589c5f78074d685
-SHA512 (postgresql-14.14.tar.bz2) = 993f369fb405d6cf5b5ebc57a970cdc7a6fa08a9324924a5c5e59b3518f13c73362659bfe579e6d0264d1edac540245d876bcc41a7d4bd31559ce202cfa1cdc3
-Size (postgresql-14.14.tar.bz2) = 22451431 bytes
+BLAKE2s (postgresql-14.15.tar.bz2) = b4f7e7f51d08d7e2a2e393184aba4adaa45cb9d460cd16ded00b66c8acbed524
+SHA512 (postgresql-14.15.tar.bz2) = 227f9551167ee62e5185d6f6777e100ecc09f497b9ee1b5a8e659de8d4c237b0f9a97005706bbf64c3e839271e2630f6a417ba98dfce47bcb4c27e8641a7c6ef
+Size (postgresql-14.15.tar.bz2) = 22458243 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql14-docs/PLIST
diff -u pkgsrc/databases/postgresql14-docs/PLIST:1.15 pkgsrc/databases/postgresql14-docs/PLIST:1.16
--- pkgsrc/databases/postgresql14-docs/PLIST:1.15       Sat Nov 16 10:13:49 2024
+++ pkgsrc/databases/postgresql14-docs/PLIST    Mon Nov 25 20:13:25 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2024/11/16 10:13:49 adam Exp $
+@comment $NetBSD: PLIST,v 1.16 2024/11/25 20:13:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -992,6 +992,7 @@ share/doc/postgresql/html/release-14-11.
 share/doc/postgresql/html/release-14-12.html
 share/doc/postgresql/html/release-14-13.html
 share/doc/postgresql/html/release-14-14.html
+share/doc/postgresql/html/release-14-15.html
 share/doc/postgresql/html/release-14-2.html
 share/doc/postgresql/html/release-14-3.html
 share/doc/postgresql/html/release-14-4.html

Index: pkgsrc/databases/postgresql14-plperl/Makefile
diff -u pkgsrc/databases/postgresql14-plperl/Makefile:1.25 pkgsrc/databases/postgresql14-plperl/Makefile:1.26
--- pkgsrc/databases/postgresql14-plperl/Makefile:1.25  Sat Nov 16 12:03:34 2024
+++ pkgsrc/databases/postgresql14-plperl/Makefile       Mon Nov 25 20:13:25 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2024/11/16 12:03:34 wiz Exp $
+# $NetBSD: Makefile,v 1.26 2024/11/25 20:13:25 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

Index: pkgsrc/databases/postgresql15/Makefile.common
diff -u pkgsrc/databases/postgresql15/Makefile.common:1.11 pkgsrc/databases/postgresql15/Makefile.common:1.12
--- pkgsrc/databases/postgresql15/Makefile.common:1.11  Sat Nov 16 10:13:49 2024
+++ pkgsrc/databases/postgresql15/Makefile.common       Mon Nov 25 20:13:25 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.11 2024/11/16 10:13:49 adam Exp $
+# $NetBSD: Makefile.common,v 1.12 2024/11/25 20:13: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/postgresql15-pltcl/Makefile
 # used by databases/postgresql15-server/Makefile
 
-DISTNAME=      postgresql-15.9
+DISTNAME=      postgresql-15.10
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql15/distinfo
diff -u pkgsrc/databases/postgresql15/distinfo:1.10 pkgsrc/databases/postgresql15/distinfo:1.11
--- pkgsrc/databases/postgresql15/distinfo:1.10 Sat Nov 16 10:13:49 2024
+++ pkgsrc/databases/postgresql15/distinfo      Mon Nov 25 20:13:25 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.10 2024/11/16 10:13:49 adam Exp $
+$NetBSD: distinfo,v 1.11 2024/11/25 20:13:25 adam Exp $
 
-BLAKE2s (postgresql-15.9.tar.bz2) = bc9beed0c2578a8355e85f44998681d1d7789ec79b8a692dd3f27a37399a1c11
-SHA512 (postgresql-15.9.tar.bz2) = eb8e85e136e5e3f2e9da1fffce06ffda3fdd2001d46153e1a7e02983bd1fcb29a92bec3cbf1fec48a4505b68a9360d24acf45e96a3ce94272833ba45096e8a1b
-Size (postgresql-15.9.tar.bz2) = 23135232 bytes
+BLAKE2s (postgresql-15.10.tar.bz2) = 7b3449b4a1fc8a065c952985b165fab94bffed5b3dcbc9c0dadb73444770d290
+SHA512 (postgresql-15.10.tar.bz2) = 73513f5f688f470aadd95dddef3b39b5d140d539bdf3171e053a89b3eed4c769f7951280468e9f11102f2de9fe8742bb38676c8d5d43418544b9482d83957ef4
+Size (postgresql-15.10.tar.bz2) = 23138615 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql15-docs/PLIST
diff -u pkgsrc/databases/postgresql15-docs/PLIST:1.10 pkgsrc/databases/postgresql15-docs/PLIST:1.11
--- pkgsrc/databases/postgresql15-docs/PLIST:1.10       Sat Nov 16 10:13:50 2024
+++ pkgsrc/databases/postgresql15-docs/PLIST    Mon Nov 25 20:13:25 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2024/11/16 10:13:50 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2024/11/25 20:13:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1000,6 +1000,7 @@ share/doc/postgresql/html/regress-tap.ht
 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-10.html
 share/doc/postgresql/html/release-15-2.html
 share/doc/postgresql/html/release-15-3.html
 share/doc/postgresql/html/release-15-4.html

Index: pkgsrc/databases/postgresql15-plperl/Makefile
diff -u pkgsrc/databases/postgresql15-plperl/Makefile:1.17 pkgsrc/databases/postgresql15-plperl/Makefile:1.18
--- pkgsrc/databases/postgresql15-plperl/Makefile:1.17  Sat Nov 16 12:03:34 2024
+++ pkgsrc/databases/postgresql15-plperl/Makefile       Mon Nov 25 20:13:25 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2024/11/16 12:03:34 wiz Exp $
+# $NetBSD: Makefile,v 1.18 2024/11/25 20:13:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql15-server>=${PKGVERSION_NOREV}:../../databases/postgresql15-server

Index: pkgsrc/databases/postgresql16/Makefile.common
diff -u pkgsrc/databases/postgresql16/Makefile.common:1.8 pkgsrc/databases/postgresql16/Makefile.common:1.9
--- pkgsrc/databases/postgresql16/Makefile.common:1.8   Sat Nov 16 10:13:50 2024
+++ pkgsrc/databases/postgresql16/Makefile.common       Mon Nov 25 20:13:25 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.8 2024/11/16 10:13:50 adam Exp $
+# $NetBSD: Makefile.common,v 1.9 2024/11/25 20:13: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/postgresql16-pltcl/Makefile
 # used by databases/postgresql16-server/Makefile
 
-DISTNAME=      postgresql-16.5
+DISTNAME=      postgresql-16.6
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql16/distinfo
diff -u pkgsrc/databases/postgresql16/distinfo:1.7 pkgsrc/databases/postgresql16/distinfo:1.8
--- pkgsrc/databases/postgresql16/distinfo:1.7  Sat Nov 16 10:13:50 2024
+++ pkgsrc/databases/postgresql16/distinfo      Mon Nov 25 20:13:25 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.7 2024/11/16 10:13:50 adam Exp $
+$NetBSD: distinfo,v 1.8 2024/11/25 20:13:25 adam Exp $
 
-BLAKE2s (postgresql-16.5.tar.bz2) = e16b5bb96ea3992f602490282fc5e7c52210ba0594ae508ebbf8673e270a869a
-SHA512 (postgresql-16.5.tar.bz2) = aec47744284c5a593f4223de26187dd4b00e27a8a8948c6b7d24ca522eb6b4d0098ec956e80f37d5a3a841d18e45e4a21e7323e33af91eff24e1b2c59577bef1
-Size (postgresql-16.5.tar.bz2) = 24854528 bytes
+BLAKE2s (postgresql-16.6.tar.bz2) = 271bfe96f991bd75d7fc38b9a4ee4d1ca89a49a48b505153604f05f0691626da
+SHA512 (postgresql-16.6.tar.bz2) = ffd6d39fb7aed87241237d68af4934fba1b4ac1be4d3c2833e308e50c21a693796fe54b73e0905365d7557009c40049a23b966aa86765b969797434a0d4bd5f8
+Size (postgresql-16.6.tar.bz2) = 24856956 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = 3392111516ca65ad7980ee39246c4210ec020c34

Index: pkgsrc/databases/postgresql16-docs/PLIST
diff -u pkgsrc/databases/postgresql16-docs/PLIST:1.6 pkgsrc/databases/postgresql16-docs/PLIST:1.7
--- pkgsrc/databases/postgresql16-docs/PLIST:1.6        Sat Nov 16 10:13:51 2024
+++ pkgsrc/databases/postgresql16-docs/PLIST    Mon Nov 25 20:13:25 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2024/11/16 10:13:51 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2024/11/25 20:13:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1003,6 +1003,7 @@ share/doc/postgresql/html/release-16-2.h
 share/doc/postgresql/html/release-16-3.html
 share/doc/postgresql/html/release-16-4.html
 share/doc/postgresql/html/release-16-5.html
+share/doc/postgresql/html/release-16-6.html
 share/doc/postgresql/html/release-16.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql16-plperl/Makefile
diff -u pkgsrc/databases/postgresql16-plperl/Makefile:1.11 pkgsrc/databases/postgresql16-plperl/Makefile:1.12
--- pkgsrc/databases/postgresql16-plperl/Makefile:1.11  Sat Nov 16 12:03:34 2024
+++ pkgsrc/databases/postgresql16-plperl/Makefile       Mon Nov 25 20:13:25 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2024/11/16 12:03:34 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2024/11/25 20:13:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql16-server>=${PKGVERSION_NOREV}:../../databases/postgresql16-server

Index: pkgsrc/databases/postgresql17/Makefile.common
diff -u pkgsrc/databases/postgresql17/Makefile.common:1.2 pkgsrc/databases/postgresql17/Makefile.common:1.3
--- pkgsrc/databases/postgresql17/Makefile.common:1.2   Sat Nov 16 10:13:51 2024
+++ pkgsrc/databases/postgresql17/Makefile.common       Mon Nov 25 20:13:26 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.2 2024/11/16 10:13:51 adam Exp $
+# $NetBSD: Makefile.common,v 1.3 2024/11/25 20:13: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/postgresql17-pltcl/Makefile
 # used by databases/postgresql17-server/Makefile
 
-DISTNAME=      postgresql-17.1
+DISTNAME=      postgresql-17.2
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
Index: pkgsrc/databases/postgresql17/distinfo
diff -u pkgsrc/databases/postgresql17/distinfo:1.2 pkgsrc/databases/postgresql17/distinfo:1.3
--- pkgsrc/databases/postgresql17/distinfo:1.2  Sat Nov 16 10:13:51 2024
+++ pkgsrc/databases/postgresql17/distinfo      Mon Nov 25 20:13:26 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.2 2024/11/16 10:13:51 adam Exp $
+$NetBSD: distinfo,v 1.3 2024/11/25 20:13:26 adam Exp $
 
-BLAKE2s (postgresql-17.1.tar.bz2) = 8256d967a8ff198dc81b6d320b3597163874995d532e56b5ff13c18b8e86c37d
-SHA512 (postgresql-17.1.tar.bz2) = 41bd56ea5d2c3d41bd273894a056bd10244b33186746b63918f03671ba548551e02694f8215f09c6408c4dd6bb6ba0e87dec612560e8a267f5c5734b177e70a0
-Size (postgresql-17.1.tar.bz2) = 21410991 bytes
+BLAKE2s (postgresql-17.2.tar.bz2) = 1a69bf29221d64d1ace0c38a2a865358e26b93025fbdba1ef9d0a425be43b3de
+SHA512 (postgresql-17.2.tar.bz2) = 8e15e47c22d21e1cadc31249cf31af5abe34b8ab72930e58e5fe6124795ad237ca7b4fd3bf36b5f18589c4fc439dc2bab3045d9b4ba23d1846b4b2be6fd1cb69
+Size (postgresql-17.2.tar.bz2) = 21408880 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = beebdd7d46e37065c86d7edbfb982bac1fbc9147

Index: pkgsrc/databases/postgresql17-docs/PLIST
diff -u pkgsrc/databases/postgresql17-docs/PLIST:1.2 pkgsrc/databases/postgresql17-docs/PLIST:1.3
--- pkgsrc/databases/postgresql17-docs/PLIST:1.2        Sat Nov 16 10:13:52 2024
+++ pkgsrc/databases/postgresql17-docs/PLIST    Mon Nov 25 20:13:26 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2024/11/16 10:13:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2024/11/25 20:13:26 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -983,6 +983,7 @@ share/doc/postgresql/html/regress-tap.ht
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-17-1.html
+share/doc/postgresql/html/release-17-2.html
 share/doc/postgresql/html/release-17.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql17-plperl/Makefile
diff -u pkgsrc/databases/postgresql17-plperl/Makefile:1.4 pkgsrc/databases/postgresql17-plperl/Makefile:1.5
--- pkgsrc/databases/postgresql17-plperl/Makefile:1.4   Sat Nov 16 12:03:34 2024
+++ pkgsrc/databases/postgresql17-plperl/Makefile       Mon Nov 25 20:13:26 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.4 2024/11/16 12:03:34 wiz Exp $
+# $NetBSD: Makefile,v 1.5 2024/11/25 20:13:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql17-server>=${PKGVERSION_NOREV}:../../databases/postgresql17-server