pkgsrc-Changes archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

CVS commit: pkgsrc



Module Name:    pkgsrc
Committed By:   adam
Date:           Sat Nov 16 10:13:53 UTC 2024

Modified Files:
        pkgsrc/databases: Makefile
        pkgsrc/databases/postgresql13: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql13-client: Makefile PLIST
        pkgsrc/databases/postgresql13-contrib: Makefile
        pkgsrc/databases/postgresql13-docs: Makefile PLIST
        pkgsrc/databases/postgresql13-plperl: Makefile
        pkgsrc/databases/postgresql13-plpython: Makefile
        pkgsrc/databases/postgresql13-pltcl: Makefile
        pkgsrc/databases/postgresql13-server: Makefile
        pkgsrc/databases/postgresql14: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql14-client: Makefile PLIST
        pkgsrc/databases/postgresql14-contrib: Makefile
        pkgsrc/databases/postgresql14-docs: Makefile PLIST
        pkgsrc/databases/postgresql14-plperl: Makefile
        pkgsrc/databases/postgresql14-plpython: Makefile
        pkgsrc/databases/postgresql14-pltcl: Makefile
        pkgsrc/databases/postgresql14-server: Makefile
        pkgsrc/databases/postgresql15: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql15-client: Makefile PLIST
        pkgsrc/databases/postgresql15-contrib: Makefile
        pkgsrc/databases/postgresql15-docs: Makefile PLIST
        pkgsrc/databases/postgresql15-plperl: Makefile
        pkgsrc/databases/postgresql15-plpython: Makefile
        pkgsrc/databases/postgresql15-pltcl: Makefile
        pkgsrc/databases/postgresql15-server: Makefile
        pkgsrc/databases/postgresql16: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql16-client: Makefile PLIST
        pkgsrc/databases/postgresql16-contrib: Makefile
        pkgsrc/databases/postgresql16-docs: Makefile PLIST
        pkgsrc/databases/postgresql16-plperl: Makefile
        pkgsrc/databases/postgresql16-plpython: Makefile
        pkgsrc/databases/postgresql16-pltcl: Makefile
        pkgsrc/databases/postgresql16-server: Makefile
        pkgsrc/databases/postgresql16/patches: patch-src_pl_plperl_GNUmakefile
        pkgsrc/databases/postgresql17: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql17-client: Makefile PLIST
        pkgsrc/databases/postgresql17-contrib: Makefile
        pkgsrc/databases/postgresql17-docs: Makefile PLIST
        pkgsrc/databases/postgresql17-plperl: Makefile
        pkgsrc/databases/postgresql17-plpython: Makefile
        pkgsrc/databases/postgresql17-pltcl: Makefile
        pkgsrc/databases/postgresql17-server: Makefile
        pkgsrc/databases/postgresql17/patches: patch-src_pl_plperl_GNUmakefile
        pkgsrc/mk: pgsql.buildlink3.mk
Removed Files:
        pkgsrc/databases/postgresql12: DESCR Makefile Makefile.common PLIST
            distinfo options.mk
        pkgsrc/databases/postgresql12-client: DESCR Makefile PLIST
            buildlink3.mk
        pkgsrc/databases/postgresql12-contrib: DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-docs: DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-plperl: DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-plpython: DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-pltcl: DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-server: DEINSTALL DESCR Makefile PLIST
        pkgsrc/databases/postgresql12-server/files: pgsql.sh
        pkgsrc/databases/postgresql12-server/files/smf: manifest.xml
            postgresql.sh
        pkgsrc/databases/postgresql12/patches: patch-config_missing
            patch-config_perl.m4 patch-configure patch-contrib_dblink_dblink.c
            patch-contrib_uuid-ossp_Makefile patch-src_Makefile.global.in
            patch-src_Makefile.shlib patch-src_backend_Makefile
            patch-src_interfaces_libpq_Makefile
            patch-src_makefiles_Makefile.solaris
            patch-src_pl_plperl_GNUmakefile

Log Message:
postgresql: updated to 17.1, 16.5, 15.9, 14.14, 13.17

PostgreSQL 12 is now end-of-life.

Security Issues
* CVE-2024-10976: PostgreSQL row security below e.g. subqueries disregards user ID changes
* CVE-2024-10977: PostgreSQL libpq retains an error message from man-in-the-middle
* CVE-2024-10978: PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID
* CVE-2024-10979: PostgreSQL PL/Perl environment variable changes execute arbitrary code

Bug Fixes and Improvements

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

Fix when attaching or detaching table partitions with foreign key constraints. After upgrade, users impacted by this issue will need to perform manual steps to finish fixing it. Please see the 
"Upgrading" section and the release notes for more information.
Fix when using libc as the default collation provider when LC_CTYPE is C while LC_COLLATE is a different locale. This could lead to incorrect query results. If you have these settings in your 
database, please reindex any affected indexes after updating to this release. This issue impacted 17.0 only.
Several query planner fixes, including disallowing joining partitions (partitionwise join) if the collations of the partitions don't match.
Fix possible wrong answers or wrong varnullingrels planner errors for MERGE ... WHEN NOT MATCHED BY SOURCE actions.
Fix validation of the COPY FORCE_NOT_NULL and FORCE_NULL.
Fix server crash when a json_objectagg() call contains a volatile function.
Ensure there's a registered dependency between a partitioned table and a non-built-in access method specified in CREATE TABLE ... USING. This fix only prevents problems for partitioned tables created 
after this update.
Fix race condition in committing a serializable transaction.
Fix race condition in COMMIT PREPARED that could require manual file removal after a crash-and-recovery.
Fix for pg_cursors view to prevent errors by excluding cursors that aren't completely set up.
Reduce logical decoding memory consumption.
Fix to prevent stable functions from receiving stale row values when they're called from a CALL statement's argument list and the CALL is within a PL/pgSQL EXCEPTION block.
Fix for JIT crashes on ARM (aarch64) systems.
The psql \watch now treats values that are less than 1ms to be 0 (no wait between executions).
Fix failure to use credentials for a replication user in the password file (pgpass)
pg_combinebackup now throws an error if an incremental backup file is present in a directory that should contain a full backup.
Fix to avoid reindexing temporary tables and indexes in vacuumdb and parallel reindexdb


To generate a diff of this commit:
cvs rdiff -u -r1.721 -r1.722 pkgsrc/databases/Makefile
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12/DESCR \
    pkgsrc/databases/postgresql12/PLIST
cvs rdiff -u -r1.37 -r0 pkgsrc/databases/postgresql12/Makefile
cvs rdiff -u -r1.31 -r0 pkgsrc/databases/postgresql12/Makefile.common
cvs rdiff -u -r1.25 -r0 pkgsrc/databases/postgresql12/distinfo
cvs rdiff -u -r1.7 -r0 pkgsrc/databases/postgresql12/options.mk
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-client/DESCR
cvs rdiff -u -r1.40 -r0 pkgsrc/databases/postgresql12-client/Makefile
cvs rdiff -u -r1.8 -r0 pkgsrc/databases/postgresql12-client/PLIST
cvs rdiff -u -r1.7 -r0 pkgsrc/databases/postgresql12-client/buildlink3.mk
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-contrib/DESCR
cvs rdiff -u -r1.35 -r0 pkgsrc/databases/postgresql12-contrib/Makefile
cvs rdiff -u -r1.2 -r0 pkgsrc/databases/postgresql12-contrib/PLIST
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-docs/DESCR
cvs rdiff -u -r1.29 -r0 pkgsrc/databases/postgresql12-docs/Makefile
cvs rdiff -u -r1.21 -r0 pkgsrc/databases/postgresql12-docs/PLIST
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-plperl/DESCR
cvs rdiff -u -r1.35 -r0 pkgsrc/databases/postgresql12-plperl/Makefile
cvs rdiff -u -r1.4 -r0 pkgsrc/databases/postgresql12-plperl/PLIST
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-plpython/DESCR
cvs rdiff -u -r1.36 -r0 pkgsrc/databases/postgresql12-plpython/Makefile
cvs rdiff -u -r1.3 -r0 pkgsrc/databases/postgresql12-plpython/PLIST
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-pltcl/DESCR
cvs rdiff -u -r1.33 -r0 pkgsrc/databases/postgresql12-pltcl/Makefile
cvs rdiff -u -r1.2 -r0 pkgsrc/databases/postgresql12-pltcl/PLIST
cvs rdiff -u -r1.1 -r0 pkgsrc/databases/postgresql12-server/DEINSTALL \
    pkgsrc/databases/postgresql12-server/DESCR
cvs rdiff -u -r1.35 -r0 pkgsrc/databases/postgresql12-server/Makefile
cvs rdiff -u -r1.8 -r0 pkgsrc/databases/postgresql12-server/PLIST
cvs rdiff -u -r1.3 -r0 pkgsrc/databases/postgresql12-server/files/pgsql.sh
cvs rdiff -u -r1.1 -r0 \
    pkgsrc/databases/postgresql12-server/files/smf/manifest.xml \
    pkgsrc/databases/postgresql12-server/files/smf/postgresql.sh
cvs rdiff -u -r1.1 -r0 \
    pkgsrc/databases/postgresql12/patches/patch-config_missing \
    pkgsrc/databases/postgresql12/patches/patch-config_perl.m4 \
    pkgsrc/databases/postgresql12/patches/patch-configure \
    pkgsrc/databases/postgresql12/patches/patch-contrib_dblink_dblink.c \
    pkgsrc/databases/postgresql12/patches/patch-contrib_uuid-ossp_Makefile \
    pkgsrc/databases/postgresql12/patches/patch-src_Makefile.global.in \
    pkgsrc/databases/postgresql12/patches/patch-src_Makefile.shlib \
    pkgsrc/databases/postgresql12/patches/patch-src_interfaces_libpq_Makefile \
    pkgsrc/databases/postgresql12/patches/patch-src_makefiles_Makefile.solaris \
    pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_GNUmakefile
cvs rdiff -u -r1.2 -r0 \
    pkgsrc/databases/postgresql12/patches/patch-src_backend_Makefile
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql13/Makefile
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/postgresql13/Makefile.common
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql13/distinfo
cvs rdiff -u -r1.34 -r1.35 pkgsrc/databases/postgresql13-client/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql13-client/PLIST
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql13-contrib/Makefile
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/postgresql13-docs/Makefile
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql13-docs/PLIST
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/postgresql13-plperl/Makefile
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/postgresql13-plpython/Makefile
cvs rdiff -u -r1.27 -r1.28 pkgsrc/databases/postgresql13-pltcl/Makefile
cvs rdiff -u -r1.27 -r1.28 pkgsrc/databases/postgresql13-server/Makefile
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql14/Makefile
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql14/Makefile.common \
    pkgsrc/databases/postgresql14/distinfo
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/postgresql14-client/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql14-client/PLIST
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql14-contrib/Makefile
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql14-docs/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql14-docs/PLIST
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql14-plperl/Makefile
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql14-plpython/Makefile
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql14-pltcl/Makefile
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql14-server/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql15/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql15/Makefile.common
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql15/distinfo
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-client/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql15-client/PLIST
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-contrib/Makefile
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-docs/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql15-docs/PLIST
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql15-plperl/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql15-plpython/Makefile
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-pltcl/Makefile
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-server/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql16/Makefile.common
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql16/distinfo
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql16-client/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql16-client/PLIST
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-contrib/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-docs/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql16-docs/PLIST
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-plperl/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-plpython/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-pltcl/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql16-server/Makefile
cvs rdiff -u -r1.1 -r1.2 \
    pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17/Makefile
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql17/Makefile.common \
    pkgsrc/databases/postgresql17/distinfo
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-client/Makefile
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql17-client/PLIST
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-contrib/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-docs/Makefile
cvs rdiff -u -r1.1 -r1.2 pkgsrc/databases/postgresql17-docs/PLIST
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-plperl/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-plpython/Makefile
cvs rdiff -u -r1.2 -r1.3 pkgsrc/databases/postgresql17-pltcl/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql17-server/Makefile
cvs rdiff -u -r1.1 -r1.2 \
    pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile
cvs rdiff -u -r1.65 -r1.66 pkgsrc/mk/pgsql.buildlink3.mk

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

Modified files:

Index: pkgsrc/databases/Makefile
diff -u pkgsrc/databases/Makefile:1.721 pkgsrc/databases/Makefile:1.722
--- pkgsrc/databases/Makefile:1.721     Fri Nov  8 13:43:36 2024
+++ pkgsrc/databases/Makefile   Sat Nov 16 10:13:44 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.721 2024/11/08 13:43:36 adam Exp $
+# $NetBSD: Makefile,v 1.722 2024/11/16 10:13:44 adam Exp $
 
 COMMENT=       Databases
 
@@ -311,14 +311,6 @@ SUBDIR+=   postgresql-postgis2
 SUBDIR+=       postgresql-redislog
 SUBDIR+=       postgresql-timescaledb
 SUBDIR+=       postgresql-wal2json
-SUBDIR+=       postgresql12
-SUBDIR+=       postgresql12-client
-SUBDIR+=       postgresql12-contrib
-SUBDIR+=       postgresql12-docs
-SUBDIR+=       postgresql12-plperl
-SUBDIR+=       postgresql12-plpython
-SUBDIR+=       postgresql12-pltcl
-SUBDIR+=       postgresql12-server
 SUBDIR+=       postgresql13
 SUBDIR+=       postgresql13-client
 SUBDIR+=       postgresql13-contrib

Index: pkgsrc/databases/postgresql13/Makefile
diff -u pkgsrc/databases/postgresql13/Makefile:1.28 pkgsrc/databases/postgresql13/Makefile:1.29
--- pkgsrc/databases/postgresql13/Makefile:1.28 Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13/Makefile      Sat Nov 16 10:13:47 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.29 2024/11/16 10:13:47 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-/}
-PKGREVISION=   3
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql13-client>=${PKGVERSION_NOREV}:../../databases/postgresql13-client

Index: pkgsrc/databases/postgresql13/Makefile.common
diff -u pkgsrc/databases/postgresql13/Makefile.common:1.24 pkgsrc/databases/postgresql13/Makefile.common:1.25
--- pkgsrc/databases/postgresql13/Makefile.common:1.24  Fri Aug  9 21:55:46 2024
+++ pkgsrc/databases/postgresql13/Makefile.common       Sat Nov 16 10:13:47 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.24 2024/08/09 21:55:46 adam Exp $
+# $NetBSD: Makefile.common,v 1.25 2024/11/16 10:13:47 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.16
+DISTNAME=      postgresql-13.17
 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.23 pkgsrc/databases/postgresql13/distinfo:1.24
--- pkgsrc/databases/postgresql13/distinfo:1.23 Fri Aug  9 21:55:46 2024
+++ pkgsrc/databases/postgresql13/distinfo      Sat Nov 16 10:13:47 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.23 2024/08/09 21:55:46 adam Exp $
+$NetBSD: distinfo,v 1.24 2024/11/16 10:13:47 adam Exp $
 
-BLAKE2s (postgresql-13.16.tar.bz2) = 65e47e1d9d372130b67bdb5ca685baf1506b62d1ddf1339ad66b57d03a59ee6a
-SHA512 (postgresql-13.16.tar.bz2) = e874c77e2d1d27d724f45c576c9d815da55f36712d67e3ec0a1f14ce4ac535fb39b6f23cdcd818cff05788e2c1e12f79572d90f8c145d7478aa35157b0b40679
-Size (postgresql-13.16.tar.bz2) = 21639411 bytes
+BLAKE2s (postgresql-13.17.tar.bz2) = d57c2cd922c9096c27b7cda66291788fd2f6e5cf0532e677211d573507583623
+SHA512 (postgresql-13.17.tar.bz2) = 7a9ad8a32b4b156b510d98f6f89dcc4e8e6091281523ee4a4f0ca2cdaf9aba9b3ebffca3572a1ed45d551a4f552b874de389b246a17174c04a3abc5fd1bb2b7c
+Size (postgresql-13.17.tar.bz2) = 21681613 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql13-client/Makefile
diff -u pkgsrc/databases/postgresql13-client/Makefile:1.34 pkgsrc/databases/postgresql13-client/Makefile:1.35
--- pkgsrc/databases/postgresql13-client/Makefile:1.34  Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13-client/Makefile       Sat Nov 16 10:13:47 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.34 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.35 2024/11/16 10:13:47 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-client-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-client/PLIST
diff -u pkgsrc/databases/postgresql13-client/PLIST:1.5 pkgsrc/databases/postgresql13-client/PLIST:1.6
--- pkgsrc/databases/postgresql13-client/PLIST:1.5      Tue Nov 16 10:14:38 2021
+++ pkgsrc/databases/postgresql13-client/PLIST  Sat Nov 16 10:13:47 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2021/11/16 10:14:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2024/11/16 10:13:47 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -423,8 +423,10 @@ include/postgresql/server/foreign/foreig
 include/postgresql/server/funcapi.h
 include/postgresql/server/getaddrinfo.h
 include/postgresql/server/getopt_long.h
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/binaryheap.h
 include/postgresql/server/lib/bipartite_match.h
@@ -580,6 +582,7 @@ include/postgresql/server/port/win32_msv
 include/postgresql/server/port/win32_msvc/unistd.h
 include/postgresql/server/port/win32_msvc/utime.h
 include/postgresql/server/port/win32_port.h
+include/postgresql/server/port/win32ntdll.h
 include/postgresql/server/portability/instr_time.h
 include/postgresql/server/portability/mem.h
 include/postgresql/server/postgres.h

Index: pkgsrc/databases/postgresql13-contrib/Makefile
diff -u pkgsrc/databases/postgresql13-contrib/Makefile:1.28 pkgsrc/databases/postgresql13-contrib/Makefile:1.29
--- pkgsrc/databases/postgresql13-contrib/Makefile:1.28 Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13-contrib/Makefile      Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.29 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-contrib-/}
-PKGREVISION=   3
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-docs/Makefile
diff -u pkgsrc/databases/postgresql13-docs/Makefile:1.25 pkgsrc/databases/postgresql13-docs/Makefile:1.26
--- pkgsrc/databases/postgresql13-docs/Makefile:1.25    Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13-docs/Makefile Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.26 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-docs-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-docs/PLIST
diff -u pkgsrc/databases/postgresql13-docs/PLIST:1.17 pkgsrc/databases/postgresql13-docs/PLIST:1.18
--- pkgsrc/databases/postgresql13-docs/PLIST:1.17       Fri Aug  9 21:55:46 2024
+++ pkgsrc/databases/postgresql13-docs/PLIST    Sat Nov 16 10:13:48 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2024/08/09 21:55:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.18 2024/11/16 10:13:48 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -978,6 +978,7 @@ share/doc/postgresql/html/release-13-13.
 share/doc/postgresql/html/release-13-14.html
 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-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.30 pkgsrc/databases/postgresql13-plperl/Makefile:1.31
--- pkgsrc/databases/postgresql13-plperl/Makefile:1.30  Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13-plperl/Makefile       Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.30 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.31 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plperl-/}
-PKGREVISION=   3
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-plpython/Makefile
diff -u pkgsrc/databases/postgresql13-plpython/Makefile:1.30 pkgsrc/databases/postgresql13-plpython/Makefile:1.31
--- pkgsrc/databases/postgresql13-plpython/Makefile:1.30        Thu Nov 14 22:19:06 2024
+++ pkgsrc/databases/postgresql13-plpython/Makefile     Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.30 2024/11/14 22:19:06 wiz Exp $
+# $NetBSD: Makefile,v 1.31 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plpython-/}
-PKGREVISION=   3
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-pltcl/Makefile
diff -u pkgsrc/databases/postgresql13-pltcl/Makefile:1.27 pkgsrc/databases/postgresql13-pltcl/Makefile:1.28
--- pkgsrc/databases/postgresql13-pltcl/Makefile:1.27   Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql13-pltcl/Makefile        Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.28 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-pltcl-/}
-PKGREVISION=   3
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-server/Makefile
diff -u pkgsrc/databases/postgresql13-server/Makefile:1.27 pkgsrc/databases/postgresql13-server/Makefile:1.28
--- pkgsrc/databases/postgresql13-server/Makefile:1.27  Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql13-server/Makefile       Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.28 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-server-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql14/Makefile
diff -u pkgsrc/databases/postgresql14/Makefile:1.23 pkgsrc/databases/postgresql14/Makefile:1.24
--- pkgsrc/databases/postgresql14/Makefile:1.23 Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14/Makefile      Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-/}
-PKGREVISION=   3
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql14-client>=${PKGVERSION_NOREV}:../../databases/postgresql14-client

Index: pkgsrc/databases/postgresql14/Makefile.common
diff -u pkgsrc/databases/postgresql14/Makefile.common:1.16 pkgsrc/databases/postgresql14/Makefile.common:1.17
--- pkgsrc/databases/postgresql14/Makefile.common:1.16  Fri Aug  9 21:55:47 2024
+++ pkgsrc/databases/postgresql14/Makefile.common       Sat Nov 16 10:13:48 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2024/08/09 21:55:47 adam Exp $
+# $NetBSD: Makefile.common,v 1.17 2024/11/16 10:13:48 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.13
+DISTNAME=      postgresql-14.14
 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.16 pkgsrc/databases/postgresql14/distinfo:1.17
--- pkgsrc/databases/postgresql14/distinfo:1.16 Fri Aug  9 21:55:47 2024
+++ pkgsrc/databases/postgresql14/distinfo      Sat Nov 16 10:13:48 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.16 2024/08/09 21:55:47 adam Exp $
+$NetBSD: distinfo,v 1.17 2024/11/16 10:13:48 adam Exp $
 
-BLAKE2s (postgresql-14.13.tar.bz2) = 417aaec1a39dabcf19bb5d2e03549530355445cddaaced4fd6aea65349f698a5
-SHA512 (postgresql-14.13.tar.bz2) = 816e15b619a965b32a3afddebbf9cf5aabacc2440e88b11b0743767a353fe6966503c0e2a08c19d2de9705895f7aedadcf105732d0d3494c61402d379770c6d7
-Size (postgresql-14.13.tar.bz2) = 22414381 bytes
+BLAKE2s (postgresql-14.14.tar.bz2) = 82c134e972686a80270d5fad121fce67f081c74cb6f5c820f589c5f78074d685
+SHA512 (postgresql-14.14.tar.bz2) = 993f369fb405d6cf5b5ebc57a970cdc7a6fa08a9324924a5c5e59b3518f13c73362659bfe579e6d0264d1edac540245d876bcc41a7d4bd31559ce202cfa1cdc3
+Size (postgresql-14.14.tar.bz2) = 22451431 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql14-client/Makefile
diff -u pkgsrc/databases/postgresql14-client/Makefile:1.24 pkgsrc/databases/postgresql14-client/Makefile:1.25
--- pkgsrc/databases/postgresql14-client/Makefile:1.24  Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-client/Makefile       Sat Nov 16 10:13:48 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.25 2024/11/16 10:13:48 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-client-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-client/PLIST
diff -u pkgsrc/databases/postgresql14-client/PLIST:1.3 pkgsrc/databases/postgresql14-client/PLIST:1.4
--- pkgsrc/databases/postgresql14-client/PLIST:1.3      Fri Feb 11 08:31:24 2022
+++ pkgsrc/databases/postgresql14-client/PLIST  Sat Nov 16 10:13:48 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2022/02/11 08:31:24 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2024/11/16 10:13:48 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -438,8 +438,10 @@ include/postgresql/server/foreign/foreig
 include/postgresql/server/funcapi.h
 include/postgresql/server/getaddrinfo.h
 include/postgresql/server/getopt_long.h
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/binaryheap.h
 include/postgresql/server/lib/bipartite_match.h
@@ -599,6 +601,7 @@ include/postgresql/server/port/win32_msv
 include/postgresql/server/port/win32_msvc/unistd.h
 include/postgresql/server/port/win32_msvc/utime.h
 include/postgresql/server/port/win32_port.h
+include/postgresql/server/port/win32ntdll.h
 include/postgresql/server/portability/instr_time.h
 include/postgresql/server/portability/mem.h
 include/postgresql/server/postgres.h

Index: pkgsrc/databases/postgresql14-contrib/Makefile
diff -u pkgsrc/databases/postgresql14-contrib/Makefile:1.20 pkgsrc/databases/postgresql14-contrib/Makefile:1.21
--- pkgsrc/databases/postgresql14-contrib/Makefile:1.20 Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-contrib/Makefile      Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-contrib-/}
-PKGREVISION=   3
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-docs/Makefile
diff -u pkgsrc/databases/postgresql14-docs/Makefile:1.20 pkgsrc/databases/postgresql14-docs/Makefile:1.21
--- pkgsrc/databases/postgresql14-docs/Makefile:1.20    Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-docs/Makefile Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-docs-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-docs/PLIST
diff -u pkgsrc/databases/postgresql14-docs/PLIST:1.14 pkgsrc/databases/postgresql14-docs/PLIST:1.15
--- pkgsrc/databases/postgresql14-docs/PLIST:1.14       Fri Aug  9 21:55:47 2024
+++ pkgsrc/databases/postgresql14-docs/PLIST    Sat Nov 16 10:13:49 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2024/08/09 21:55:47 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2024/11/16 10:13:49 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -991,6 +991,7 @@ share/doc/postgresql/html/release-14-10.
 share/doc/postgresql/html/release-14-11.html
 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-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.23 pkgsrc/databases/postgresql14-plperl/Makefile:1.24
--- pkgsrc/databases/postgresql14-plperl/Makefile:1.23  Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-plperl/Makefile       Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plperl-/}
-PKGREVISION=   3
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-plpython/Makefile
diff -u pkgsrc/databases/postgresql14-plpython/Makefile:1.22 pkgsrc/databases/postgresql14-plpython/Makefile:1.23
--- pkgsrc/databases/postgresql14-plpython/Makefile:1.22        Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-plpython/Makefile     Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.23 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plpython-/}
-PKGREVISION=   3
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-pltcl/Makefile
diff -u pkgsrc/databases/postgresql14-pltcl/Makefile:1.20 pkgsrc/databases/postgresql14-pltcl/Makefile:1.21
--- pkgsrc/databases/postgresql14-pltcl/Makefile:1.20   Thu Nov 14 22:19:07 2024
+++ pkgsrc/databases/postgresql14-pltcl/Makefile        Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2024/11/14 22:19:07 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-pltcl-/}
-PKGREVISION=   3
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-server/Makefile
diff -u pkgsrc/databases/postgresql14-server/Makefile:1.20 pkgsrc/databases/postgresql14-server/Makefile:1.21
--- pkgsrc/databases/postgresql14-server/Makefile:1.20  Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql14-server/Makefile       Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-server-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql15/Makefile
diff -u pkgsrc/databases/postgresql15/Makefile:1.14 pkgsrc/databases/postgresql15/Makefile:1.15
--- pkgsrc/databases/postgresql15/Makefile:1.14 Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15/Makefile      Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.15 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-/}
-PKGREVISION=   3
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql15-client>=${PKGVERSION_NOREV}:../../databases/postgresql15-client

Index: pkgsrc/databases/postgresql15/Makefile.common
diff -u pkgsrc/databases/postgresql15/Makefile.common:1.10 pkgsrc/databases/postgresql15/Makefile.common:1.11
--- pkgsrc/databases/postgresql15/Makefile.common:1.10  Fri Aug  9 21:55:48 2024
+++ pkgsrc/databases/postgresql15/Makefile.common       Sat Nov 16 10:13:49 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2024/08/09 21:55:48 adam Exp $
+# $NetBSD: Makefile.common,v 1.11 2024/11/16 10:13:49 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.8
+DISTNAME=      postgresql-15.9
 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.9 pkgsrc/databases/postgresql15/distinfo:1.10
--- pkgsrc/databases/postgresql15/distinfo:1.9  Fri Aug  9 21:55:48 2024
+++ pkgsrc/databases/postgresql15/distinfo      Sat Nov 16 10:13:49 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.9 2024/08/09 21:55:48 adam Exp $
+$NetBSD: distinfo,v 1.10 2024/11/16 10:13:49 adam Exp $
 
-BLAKE2s (postgresql-15.8.tar.bz2) = aaa70f526d6e3d57a493dfc10f059619689655013572c4f98f76a5e6a05071f4
-SHA512 (postgresql-15.8.tar.bz2) = da610d878819179fcafe8adf6cbe72e188537dbaff82457c67013f9089ae8cbb1f6d8c4d5ea62e4ef54c3e2a90060bd1f36b71b8531354279181e574d903940c
-Size (postgresql-15.8.tar.bz2) = 23119460 bytes
+BLAKE2s (postgresql-15.9.tar.bz2) = bc9beed0c2578a8355e85f44998681d1d7789ec79b8a692dd3f27a37399a1c11
+SHA512 (postgresql-15.9.tar.bz2) = eb8e85e136e5e3f2e9da1fffce06ffda3fdd2001d46153e1a7e02983bd1fcb29a92bec3cbf1fec48a4505b68a9360d24acf45e96a3ce94272833ba45096e8a1b
+Size (postgresql-15.9.tar.bz2) = 23135232 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9

Index: pkgsrc/databases/postgresql15-client/Makefile
diff -u pkgsrc/databases/postgresql15-client/Makefile:1.13 pkgsrc/databases/postgresql15-client/Makefile:1.14
--- pkgsrc/databases/postgresql15-client/Makefile:1.13  Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-client/Makefile       Sat Nov 16 10:13:49 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2024/11/16 10:13:49 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-client-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-client/PLIST
diff -u pkgsrc/databases/postgresql15-client/PLIST:1.3 pkgsrc/databases/postgresql15-client/PLIST:1.4
--- pkgsrc/databases/postgresql15-client/PLIST:1.3      Fri May 12 07:40:27 2023
+++ pkgsrc/databases/postgresql15-client/PLIST  Sat Nov 16 10:13:49 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2023/05/12 07:40:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2024/11/16 10:13:49 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -449,8 +449,10 @@ include/postgresql/server/foreign/foreig
 include/postgresql/server/funcapi.h
 include/postgresql/server/getaddrinfo.h
 include/postgresql/server/getopt_long.h
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/binaryheap.h
 include/postgresql/server/lib/bipartite_match.h

Index: pkgsrc/databases/postgresql15-contrib/Makefile
diff -u pkgsrc/databases/postgresql15-contrib/Makefile:1.13 pkgsrc/databases/postgresql15-contrib/Makefile:1.14
--- pkgsrc/databases/postgresql15-contrib/Makefile:1.13 Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-contrib/Makefile      Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-contrib-/}
-PKGREVISION=   3
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-docs/Makefile
diff -u pkgsrc/databases/postgresql15-docs/Makefile:1.13 pkgsrc/databases/postgresql15-docs/Makefile:1.14
--- pkgsrc/databases/postgresql15-docs/Makefile:1.13    Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-docs/Makefile Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-docs-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-docs/PLIST
diff -u pkgsrc/databases/postgresql15-docs/PLIST:1.9 pkgsrc/databases/postgresql15-docs/PLIST:1.10
--- pkgsrc/databases/postgresql15-docs/PLIST:1.9        Fri Aug  9 21:55:48 2024
+++ pkgsrc/databases/postgresql15-docs/PLIST    Sat Nov 16 10:13:50 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2024/08/09 21:55:48 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2024/11/16 10:13:50 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1007,6 +1007,7 @@ share/doc/postgresql/html/release-15-5.h
 share/doc/postgresql/html/release-15-6.html
 share/doc/postgresql/html/release-15-7.html
 share/doc/postgresql/html/release-15-8.html
+share/doc/postgresql/html/release-15-9.html
 share/doc/postgresql/html/release-15.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql15-plperl/Makefile
diff -u pkgsrc/databases/postgresql15-plperl/Makefile:1.15 pkgsrc/databases/postgresql15-plperl/Makefile:1.16
--- pkgsrc/databases/postgresql15-plperl/Makefile:1.15  Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-plperl/Makefile       Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.15 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.16 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plperl-/}
-PKGREVISION=   3
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql15-server>=${PKGVERSION_NOREV}:../../databases/postgresql15-server

Index: pkgsrc/databases/postgresql15-plpython/Makefile
diff -u pkgsrc/databases/postgresql15-plpython/Makefile:1.14 pkgsrc/databases/postgresql15-plpython/Makefile:1.15
--- pkgsrc/databases/postgresql15-plpython/Makefile:1.14        Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-plpython/Makefile     Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.15 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plpython-/}
-PKGREVISION=   3
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql15-server>=${PKGVERSION_NOREV}:../../databases/postgresql15-server

Index: pkgsrc/databases/postgresql15-pltcl/Makefile
diff -u pkgsrc/databases/postgresql15-pltcl/Makefile:1.13 pkgsrc/databases/postgresql15-pltcl/Makefile:1.14
--- pkgsrc/databases/postgresql15-pltcl/Makefile:1.13   Thu Nov 14 22:19:08 2024
+++ pkgsrc/databases/postgresql15-pltcl/Makefile        Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2024/11/14 22:19:08 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-pltcl-/}
-PKGREVISION=   3
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql15-server>=${PKGVERSION_NOREV}:../../databases/postgresql15-server

Index: pkgsrc/databases/postgresql15-server/Makefile
diff -u pkgsrc/databases/postgresql15-server/Makefile:1.13 pkgsrc/databases/postgresql15-server/Makefile:1.14
--- pkgsrc/databases/postgresql15-server/Makefile:1.13  Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql15-server/Makefile       Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-server-/}
-PKGREVISION=   3
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql16/Makefile
diff -u pkgsrc/databases/postgresql16/Makefile:1.9 pkgsrc/databases/postgresql16/Makefile:1.10
--- pkgsrc/databases/postgresql16/Makefile:1.9  Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16/Makefile      Sat Nov 16 10:13:50 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:50 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-/}
-PKGREVISION=   3
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql16-client>=${PKGVERSION_NOREV}:../../databases/postgresql16-client

Index: pkgsrc/databases/postgresql16/Makefile.common
diff -u pkgsrc/databases/postgresql16/Makefile.common:1.7 pkgsrc/databases/postgresql16/Makefile.common:1.8
--- pkgsrc/databases/postgresql16/Makefile.common:1.7   Fri Aug  9 21:55:49 2024
+++ pkgsrc/databases/postgresql16/Makefile.common       Sat Nov 16 10:13:50 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.7 2024/08/09 21:55:49 adam Exp $
+# $NetBSD: Makefile.common,v 1.8 2024/11/16 10:13:50 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.4
+DISTNAME=      postgresql-16.5
 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.6 pkgsrc/databases/postgresql16/distinfo:1.7
--- pkgsrc/databases/postgresql16/distinfo:1.6  Fri Aug  9 21:55:49 2024
+++ pkgsrc/databases/postgresql16/distinfo      Sat Nov 16 10:13:50 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.6 2024/08/09 21:55:49 adam Exp $
+$NetBSD: distinfo,v 1.7 2024/11/16 10:13:50 adam Exp $
 
-BLAKE2s (postgresql-16.4.tar.bz2) = b13ab786c60bfe01bba444631df2490092b163ff26124d780fd00284ccd7faf7
-SHA512 (postgresql-16.4.tar.bz2) = f2070299f0857a270317ac984f8393374cf00d4f32a082fe3c5481e36c560595ea711fed95e40d1bc90c5089edf8f165649d443d8b9c68614e1c83fc91268e96
-Size (postgresql-16.4.tar.bz2) = 24765786 bytes
+BLAKE2s (postgresql-16.5.tar.bz2) = e16b5bb96ea3992f602490282fc5e7c52210ba0594ae508ebbf8673e270a869a
+SHA512 (postgresql-16.5.tar.bz2) = aec47744284c5a593f4223de26187dd4b00e27a8a8948c6b7d24ca522eb6b4d0098ec956e80f37d5a3a841d18e45e4a21e7323e33af91eff24e1b2c59577bef1
+Size (postgresql-16.5.tar.bz2) = 24854528 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = 3392111516ca65ad7980ee39246c4210ec020c34
@@ -12,4 +12,4 @@ SHA1 (patch-src_Makefile.shlib) = 23bddc
 SHA1 (patch-src_backend_Makefile) = a4d4cdb46fed094367d4953ad256f239ac82194b
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 2dd1a3e6b279331b0835d3af3af02f4fe1cfa216
-SHA1 (patch-src_pl_plperl_GNUmakefile) = 6626a4dcea72dd6c0f51ffada202659f0f9f0ab9
+SHA1 (patch-src_pl_plperl_GNUmakefile) = e2327b9f11a77040337ce645d4e77aabde14563a

Index: pkgsrc/databases/postgresql16-client/Makefile
diff -u pkgsrc/databases/postgresql16-client/Makefile:1.10 pkgsrc/databases/postgresql16-client/Makefile:1.11
--- pkgsrc/databases/postgresql16-client/Makefile:1.10  Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-client/Makefile       Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.11 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-client-/}
-PKGREVISION=   4
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql16/Makefile.common"

Index: pkgsrc/databases/postgresql16-client/PLIST
diff -u pkgsrc/databases/postgresql16-client/PLIST:1.2 pkgsrc/databases/postgresql16-client/PLIST:1.3
--- pkgsrc/databases/postgresql16-client/PLIST:1.2      Mon Nov 13 20:22:08 2023
+++ pkgsrc/databases/postgresql16-client/PLIST  Sat Nov 16 10:13:51 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2023/11/13 20:22:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2024/11/16 10:13:51 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -452,8 +452,10 @@ include/postgresql/server/foreign/fdwapi
 include/postgresql/server/foreign/foreign.h
 include/postgresql/server/funcapi.h
 include/postgresql/server/getopt_long.h
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/binaryheap.h
 include/postgresql/server/lib/bipartite_match.h

Index: pkgsrc/databases/postgresql16-contrib/Makefile
diff -u pkgsrc/databases/postgresql16-contrib/Makefile:1.9 pkgsrc/databases/postgresql16-contrib/Makefile:1.10
--- pkgsrc/databases/postgresql16-contrib/Makefile:1.9  Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-contrib/Makefile      Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-contrib-/}
-PKGREVISION=   3
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql16/Makefile.common"

Index: pkgsrc/databases/postgresql16-docs/Makefile
diff -u pkgsrc/databases/postgresql16-docs/Makefile:1.9 pkgsrc/databases/postgresql16-docs/Makefile:1.10
--- pkgsrc/databases/postgresql16-docs/Makefile:1.9     Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-docs/Makefile Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-docs-/}
-PKGREVISION=   4
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql16/Makefile.common"

Index: pkgsrc/databases/postgresql16-docs/PLIST
diff -u pkgsrc/databases/postgresql16-docs/PLIST:1.5 pkgsrc/databases/postgresql16-docs/PLIST:1.6
--- pkgsrc/databases/postgresql16-docs/PLIST:1.5        Fri Aug  9 21:55:49 2024
+++ pkgsrc/databases/postgresql16-docs/PLIST    Sat Nov 16 10:13:51 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2024/08/09 21:55:49 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2024/11/16 10:13:51 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1002,6 +1002,7 @@ share/doc/postgresql/html/release-16-1.h
 share/doc/postgresql/html/release-16-2.html
 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.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.9 pkgsrc/databases/postgresql16-plperl/Makefile:1.10
--- pkgsrc/databases/postgresql16-plperl/Makefile:1.9   Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-plperl/Makefile       Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-plperl-/}
-PKGREVISION=   3
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql16-server>=${PKGVERSION_NOREV}:../../databases/postgresql16-server

Index: pkgsrc/databases/postgresql16-plpython/Makefile
diff -u pkgsrc/databases/postgresql16-plpython/Makefile:1.9 pkgsrc/databases/postgresql16-plpython/Makefile:1.10
--- pkgsrc/databases/postgresql16-plpython/Makefile:1.9 Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-plpython/Makefile     Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-plpython-/}
-PKGREVISION=   3
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql16-server>=${PKGVERSION_NOREV}:../../databases/postgresql16-server

Index: pkgsrc/databases/postgresql16-pltcl/Makefile
diff -u pkgsrc/databases/postgresql16-pltcl/Makefile:1.9 pkgsrc/databases/postgresql16-pltcl/Makefile:1.10
--- pkgsrc/databases/postgresql16-pltcl/Makefile:1.9    Thu Nov 14 22:19:09 2024
+++ pkgsrc/databases/postgresql16-pltcl/Makefile        Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2024/11/14 22:19:09 wiz Exp $
+# $NetBSD: Makefile,v 1.10 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-pltcl-/}
-PKGREVISION=   3
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql16-server>=${PKGVERSION_NOREV}:../../databases/postgresql16-server

Index: pkgsrc/databases/postgresql16-server/Makefile
diff -u pkgsrc/databases/postgresql16-server/Makefile:1.10 pkgsrc/databases/postgresql16-server/Makefile:1.11
--- pkgsrc/databases/postgresql16-server/Makefile:1.10  Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql16-server/Makefile       Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.11 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-server-/}
-PKGREVISION=   4
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile
diff -u pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile:1.1 pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile:1.2
--- pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile:1.1   Sun Sep 17 08:53:21 2023
+++ pkgsrc/databases/postgresql16/patches/patch-src_pl_plperl_GNUmakefile       Sat Nov 16 10:13:50 2024
@@ -1,10 +1,10 @@
-$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.1 2023/09/17 08:53:21 adam Exp $
+$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.2 2024/11/16 10:13:50 adam Exp $
 
---- src/pl/plperl/GNUmakefile.orig     2018-10-15 21:12:02.000000000 +0000
+--- src/pl/plperl/GNUmakefile.orig     2024-11-11 22:44:10.000000000 +0000
 +++ src/pl/plperl/GNUmakefile
-@@ -79,7 +78,7 @@ perlchunks.h: $(PERLCHUNKS)
+@@ -87,7 +87,7 @@ perlchunks.h: $(PERLCHUNKS)
        @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi
-       $(PERL) $(srcdir)/text2macro.pl --strip='^(\#.*|\s*)$$' $^ > $@
+       $(PERL) $(srcdir)/text2macro.pl $^ > $@
  
 -all: all-lib
 +all: perlchunks.h plperl_opmask.h all-lib

Index: pkgsrc/databases/postgresql17/Makefile
diff -u pkgsrc/databases/postgresql17/Makefile:1.2 pkgsrc/databases/postgresql17/Makefile:1.3
--- pkgsrc/databases/postgresql17/Makefile:1.2  Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17/Makefile      Sat Nov 16 10:13:51 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:51 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql17-client>=${PKGVERSION_NOREV}:../../databases/postgresql17-client

Index: pkgsrc/databases/postgresql17/Makefile.common
diff -u pkgsrc/databases/postgresql17/Makefile.common:1.1 pkgsrc/databases/postgresql17/Makefile.common:1.2
--- pkgsrc/databases/postgresql17/Makefile.common:1.1   Fri Nov  8 13:43:36 2024
+++ pkgsrc/databases/postgresql17/Makefile.common       Sat Nov 16 10:13:51 2024
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.1 2024/11/08 13:43:36 adam Exp $
+# $NetBSD: Makefile.common,v 1.2 2024/11/16 10:13:51 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.0
+DISTNAME=      postgresql-17.1
 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.1 pkgsrc/databases/postgresql17/distinfo:1.2
--- pkgsrc/databases/postgresql17/distinfo:1.1  Fri Nov  8 13:43:36 2024
+++ pkgsrc/databases/postgresql17/distinfo      Sat Nov 16 10:13:51 2024
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.1 2024/11/08 13:43:36 adam Exp $
+$NetBSD: distinfo,v 1.2 2024/11/16 10:13:51 adam Exp $
 
-BLAKE2s (postgresql-17.0.tar.bz2) = 4132f4b84fe0410d19757eed131332c52861ab7156735e3b86d47cba9d424a79
-SHA512 (postgresql-17.0.tar.bz2) = ae6741298abe986c9f09a6eee9fa2df26c3bbdffcbd0ff3f33332456e09f95195e4535f00a9437f2877e03e2e43a78be9a355303e7cf43bcb688b657ca7289f3
-Size (postgresql-17.0.tar.bz2) = 21419388 bytes
+BLAKE2s (postgresql-17.1.tar.bz2) = 8256d967a8ff198dc81b6d320b3597163874995d532e56b5ff13c18b8e86c37d
+SHA512 (postgresql-17.1.tar.bz2) = 41bd56ea5d2c3d41bd273894a056bd10244b33186746b63918f03671ba548551e02694f8215f09c6408c4dd6bb6ba0e87dec612560e8a267f5c5734b177e70a0
+Size (postgresql-17.1.tar.bz2) = 21410991 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = beebdd7d46e37065c86d7edbfb982bac1fbc9147
@@ -12,4 +12,4 @@ SHA1 (patch-src_Makefile.shlib) = b304f5
 SHA1 (patch-src_backend_Makefile) = 514a0bb7a0d570df4e28b582e58baf7fd1224e40
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 2dd1a3e6b279331b0835d3af3af02f4fe1cfa216
-SHA1 (patch-src_pl_plperl_GNUmakefile) = 6626a4dcea72dd6c0f51ffada202659f0f9f0ab9
+SHA1 (patch-src_pl_plperl_GNUmakefile) = 5ca28fdf0a2426e3c9ab26ef9c5dfe626a96ef46

Index: pkgsrc/databases/postgresql17-client/Makefile
diff -u pkgsrc/databases/postgresql17-client/Makefile:1.2 pkgsrc/databases/postgresql17-client/Makefile:1.3
--- pkgsrc/databases/postgresql17-client/Makefile:1.2   Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-client/Makefile       Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql17/Makefile.common"

Index: pkgsrc/databases/postgresql17-client/PLIST
diff -u pkgsrc/databases/postgresql17-client/PLIST:1.1 pkgsrc/databases/postgresql17-client/PLIST:1.2
--- pkgsrc/databases/postgresql17-client/PLIST:1.1      Fri Nov  8 13:43:37 2024
+++ pkgsrc/databases/postgresql17-client/PLIST  Sat Nov 16 10:13:52 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2024/11/08 13:43:37 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2024/11/16 10:13:52 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -468,8 +468,10 @@ include/postgresql/server/foreign/fdwapi
 include/postgresql/server/foreign/foreign.h
 include/postgresql/server/funcapi.h
 include/postgresql/server/getopt_long.h
+include/postgresql/server/jit/SectionMemoryManager.h
 include/postgresql/server/jit/jit.h
 include/postgresql/server/jit/llvmjit.h
+include/postgresql/server/jit/llvmjit_backport.h
 include/postgresql/server/jit/llvmjit_emit.h
 include/postgresql/server/lib/binaryheap.h
 include/postgresql/server/lib/bipartite_match.h
@@ -1265,6 +1267,7 @@ ${PLIST.nls}share/locale/uk/LC_MESSAGES/
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_archivecleanup-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_basebackup-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_checksums-17.mo
+${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_combinebackup-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_config-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_controldata-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_ctl-17.mo
@@ -1276,6 +1279,7 @@ ${PLIST.nls}share/locale/uk/LC_MESSAGES/
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_upgrade-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_verifybackup-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_waldump-17.mo
+${PLIST.nls}share/locale/uk/LC_MESSAGES/pg_walsummary-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/pgscripts-17.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/psql-17.mo
 ${PLIST.nls}share/locale/vi/LC_MESSAGES/ecpg-17.mo

Index: pkgsrc/databases/postgresql17-contrib/Makefile
diff -u pkgsrc/databases/postgresql17-contrib/Makefile:1.2 pkgsrc/databases/postgresql17-contrib/Makefile:1.3
--- pkgsrc/databases/postgresql17-contrib/Makefile:1.2  Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-contrib/Makefile      Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql17/Makefile.common"

Index: pkgsrc/databases/postgresql17-docs/Makefile
diff -u pkgsrc/databases/postgresql17-docs/Makefile:1.2 pkgsrc/databases/postgresql17-docs/Makefile:1.3
--- pkgsrc/databases/postgresql17-docs/Makefile:1.2     Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-docs/Makefile Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql17/Makefile.common"

Index: pkgsrc/databases/postgresql17-docs/PLIST
diff -u pkgsrc/databases/postgresql17-docs/PLIST:1.1 pkgsrc/databases/postgresql17-docs/PLIST:1.2
--- pkgsrc/databases/postgresql17-docs/PLIST:1.1        Fri Nov  8 13:43:38 2024
+++ pkgsrc/databases/postgresql17-docs/PLIST    Sat Nov 16 10:13:52 2024
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2024/11/08 13:43:38 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2024/11/16 10:13:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -982,6 +982,7 @@ share/doc/postgresql/html/regress-run.ht
 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-17-1.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.2 pkgsrc/databases/postgresql17-plperl/Makefile:1.3
--- pkgsrc/databases/postgresql17-plperl/Makefile:1.2   Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-plperl/Makefile       Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 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

Index: pkgsrc/databases/postgresql17-plpython/Makefile
diff -u pkgsrc/databases/postgresql17-plpython/Makefile:1.2 pkgsrc/databases/postgresql17-plpython/Makefile:1.3
--- pkgsrc/databases/postgresql17-plpython/Makefile:1.2 Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-plpython/Makefile     Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql17-server>=${PKGVERSION_NOREV}:../../databases/postgresql17-server

Index: pkgsrc/databases/postgresql17-pltcl/Makefile
diff -u pkgsrc/databases/postgresql17-pltcl/Makefile:1.2 pkgsrc/databases/postgresql17-pltcl/Makefile:1.3
--- pkgsrc/databases/postgresql17-pltcl/Makefile:1.2    Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-pltcl/Makefile        Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql17-server>=${PKGVERSION_NOREV}:../../databases/postgresql17-server

Index: pkgsrc/databases/postgresql17-server/Makefile
diff -u pkgsrc/databases/postgresql17-server/Makefile:1.3 pkgsrc/databases/postgresql17-server/Makefile:1.4
--- pkgsrc/databases/postgresql17-server/Makefile:1.3   Thu Nov 14 22:19:10 2024
+++ pkgsrc/databases/postgresql17-server/Makefile       Sat Nov 16 10:13:52 2024
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2024/11/14 22:19:10 wiz Exp $
+# $NetBSD: Makefile,v 1.4 2024/11/16 10:13:52 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation
@@ -19,15 +18,10 @@ INSTALL_DIRS+=      src/backend/utils/mb/conv
 INSTALL_DIRS+= src/backend/snowball
 INSTALL_DIRS+= src/timezone
 INSTALL_DIRS+= src/pl
-BUILD_DIRS=    src/port
-BUILD_DIRS+=   src/include/catalog
+BUILD_DIRS=    src/include/catalog
+BUILD_DIRS+=   src/port
 BUILD_DIRS+=   ${INSTALL_DIRS}
 
-# MAKE_JOBS=22 failed with:
-# In file included from ../../src/include/postgres.h:46, from chklocale.c:17:
-# ../../src/include/utils/elog.h:79:10: fatal error: utils/errcodes.h: No such file or directory
-MAKE_JOBS_SAFE=      no
-
 # PostgreSQL has loadable server-side language modules.
 #
 # Explicitly set DLOPEN_REQUIRE_PTHREADS to "no" on NetBSD as NetBSD-2.x

Index: pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile
diff -u pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile:1.1 pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile:1.2
--- pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile:1.1   Fri Nov  8 13:43:37 2024
+++ pkgsrc/databases/postgresql17/patches/patch-src_pl_plperl_GNUmakefile       Sat Nov 16 10:13:52 2024
@@ -1,10 +1,10 @@
-$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.1 2024/11/08 13:43:37 adam Exp $
+$NetBSD: patch-src_pl_plperl_GNUmakefile,v 1.2 2024/11/16 10:13:52 adam Exp $
 
---- src/pl/plperl/GNUmakefile.orig     2018-10-15 21:12:02.000000000 +0000
+--- src/pl/plperl/GNUmakefile.orig     2024-11-11 22:42:37.000000000 +0000
 +++ src/pl/plperl/GNUmakefile
-@@ -79,7 +78,7 @@ perlchunks.h: $(PERLCHUNKS)
+@@ -87,7 +87,7 @@ perlchunks.h: $(PERLCHUNKS)
        @if [ x"$(perl_privlibexp)" = x"" ]; then echo "configure switch --with-perl was not specified."; exit 1; fi
-       $(PERL) $(srcdir)/text2macro.pl --strip='^(\#.*|\s*)$$' $^ > $@
+       $(PERL) $(srcdir)/text2macro.pl $^ > $@
  
 -all: all-lib
 +all: perlchunks.h plperl_opmask.h all-lib

Index: pkgsrc/mk/pgsql.buildlink3.mk
diff -u pkgsrc/mk/pgsql.buildlink3.mk:1.65 pkgsrc/mk/pgsql.buildlink3.mk:1.66
--- pkgsrc/mk/pgsql.buildlink3.mk:1.65  Fri Nov  8 13:43:36 2024
+++ pkgsrc/mk/pgsql.buildlink3.mk       Sat Nov 16 10:13:44 2024
@@ -1,4 +1,4 @@
-# $NetBSD: pgsql.buildlink3.mk,v 1.65 2024/11/08 13:43:36 adam Exp $
+# $NetBSD: pgsql.buildlink3.mk,v 1.66 2024/11/16 10:13:44 adam Exp $
 #
 # User-settable variables:
 #
@@ -26,7 +26,7 @@ _SYS_VARS.pgsql=      PG_LIB_EXT PGSQL_TYPE P
 .include "../../mk/bsd.prefs.mk"
 
 PGSQL_VERSION_DEFAULT?=                14
-PGSQL_VERSIONS_ACCEPTED?=      17 16 15 14 13 12
+PGSQL_VERSIONS_ACCEPTED?=      17 16 15 14 13
 
 # transform the list into individual variables
 .for pv in ${PGSQL_VERSIONS_ACCEPTED}
@@ -56,9 +56,6 @@ _PGSQL_VERSION_14_INSTALLED=  yes
 .  if exists(${_CROSS_DESTDIR:U}${LOCALBASE}/lib/libecpg.6.13.dylib)
 _PGSQL_VERSION_13_INSTALLED=   yes
 .  endif
-.  if exists(${_CROSS_DESTDIR:U}${LOCALBASE}/lib/libecpg.6.12.dylib)
-_PGSQL_VERSION_12_INSTALLED=   yes
-.  endif
 .else
 .  if exists(${_CROSS_DESTDIR:U}${LOCALBASE}/lib/libecpg.so.6.17)
 _PGSQL_VERSION_17_INSTALLED=   yes
@@ -75,9 +72,6 @@ _PGSQL_VERSION_14_INSTALLED=  yes
 .  if exists(${_CROSS_DESTDIR:U}${LOCALBASE}/lib/libecpg.so.6.13)
 _PGSQL_VERSION_13_INSTALLED=   yes
 .  endif
-.  if exists(${_CROSS_DESTDIR:U}${LOCALBASE}/lib/libecpg.so.6.12)
-_PGSQL_VERSION_12_INSTALLED=   yes
-.  endif
 .endif
 
 # if a version is explicitely required, take it
@@ -130,9 +124,6 @@ PGPKGSRCDIR=        ../../databases/postgresql1
 .elif ${_PGSQL_VERSION} == "13"
 PGSQL_TYPE=    postgresql13-client
 PGPKGSRCDIR=   ../../databases/postgresql13-client
-.elif ${_PGSQL_VERSION} == "12"
-PGSQL_TYPE=    postgresql12-client
-PGPKGSRCDIR=   ../../databases/postgresql12-client
 .else
 # force an error
 PGSQL_TYPE=            none



Home | Main Index | Thread Index | Old Index