CVS commit: pkgsrc/databases

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc/databases
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Fri, 9 May 2025 13:46:36 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Fri May  9 13:46:35 UTC 2025

Modified Files:
        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 PLIST
        pkgsrc/databases/postgresql13/patches: patch-contrib_dblink_dblink.c
        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 PLIST
        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 PLIST
        pkgsrc/databases/postgresql16: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql16-client: Makefile
        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 PLIST
        pkgsrc/databases/postgresql17: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql17-client: Makefile
        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 PLIST

Log Message:
postgresql: updated to 17.5, 16.9, 15.13, 14.18, 13.21

PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21

CVE-2025-4207: PostgreSQL GB18030 encoding validation can read one byte past end of allocation for text that fails validation

Bug Fixes and Improvements

This update fixes over 60 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.

Handle self-referential foreign keys on partitioned tables correctly. Creating or attaching partitions failed to make the required catalog entries for a foreign-key constraint if the table referenced 
by the constraint was the same partitioned table. This resulted in failure to enforce the constraint fully. To fix this, please see the instructions in the "Updating" section.
Fix for potential data loss issue when using BRIN bloom indexes (e.g. using the date_bloom_ops operator class).
Fix MERGE into a partitioned table with DO NOTHING actions.
Prevent failure in INSERT commands when the table has a GENERATED column of a domain type and the domain's constraints disallow NULL values.
Fix ALTER TABLE .. ADD COLUMN to correctly handle the case of a domain type that has its own default value and the DEFAULT for the column is not set.
Fix issues when performing casts within the keys of JSON constructor expressions.
Fix XMLSERIALIZE() so that the INDENT option is correctly dumped out when it's present in views or rules. This was noticeable on restores.
Several query planner fixes, including avoiding a premature evaluation of arguments in an aggregate function that has both FILTER and either ORDER BY or DISTINCT clauses that could lead to 
unnecessary failures.
Fix for potentially returning incorrect results when a bitmap scan without output columns is executed while vacuum is also running on the same table.
Fix performance issues in GIN index search startup when there are many search keys, for example, jsonbcol ?| array[...] with tens of thousands of array elements.
Ensure that I/O statistics of active WAL senders are reported within at most one second.
Fix race condition in handling of synchronous_standby_names immediately after startup, where a backend might fail to wait for a synchronous commit.
Avoid infinite loop if scram_iterations is set to INT_MAX.
Several fixes for logical replication, including handling of vacuum around deleted rows that are still required for logical decoding.
Prevent potential data loss when schema modification operations (DDL) that don't take a strong lock affect tables that are being logically replicated.
Prevent issues in logical replication that could allow duplicate data to be applied due to apply worker error handling.
Improve how reindexdb handles scheduling parallel reindex operations to achieve the expected amount of parallelism.

This release also updates time zone data files to tzdata release 2025b for DST law changes in Chile, plus historical corrections for Iran. Additionally, there is a new time zone America/Coyhaique for 
Chile's Aysén Region, to account for it changing to UTC-03 year-round, which diverges from America/Santiago.


To generate a diff of this commit:
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/postgresql13/Makefile
cvs rdiff -u -r1.29 -r1.30 pkgsrc/databases/postgresql13/Makefile.common
cvs rdiff -u -r1.27 -r1.28 pkgsrc/databases/postgresql13/distinfo
cvs rdiff -u -r1.38 -r1.39 pkgsrc/databases/postgresql13-client/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql13-client/PLIST
cvs rdiff -u -r1.31 -r1.32 pkgsrc/databases/postgresql13-contrib/Makefile
cvs rdiff -u -r1.27 -r1.28 pkgsrc/databases/postgresql13-docs/Makefile
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/postgresql13-docs/PLIST
cvs rdiff -u -r1.35 -r1.36 pkgsrc/databases/postgresql13-plperl/Makefile
cvs rdiff -u -r1.33 -r1.34 pkgsrc/databases/postgresql13-plpython/Makefile
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/postgresql13-pltcl/Makefile
cvs rdiff -u -r1.30 -r1.31 pkgsrc/databases/postgresql13-server/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql13-server/PLIST
cvs rdiff -u -r1.1 -r1.2 \
    pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c
cvs rdiff -u -r1.26 -r1.27 pkgsrc/databases/postgresql14/Makefile
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql14/Makefile.common
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql14/distinfo
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql14-client/Makefile
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql14-client/PLIST
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql14-contrib/Makefile
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql14-docs/Makefile
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql14-docs/PLIST
cvs rdiff -u -r1.28 -r1.29 pkgsrc/databases/postgresql14-plperl/Makefile
cvs rdiff -u -r1.25 -r1.26 pkgsrc/databases/postgresql14-plpython/Makefile
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql14-pltcl/Makefile
cvs rdiff -u -r1.23 -r1.24 pkgsrc/databases/postgresql14-server/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql14-server/PLIST
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql15/Makefile
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql15/Makefile.common
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15/distinfo
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql15-client/Makefile
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql15-client/PLIST
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql15-contrib/Makefile
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql15-docs/Makefile
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql15-docs/PLIST
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql15-plperl/Makefile
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql15-plpython/Makefile
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql15-pltcl/Makefile
cvs rdiff -u -r1.16 -r1.17 pkgsrc/databases/postgresql15-server/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql15-server/PLIST
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/postgresql16/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql16/Makefile.common
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql16/distinfo
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql16-client/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql16-contrib/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql16-docs/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql16-docs/PLIST
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql16-plperl/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql16-plpython/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql16-pltcl/Makefile
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/postgresql16-server/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql16-server/PLIST
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql17/Makefile \
    pkgsrc/databases/postgresql17/distinfo
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql17/Makefile.common
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql17-client/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql17-contrib/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql17-docs/Makefile \
    pkgsrc/databases/postgresql17-docs/PLIST
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql17-plperl/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql17-plpython/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql17-pltcl/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql17-server/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql17-server/PLIST

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
diff -u pkgsrc/databases/postgresql13/Makefile:1.31 pkgsrc/databases/postgresql13/Makefile:1.32
--- pkgsrc/databases/postgresql13/Makefile:1.31 Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13/Makefile      Fri May  9 13:46:30 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.31 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.32 2025/05/09 13:46:30 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-/}
-PKGREVISION=   2
 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.29 pkgsrc/databases/postgresql13/Makefile.common:1.30
--- pkgsrc/databases/postgresql13/Makefile.common:1.29  Sun Mar 30 21:10:40 2025
+++ pkgsrc/databases/postgresql13/Makefile.common       Fri May  9 13:46:30 2025
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.29 2025/03/30 21:10:40 wiz Exp $
+# $NetBSD: Makefile.common,v 1.30 2025/05/09 13:46:30 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.20
+DISTNAME=      postgresql-13.21
 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.27 pkgsrc/databases/postgresql13/distinfo:1.28
--- pkgsrc/databases/postgresql13/distinfo:1.27 Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql13/distinfo      Fri May  9 13:46:30 2025
@@ -1,12 +1,12 @@
-$NetBSD: distinfo,v 1.27 2025/02/21 17:29:07 adam Exp $
+$NetBSD: distinfo,v 1.28 2025/05/09 13:46:30 adam Exp $
 
-BLAKE2s (postgresql-13.20.tar.bz2) = 6421ecaebf547ecd628e7025498eaa38593ce0882a8f69970ea949510b13c95a
-SHA512 (postgresql-13.20.tar.bz2) = 884ee8327b803c66679238525e7d51320ea537b41138d7fe8fd7e725631f734a61e53646d9cec78154f3f05a3b50e90508793a56a8f0f76699a53773930cb1d0
-Size (postgresql-13.20.tar.bz2) = 21730844 bytes
+BLAKE2s (postgresql-13.21.tar.bz2) = fa090a75db248be8d299f6e5215d1165d4439f4b801404a25be27329254939d3
+SHA512 (postgresql-13.21.tar.bz2) = 800f58b7651babafcca43411d6215474422e57ed16e5af246bf8beb72afaf844ca325d5d02443089fb9848d0b42872f0251aaa873a79f5094806fcdd2e10ed4b
+Size (postgresql-13.21.tar.bz2) = 21759813 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
-SHA1 (patch-contrib_dblink_dblink.c) = a6f87ab9f2c28a72608d70267b71bd77437b0921
+SHA1 (patch-contrib_dblink_dblink.c) = db8640908822e4fe4440ee09829514ac4e841b31
 SHA1 (patch-contrib_uuid-ossp_Makefile) = 65e975c16f2604a44961ce0ef80be28f13b798c3
 SHA1 (patch-src_Makefile.global.in) = 9690bd0e4e967dbb0f83376a9c9848e34efed74c
 SHA1 (patch-src_Makefile.shlib) = 3bcdbd0d9e3c0609743e72c3cafb83b74c0e412f

Index: pkgsrc/databases/postgresql13-client/Makefile
diff -u pkgsrc/databases/postgresql13-client/Makefile:1.38 pkgsrc/databases/postgresql13-client/Makefile:1.39
--- pkgsrc/databases/postgresql13-client/Makefile:1.38  Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-client/Makefile       Fri May  9 13:46:30 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.38 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.39 2025/05/09 13:46:30 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-client-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-client/PLIST
diff -u pkgsrc/databases/postgresql13-client/PLIST:1.6 pkgsrc/databases/postgresql13-client/PLIST:1.7
--- pkgsrc/databases/postgresql13-client/PLIST:1.6      Sat Nov 16 10:13:47 2024
+++ pkgsrc/databases/postgresql13-client/PLIST  Fri May  9 13:46:30 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2024/11/16 10:13:47 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2025/05/09 13:46:30 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -447,6 +447,7 @@ include/postgresql/server/libpq/be-gssap
 include/postgresql/server/libpq/crypt.h
 include/postgresql/server/libpq/hba.h
 include/postgresql/server/libpq/ifaddr.h
+include/postgresql/server/libpq/libpq-be-fe-helpers.h
 include/postgresql/server/libpq/libpq-be.h
 include/postgresql/server/libpq/libpq-fs.h
 include/postgresql/server/libpq/libpq.h

Index: pkgsrc/databases/postgresql13-contrib/Makefile
diff -u pkgsrc/databases/postgresql13-contrib/Makefile:1.31 pkgsrc/databases/postgresql13-contrib/Makefile:1.32
--- pkgsrc/databases/postgresql13-contrib/Makefile:1.31 Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-contrib/Makefile      Fri May  9 13:46:30 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.31 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.32 2025/05/09 13:46:30 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-contrib-/}
-PKGREVISION=   2
 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.27 pkgsrc/databases/postgresql13-docs/Makefile:1.28
--- pkgsrc/databases/postgresql13-docs/Makefile:1.27    Thu Apr 17 21:50:07 2025
+++ pkgsrc/databases/postgresql13-docs/Makefile Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2025/04/17 21:50:07 wiz Exp $
+# $NetBSD: Makefile,v 1.28 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-docs/PLIST
diff -u pkgsrc/databases/postgresql13-docs/PLIST:1.21 pkgsrc/databases/postgresql13-docs/PLIST:1.22
--- pkgsrc/databases/postgresql13-docs/PLIST:1.21       Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql13-docs/PLIST    Fri May  9 13:46:31 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.21 2025/02/21 17:29:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.22 2025/05/09 13:46:31 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -983,6 +983,7 @@ share/doc/postgresql/html/release-13-18.
 share/doc/postgresql/html/release-13-19.html
 share/doc/postgresql/html/release-13-2.html
 share/doc/postgresql/html/release-13-20.html
+share/doc/postgresql/html/release-13-21.html
 share/doc/postgresql/html/release-13-3.html
 share/doc/postgresql/html/release-13-4.html
 share/doc/postgresql/html/release-13-5.html

Index: pkgsrc/databases/postgresql13-plperl/Makefile
diff -u pkgsrc/databases/postgresql13-plperl/Makefile:1.35 pkgsrc/databases/postgresql13-plperl/Makefile:1.36
--- pkgsrc/databases/postgresql13-plperl/Makefile:1.35  Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-plperl/Makefile       Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.35 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.36 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plperl-/}
-PKGREVISION=   2
 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.33 pkgsrc/databases/postgresql13-plpython/Makefile:1.34
--- pkgsrc/databases/postgresql13-plpython/Makefile:1.33        Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-plpython/Makefile     Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.33 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.34 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plpython-/}
-PKGREVISION=   2
 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.30 pkgsrc/databases/postgresql13-pltcl/Makefile:1.31
--- pkgsrc/databases/postgresql13-pltcl/Makefile:1.30   Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-pltcl/Makefile        Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.30 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.31 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-pltcl-/}
-PKGREVISION=   2
 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.30 pkgsrc/databases/postgresql13-server/Makefile:1.31
--- pkgsrc/databases/postgresql13-server/Makefile:1.30  Sat Apr 19 07:57:36 2025
+++ pkgsrc/databases/postgresql13-server/Makefile       Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.30 2025/04/19 07:57:36 wiz Exp $
+# $NetBSD: Makefile,v 1.31 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-server-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql13-server/PLIST
diff -u pkgsrc/databases/postgresql13-server/PLIST:1.6 pkgsrc/databases/postgresql13-server/PLIST:1.7
--- pkgsrc/databases/postgresql13-server/PLIST:1.6      Wed Feb 15 20:50:59 2023
+++ pkgsrc/databases/postgresql13-server/PLIST  Fri May  9 13:46:31 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2023/02/15 20:50:59 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2025/05/09 13:46:31 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -843,6 +843,7 @@ share/postgresql/timezone/America/Ciudad
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Coyhaique
 share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao

Index: pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c
diff -u pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c:1.1 pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c:1.2
--- pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c:1.1     Sun Oct 18 09:24:02 2020
+++ pkgsrc/databases/postgresql13/patches/patch-contrib_dblink_dblink.c Fri May  9 13:46:30 2025
@@ -1,9 +1,9 @@
-$NetBSD: patch-contrib_dblink_dblink.c,v 1.1 2020/10/18 09:24:02 adam Exp $
+$NetBSD: patch-contrib_dblink_dblink.c,v 1.2 2025/05/09 13:46:30 adam Exp $
 
---- contrib/dblink/dblink.c.orig       2013-04-01 18:20:36.000000000 +0000
+--- contrib/dblink/dblink.c.orig       2025-05-05 20:34:49.000000000 +0000
 +++ contrib/dblink/dblink.c
-@@ -52,7 +52,7 @@
- #include "parser/scansup.h"
+@@ -56,7 +56,7 @@
+ #include "pgstat.h"
  #include "utils/acl.h"
  #include "utils/builtins.h"
 -#include "utils/fmgroids.h"

Index: pkgsrc/databases/postgresql14/Makefile
diff -u pkgsrc/databases/postgresql14/Makefile:1.26 pkgsrc/databases/postgresql14/Makefile:1.27
--- pkgsrc/databases/postgresql14/Makefile:1.26 Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14/Makefile      Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.26 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.27 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-/}
-PKGREVISION=   2
 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.22 pkgsrc/databases/postgresql14/Makefile.common:1.23
--- pkgsrc/databases/postgresql14/Makefile.common:1.22  Sun Mar 30 21:10:40 2025
+++ pkgsrc/databases/postgresql14/Makefile.common       Fri May  9 13:46:31 2025
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.22 2025/03/30 21:10:40 wiz Exp $
+# $NetBSD: Makefile.common,v 1.23 2025/05/09 13:46:31 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.17
+DISTNAME=      postgresql-14.18
 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.20 pkgsrc/databases/postgresql14/distinfo:1.21
--- pkgsrc/databases/postgresql14/distinfo:1.20 Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql14/distinfo      Fri May  9 13:46:31 2025
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.20 2025/02/21 17:29:07 adam Exp $
+$NetBSD: distinfo,v 1.21 2025/05/09 13:46:31 adam Exp $
 
-BLAKE2s (postgresql-14.17.tar.bz2) = e8f6c923f81e4c0cb263d91836bf2dd79557d09245a184b67c8705be0fbde854
-SHA512 (postgresql-14.17.tar.bz2) = 1cb7d16fbfbceaa6bf0acd4cf9bea3e8fc078fcc6c1f7baad1d66040e1467f59ac54858b11a26543b50e25d3f0db47e0c72539cde743c794d41fa9d2f97c22c1
-Size (postgresql-14.17.tar.bz2) = 22488812 bytes
+BLAKE2s (postgresql-14.18.tar.bz2) = 7b4726f21d07517d26468b3977c8ef1d7fa539e0ba15a3bc0157beff76794d7b
+SHA512 (postgresql-14.18.tar.bz2) = fe40ba9fcc001f8c7eb3557c6248fa42af82b487ea4f31b8b20f5fa7ab930246659a4c8cf0bfa9a52f5143c766c0660d36b092474d2909020114ea3a1810adfd
+Size (postgresql-14.18.tar.bz2) = 22503241 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.28 pkgsrc/databases/postgresql14-client/Makefile:1.29
--- pkgsrc/databases/postgresql14-client/Makefile:1.28  Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-client/Makefile       Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.29 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-client-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-client/PLIST
diff -u pkgsrc/databases/postgresql14-client/PLIST:1.4 pkgsrc/databases/postgresql14-client/PLIST:1.5
--- pkgsrc/databases/postgresql14-client/PLIST:1.4      Sat Nov 16 10:13:48 2024
+++ pkgsrc/databases/postgresql14-client/PLIST  Fri May  9 13:46:31 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2024/11/16 10:13:48 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2025/05/09 13:46:31 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -463,6 +463,7 @@ include/postgresql/server/libpq/be-gssap
 include/postgresql/server/libpq/crypt.h
 include/postgresql/server/libpq/hba.h
 include/postgresql/server/libpq/ifaddr.h
+include/postgresql/server/libpq/libpq-be-fe-helpers.h
 include/postgresql/server/libpq/libpq-be.h
 include/postgresql/server/libpq/libpq-fs.h
 include/postgresql/server/libpq/libpq.h

Index: pkgsrc/databases/postgresql14-contrib/Makefile
diff -u pkgsrc/databases/postgresql14-contrib/Makefile:1.23 pkgsrc/databases/postgresql14-contrib/Makefile:1.24
--- pkgsrc/databases/postgresql14-contrib/Makefile:1.23 Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-contrib/Makefile      Fri May  9 13:46:31 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2025/05/09 13:46:31 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-contrib-/}
-PKGREVISION=   2
 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.22 pkgsrc/databases/postgresql14-docs/Makefile:1.23
--- pkgsrc/databases/postgresql14-docs/Makefile:1.22    Thu Apr 17 21:50:08 2025
+++ pkgsrc/databases/postgresql14-docs/Makefile Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2025/04/17 21:50:08 wiz Exp $
+# $NetBSD: Makefile,v 1.23 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-docs/PLIST
diff -u pkgsrc/databases/postgresql14-docs/PLIST:1.18 pkgsrc/databases/postgresql14-docs/PLIST:1.19
--- pkgsrc/databases/postgresql14-docs/PLIST:1.18       Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql14-docs/PLIST    Fri May  9 13:46:32 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2025/02/21 17:29:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2025/05/09 13:46:32 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -995,6 +995,7 @@ share/doc/postgresql/html/release-14-14.
 share/doc/postgresql/html/release-14-15.html
 share/doc/postgresql/html/release-14-16.html
 share/doc/postgresql/html/release-14-17.html
+share/doc/postgresql/html/release-14-18.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.28 pkgsrc/databases/postgresql14-plperl/Makefile:1.29
--- pkgsrc/databases/postgresql14-plperl/Makefile:1.28  Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-plperl/Makefile       Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.28 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.29 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plperl-/}
-PKGREVISION=   2
 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.25 pkgsrc/databases/postgresql14-plpython/Makefile:1.26
--- pkgsrc/databases/postgresql14-plpython/Makefile:1.25        Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-plpython/Makefile     Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.26 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plpython-/}
-PKGREVISION=   2
 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.23 pkgsrc/databases/postgresql14-pltcl/Makefile:1.24
--- pkgsrc/databases/postgresql14-pltcl/Makefile:1.23   Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-pltcl/Makefile        Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-pltcl-/}
-PKGREVISION=   2
 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.23 pkgsrc/databases/postgresql14-server/Makefile:1.24
--- pkgsrc/databases/postgresql14-server/Makefile:1.23  Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql14-server/Makefile       Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.24 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-server-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql14-server/PLIST
diff -u pkgsrc/databases/postgresql14-server/PLIST:1.7 pkgsrc/databases/postgresql14-server/PLIST:1.8
--- pkgsrc/databases/postgresql14-server/PLIST:1.7      Fri May 10 07:45:46 2024
+++ pkgsrc/databases/postgresql14-server/PLIST  Fri May  9 13:46:32 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2024/05/10 07:45:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2025/05/09 13:46:32 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -867,6 +867,7 @@ share/postgresql/timezone/America/Ciudad
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Coyhaique
 share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao

Index: pkgsrc/databases/postgresql15/Makefile
diff -u pkgsrc/databases/postgresql15/Makefile:1.17 pkgsrc/databases/postgresql15/Makefile:1.18
--- pkgsrc/databases/postgresql15/Makefile:1.17 Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql15/Makefile      Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.18 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-/}
-PKGREVISION=   2
 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.16 pkgsrc/databases/postgresql15/Makefile.common:1.17
--- pkgsrc/databases/postgresql15/Makefile.common:1.16  Sun Mar 30 21:10:40 2025
+++ pkgsrc/databases/postgresql15/Makefile.common       Fri May  9 13:46:32 2025
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2025/03/30 21:10:40 wiz Exp $
+# $NetBSD: Makefile.common,v 1.17 2025/05/09 13:46:32 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.12
+DISTNAME=      postgresql-15.13
 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.13 pkgsrc/databases/postgresql15/distinfo:1.14
--- pkgsrc/databases/postgresql15/distinfo:1.13 Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql15/distinfo      Fri May  9 13:46:32 2025
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.13 2025/02/21 17:29:07 adam Exp $
+$NetBSD: distinfo,v 1.14 2025/05/09 13:46:32 adam Exp $
 
-BLAKE2s (postgresql-15.12.tar.bz2) = 4d83a84095e1abd29d48aee79a8b4886d5753dd3a51b24501a754ed3d891cdd0
-SHA512 (postgresql-15.12.tar.bz2) = 6ccb44cb7ff2133ccb03dfc6b49e26714d9aecb91f4b9d019a8f1e7d0d71ed0bf8101fbbda0185091e4688a557600f020a12306c389e819d731184c17e182717
-Size (postgresql-15.12.tar.bz2) = 23170228 bytes
+BLAKE2s (postgresql-15.13.tar.bz2) = ae7a51d31fbca182c420246c1bb38fdf5f7b6b666887a97efee780b80e51cbce
+SHA512 (postgresql-15.13.tar.bz2) = dd16bc331f6e33cd8ba7a6f19582d4e94d66e4cf4b89b8fe1872f16854401b9f7caf0900478b64a05047d22d2ca07aea5ba71fd5c96fa04bd45713235acdd686
+Size (postgresql-15.13.tar.bz2) = 23190593 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.17 pkgsrc/databases/postgresql15-client/Makefile:1.18
--- pkgsrc/databases/postgresql15-client/Makefile:1.17  Sat Apr 19 07:57:37 2025
+++ pkgsrc/databases/postgresql15-client/Makefile       Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2025/04/19 07:57:37 wiz Exp $
+# $NetBSD: Makefile,v 1.18 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-client-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-client/PLIST
diff -u pkgsrc/databases/postgresql15-client/PLIST:1.4 pkgsrc/databases/postgresql15-client/PLIST:1.5
--- pkgsrc/databases/postgresql15-client/PLIST:1.4      Sat Nov 16 10:13:49 2024
+++ pkgsrc/databases/postgresql15-client/PLIST  Fri May  9 13:46:32 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2024/11/16 10:13:49 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2025/05/09 13:46:32 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -474,6 +474,7 @@ include/postgresql/server/libpq/be-gssap
 include/postgresql/server/libpq/crypt.h
 include/postgresql/server/libpq/hba.h
 include/postgresql/server/libpq/ifaddr.h
+include/postgresql/server/libpq/libpq-be-fe-helpers.h
 include/postgresql/server/libpq/libpq-be.h
 include/postgresql/server/libpq/libpq-fs.h
 include/postgresql/server/libpq/libpq.h

Index: pkgsrc/databases/postgresql15-contrib/Makefile
diff -u pkgsrc/databases/postgresql15-contrib/Makefile:1.16 pkgsrc/databases/postgresql15-contrib/Makefile:1.17
--- pkgsrc/databases/postgresql15-contrib/Makefile:1.16 Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql15-contrib/Makefile      Fri May  9 13:46:32 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.17 2025/05/09 13:46:32 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-contrib-/}
-PKGREVISION=   2
 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.15 pkgsrc/databases/postgresql15-docs/Makefile:1.16
--- pkgsrc/databases/postgresql15-docs/Makefile:1.15    Thu Apr 17 21:50:08 2025
+++ pkgsrc/databases/postgresql15-docs/Makefile Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.15 2025/04/17 21:50:08 wiz Exp $
+# $NetBSD: Makefile,v 1.16 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-docs/PLIST
diff -u pkgsrc/databases/postgresql15-docs/PLIST:1.13 pkgsrc/databases/postgresql15-docs/PLIST:1.14
--- pkgsrc/databases/postgresql15-docs/PLIST:1.13       Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql15-docs/PLIST    Fri May  9 13:46:33 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.13 2025/02/21 17:29:07 adam Exp $
+@comment $NetBSD: PLIST,v 1.14 2025/05/09 13:46:33 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1003,6 +1003,7 @@ share/doc/postgresql/html/release-15-1.h
 share/doc/postgresql/html/release-15-10.html
 share/doc/postgresql/html/release-15-11.html
 share/doc/postgresql/html/release-15-12.html
+share/doc/postgresql/html/release-15-13.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.20 pkgsrc/databases/postgresql15-plperl/Makefile:1.21
--- pkgsrc/databases/postgresql15-plperl/Makefile:1.20  Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql15-plperl/Makefile       Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plperl-/}
-PKGREVISION=   2
 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.17 pkgsrc/databases/postgresql15-plpython/Makefile:1.18
--- pkgsrc/databases/postgresql15-plpython/Makefile:1.17        Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql15-plpython/Makefile     Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.18 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plpython-/}
-PKGREVISION=   2
 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.16 pkgsrc/databases/postgresql15-pltcl/Makefile:1.17
--- pkgsrc/databases/postgresql15-pltcl/Makefile:1.16   Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql15-pltcl/Makefile        Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.17 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-pltcl-/}
-PKGREVISION=   2
 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.16 pkgsrc/databases/postgresql15-server/Makefile:1.17
--- pkgsrc/databases/postgresql15-server/Makefile:1.16  Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql15-server/Makefile       Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.17 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-server-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql15-server/PLIST
diff -u pkgsrc/databases/postgresql15-server/PLIST:1.6 pkgsrc/databases/postgresql15-server/PLIST:1.7
--- pkgsrc/databases/postgresql15-server/PLIST:1.6      Fri May 10 07:45:46 2024
+++ pkgsrc/databases/postgresql15-server/PLIST  Fri May  9 13:46:33 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2024/05/10 07:45:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2025/05/09 13:46:33 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -905,6 +905,7 @@ share/postgresql/timezone/America/Ciudad
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Coyhaique
 share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao

Index: pkgsrc/databases/postgresql16/Makefile
diff -u pkgsrc/databases/postgresql16/Makefile:1.12 pkgsrc/databases/postgresql16/Makefile:1.13
--- pkgsrc/databases/postgresql16/Makefile:1.12 Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql16/Makefile      Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.13 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-/}
-PKGREVISION=   2
 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.14 pkgsrc/databases/postgresql16/Makefile.common:1.15
--- pkgsrc/databases/postgresql16/Makefile.common:1.14  Tue May  6 09:51:14 2025
+++ pkgsrc/databases/postgresql16/Makefile.common       Fri May  9 13:46:33 2025
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.14 2025/05/06 09:51:14 wiz Exp $
+# $NetBSD: Makefile.common,v 1.15 2025/05/09 13:46:33 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.8
+DISTNAME=      postgresql-16.9
 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.10 pkgsrc/databases/postgresql16/distinfo:1.11
--- pkgsrc/databases/postgresql16/distinfo:1.10 Fri Feb 21 17:29:07 2025
+++ pkgsrc/databases/postgresql16/distinfo      Fri May  9 13:46:33 2025
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.10 2025/02/21 17:29:07 adam Exp $
+$NetBSD: distinfo,v 1.11 2025/05/09 13:46:33 adam Exp $
 
-BLAKE2s (postgresql-16.8.tar.bz2) = 5123e10a98023c905021898d6eb3758ec823d443f428314b149792f17ac2b720
-SHA512 (postgresql-16.8.tar.bz2) = f44fdfe01fbf82f3ffe4c9fc860bd27e06dddfe43b6bd6d1c6e267d64086eb5517e23cc1b2b8895cb73e63fce76779993ea9785a97e6e348ed91b4c08bb0492d
-Size (postgresql-16.8.tar.bz2) = 24911337 bytes
+BLAKE2s (postgresql-16.9.tar.bz2) = 55b0060476d268a46985895ee3b5eb8ade4b9b183c685bce48bb377d643ccce8
+SHA512 (postgresql-16.9.tar.bz2) = 23a3d983c5be49c3daabbbde35db2920bd2e2ba8d9baba805e7908da1f43153ff438c76c253ea8ee8ac6f8a9313fbf0348a1e9b45ef530c5e156fee0daceb814
+Size (postgresql-16.9.tar.bz2) = 24936316 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = 3392111516ca65ad7980ee39246c4210ec020c34

Index: pkgsrc/databases/postgresql16-client/Makefile
diff -u pkgsrc/databases/postgresql16-client/Makefile:1.13 pkgsrc/databases/postgresql16-client/Makefile:1.14
--- pkgsrc/databases/postgresql16-client/Makefile:1.13  Thu Apr 17 21:50:09 2025
+++ pkgsrc/databases/postgresql16-client/Makefile       Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2025/04/17 21:50:09 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql16/Makefile.common"

Index: pkgsrc/databases/postgresql16-contrib/Makefile
diff -u pkgsrc/databases/postgresql16-contrib/Makefile:1.11 pkgsrc/databases/postgresql16-contrib/Makefile:1.12
--- pkgsrc/databases/postgresql16-contrib/Makefile:1.11 Thu Apr 17 21:50:09 2025
+++ pkgsrc/databases/postgresql16-contrib/Makefile      Fri May  9 13:46:33 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2025/04/17 21:50:09 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2025/05/09 13:46:33 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-contrib-/}
-PKGREVISION=   1
 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.11 pkgsrc/databases/postgresql16-docs/Makefile:1.12
--- pkgsrc/databases/postgresql16-docs/Makefile:1.11    Thu Apr 17 21:50:09 2025
+++ pkgsrc/databases/postgresql16-docs/Makefile Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2025/04/17 21:50:09 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql16/Makefile.common"

Index: pkgsrc/databases/postgresql16-docs/PLIST
diff -u pkgsrc/databases/postgresql16-docs/PLIST:1.9 pkgsrc/databases/postgresql16-docs/PLIST:1.10
--- pkgsrc/databases/postgresql16-docs/PLIST:1.9        Fri Feb 21 17:29:08 2025
+++ pkgsrc/databases/postgresql16-docs/PLIST    Fri May  9 13:46:34 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2025/02/21 17:29:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2025/05/09 13:46:34 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1006,6 +1006,7 @@ share/doc/postgresql/html/release-16-5.h
 share/doc/postgresql/html/release-16-6.html
 share/doc/postgresql/html/release-16-7.html
 share/doc/postgresql/html/release-16-8.html
+share/doc/postgresql/html/release-16-9.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.13 pkgsrc/databases/postgresql16-plperl/Makefile:1.14
--- pkgsrc/databases/postgresql16-plperl/Makefile:1.13  Thu Apr 17 21:50:09 2025
+++ pkgsrc/databases/postgresql16-plperl/Makefile       Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2025/04/17 21:50:09 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2025/05/09 13:46:34 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/postgresql16-plpython/Makefile
diff -u pkgsrc/databases/postgresql16-plpython/Makefile:1.11 pkgsrc/databases/postgresql16-plpython/Makefile:1.12
--- pkgsrc/databases/postgresql16-plpython/Makefile:1.11        Thu Apr 17 21:50:09 2025
+++ pkgsrc/databases/postgresql16-plpython/Makefile     Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2025/04/17 21:50:09 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-plpython-/}
-PKGREVISION=   1
 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.11 pkgsrc/databases/postgresql16-pltcl/Makefile:1.12
--- pkgsrc/databases/postgresql16-pltcl/Makefile:1.11   Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql16-pltcl/Makefile        Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.12 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-pltcl-/}
-PKGREVISION=   1
 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.12 pkgsrc/databases/postgresql16-server/Makefile:1.13
--- pkgsrc/databases/postgresql16-server/Makefile:1.12  Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql16-server/Makefile       Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.13 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/16-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql16-server/PLIST
diff -u pkgsrc/databases/postgresql16-server/PLIST:1.3 pkgsrc/databases/postgresql16-server/PLIST:1.4
--- pkgsrc/databases/postgresql16-server/PLIST:1.3      Tue May  6 09:51:15 2025
+++ pkgsrc/databases/postgresql16-server/PLIST  Fri May  9 13:46:34 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2025/05/06 09:51:15 wiz Exp $
+@comment $NetBSD: PLIST,v 1.4 2025/05/09 13:46:34 adam Exp $
 bin/postgres
 include/postgresql/server/plpgsql.h
 ${PLIST.llvm}lib/postgresql/bitcode/postgres.index.bc
@@ -925,6 +925,7 @@ share/postgresql/timezone/America/Ciudad
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Coyhaique
 share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao

Index: pkgsrc/databases/postgresql17/Makefile
diff -u pkgsrc/databases/postgresql17/Makefile:1.5 pkgsrc/databases/postgresql17/Makefile:1.6
--- pkgsrc/databases/postgresql17/Makefile:1.5  Sat Apr 19 07:57:38 2025
+++ pkgsrc/databases/postgresql17/Makefile      Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2025/04/19 07:57:38 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-/}
-PKGREVISION=   2
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql17-client>=${PKGVERSION_NOREV}:../../databases/postgresql17-client
Index: pkgsrc/databases/postgresql17/distinfo
diff -u pkgsrc/databases/postgresql17/distinfo:1.5 pkgsrc/databases/postgresql17/distinfo:1.6
--- pkgsrc/databases/postgresql17/distinfo:1.5  Fri Feb 21 17:29:08 2025
+++ pkgsrc/databases/postgresql17/distinfo      Fri May  9 13:46:34 2025
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.5 2025/02/21 17:29:08 adam Exp $
+$NetBSD: distinfo,v 1.6 2025/05/09 13:46:34 adam Exp $
 
-BLAKE2s (postgresql-17.4.tar.bz2) = 9ed89eb346e2f6e7c34da0441663ff63bccab476fe7fb82a14a71a6bf8d36d92
-SHA512 (postgresql-17.4.tar.bz2) = 43288a297c753d075405a7bd3fce17f6a260d6b0a80a156c1e6267e0ebd40c85b7bb929e893956a109eda4d93fa8936f43e981242c1fd67a91012cba5472026c
-Size (postgresql-17.4.tar.bz2) = 21519810 bytes
+BLAKE2s (postgresql-17.5.tar.bz2) = 5473893389d0871d8e3ab7813cc6042bf4c130c781a6009868c291515ea362f6
+SHA512 (postgresql-17.5.tar.bz2) = deae865e6c8e2ef5bb622288f790c5b83d22235496513e60351354970ff193eb885fb632c2d1321b8311c88c05b76a370d8d838473936c8438dbb569086b139f
+Size (postgresql-17.5.tar.bz2) = 21595174 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 9c4bf707b6aded63b2e0cff375465693cad1dea9
 SHA1 (patch-configure) = beebdd7d46e37065c86d7edbfb982bac1fbc9147

Index: pkgsrc/databases/postgresql17/Makefile.common
diff -u pkgsrc/databases/postgresql17/Makefile.common:1.10 pkgsrc/databases/postgresql17/Makefile.common:1.11
--- pkgsrc/databases/postgresql17/Makefile.common:1.10  Tue May  6 12:07:25 2025
+++ pkgsrc/databases/postgresql17/Makefile.common       Fri May  9 13:46:34 2025
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2025/05/06 12:07:25 wiz Exp $
+# $NetBSD: Makefile.common,v 1.11 2025/05/09 13:46:34 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.4
+DISTNAME=      postgresql-17.5
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql17-client/Makefile
diff -u pkgsrc/databases/postgresql17-client/Makefile:1.6 pkgsrc/databases/postgresql17-client/Makefile:1.7
--- pkgsrc/databases/postgresql17-client/Makefile:1.6   Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-client/Makefile       Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.7 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-client-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql17/Makefile.common"

Index: pkgsrc/databases/postgresql17-contrib/Makefile
diff -u pkgsrc/databases/postgresql17-contrib/Makefile:1.5 pkgsrc/databases/postgresql17-contrib/Makefile:1.6
--- pkgsrc/databases/postgresql17-contrib/Makefile:1.5  Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-contrib/Makefile      Fri May  9 13:46:34 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2025/05/09 13:46:34 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-contrib-/}
-PKGREVISION=   2
 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.5 pkgsrc/databases/postgresql17-docs/Makefile:1.6
--- pkgsrc/databases/postgresql17-docs/Makefile:1.5     Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-docs/Makefile Fri May  9 13:46:35 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2025/05/09 13:46:35 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-docs-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql17/Makefile.common"
Index: pkgsrc/databases/postgresql17-docs/PLIST
diff -u pkgsrc/databases/postgresql17-docs/PLIST:1.5 pkgsrc/databases/postgresql17-docs/PLIST:1.6
--- pkgsrc/databases/postgresql17-docs/PLIST:1.5        Fri Feb 21 17:29:08 2025
+++ pkgsrc/databases/postgresql17-docs/PLIST    Fri May  9 13:46:35 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2025/02/21 17:29:08 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2025/05/09 13:46:35 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -986,6 +986,7 @@ share/doc/postgresql/html/release-17-1.h
 share/doc/postgresql/html/release-17-2.html
 share/doc/postgresql/html/release-17-3.html
 share/doc/postgresql/html/release-17-4.html
+share/doc/postgresql/html/release-17-5.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.7 pkgsrc/databases/postgresql17-plperl/Makefile:1.8
--- pkgsrc/databases/postgresql17-plperl/Makefile:1.7   Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-plperl/Makefile       Fri May  9 13:46:35 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.8 2025/05/09 13:46:35 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-plperl-/}
-PKGREVISION=   2
 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.5 pkgsrc/databases/postgresql17-plpython/Makefile:1.6
--- pkgsrc/databases/postgresql17-plpython/Makefile:1.5 Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-plpython/Makefile     Fri May  9 13:46:35 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2025/05/09 13:46:35 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-plpython-/}
-PKGREVISION=   2
 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.5 pkgsrc/databases/postgresql17-pltcl/Makefile:1.6
--- pkgsrc/databases/postgresql17-pltcl/Makefile:1.5    Thu Apr 17 21:50:10 2025
+++ pkgsrc/databases/postgresql17-pltcl/Makefile        Fri May  9 13:46:35 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2025/04/17 21:50:10 wiz Exp $
+# $NetBSD: Makefile,v 1.6 2025/05/09 13:46:35 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-pltcl-/}
-PKGREVISION=   2
 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.6 pkgsrc/databases/postgresql17-server/Makefile:1.7
--- pkgsrc/databases/postgresql17-server/Makefile:1.6   Thu Apr 17 21:50:11 2025
+++ pkgsrc/databases/postgresql17-server/Makefile       Fri May  9 13:46:35 2025
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2025/04/17 21:50:11 wiz Exp $
+# $NetBSD: Makefile,v 1.7 2025/05/09 13:46:35 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/17-server-/}
-PKGREVISION=   2
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql17-server/PLIST
diff -u pkgsrc/databases/postgresql17-server/PLIST:1.3 pkgsrc/databases/postgresql17-server/PLIST:1.4
--- pkgsrc/databases/postgresql17-server/PLIST:1.3      Tue May  6 12:07:26 2025
+++ pkgsrc/databases/postgresql17-server/PLIST  Fri May  9 13:46:35 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2025/05/06 12:07:26 wiz Exp $
+@comment $NetBSD: PLIST,v 1.4 2025/05/09 13:46:35 adam Exp $
 bin/postgres
 include/postgresql/server/plpgsql.h
 ${PLIST.llvm}lib/postgresql/bitcode/postgres.index.bc
@@ -937,6 +937,7 @@ share/postgresql/timezone/America/Ciudad
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica
+share/postgresql/timezone/America/Coyhaique
 share/postgresql/timezone/America/Creston
 share/postgresql/timezone/America/Cuiaba
 share/postgresql/timezone/America/Curacao

Prev by Date: CVS commit: pkgsrc/doc
Next by Date: CVS commit: pkgsrc/doc
Previous by Thread: CVS commit: pkgsrc/doc
Next by Thread: CVS commit: pkgsrc/doc
Indexes:

Home | Main Index | Thread Index | Old Index