CVS commit: pkgsrc/databases

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc/databases
From: "Adam Ciarcinski" <adam%netbsd.org@localhost>
Date: Wed, 15 Feb 2023 20:51:02 +0000

Module Name:    pkgsrc
Committed By:   adam
Date:           Wed Feb 15 20:51:02 UTC 2023

Modified Files:
        pkgsrc/databases/postgresql11: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql11-client: Makefile
        pkgsrc/databases/postgresql11-contrib: Makefile
        pkgsrc/databases/postgresql11-docs: Makefile PLIST
        pkgsrc/databases/postgresql11-plperl: Makefile
        pkgsrc/databases/postgresql11-plpython: Makefile
        pkgsrc/databases/postgresql11-pltcl: Makefile
        pkgsrc/databases/postgresql11-server: Makefile PLIST
        pkgsrc/databases/postgresql11/patches: patch-src_pl_plperl_plperl.h
        pkgsrc/databases/postgresql12: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql12-client: Makefile
        pkgsrc/databases/postgresql12-contrib: Makefile
        pkgsrc/databases/postgresql12-docs: Makefile PLIST
        pkgsrc/databases/postgresql12-plperl: Makefile
        pkgsrc/databases/postgresql12-plpython: Makefile
        pkgsrc/databases/postgresql12-pltcl: Makefile
        pkgsrc/databases/postgresql12-server: Makefile PLIST
        pkgsrc/databases/postgresql12/patches: patch-src_pl_plperl_plperl.h
        pkgsrc/databases/postgresql13: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql13-client: Makefile
        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-src_pl_plperl_plperl.h
        pkgsrc/databases/postgresql14: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql14-client: Makefile
        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/postgresql14/patches: patch-src_pl_plperl_plperl.h
        pkgsrc/databases/postgresql15: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql15-client: Makefile
        pkgsrc/databases/postgresql15-contrib: Makefile PLIST
        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/postgresql15/patches: patch-src_pl_plperl_plperl.h

Log Message:
postgresql: updated to 15.2, 14.7, 13.10, 12.14, and 11.19

Security Issues

CVE-2022-41862: Client memory disclosure when connecting, with Kerberos, to modified server.

Versions Affected: 12 - 15.

A modified, unauthenticated server or an unauthenticated man-in-the-middle can send an unterminated string during the establishment of Kerberos transport encryption. When a libpq client application 
has a Kerberos credential cache and doesn't explicitly disable option gssencmode, a server can cause libpq to over-read and report an error message containing uninitialized bytes from and following 
its receive buffer. If libpq's caller somehow makes that message accessible to the attacker, this achieves a disclosure of the over-read bytes. We have not confirmed or ruled out viability of attacks 
that arrange for a crash or for presence of notable, confidential information in disclosed bytes.

The PostgreSQL project thanks Jacob Champion for reporting this problem.

Bug Fixes and Improvements

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

Included in this release:

Fix for partitioned tables to correctly update GENERATED columns in child tables if the GENERATED column does not exist in the parent table or the child generated column has different dependencies 
than the parent.
Several fixes for the MERGE command.
Allow a WITH RECURSIVE ... CYCLE query to access its SET output column.
Fix an issue with bulk insertions on foreign tables that could lead to logical inconsistencies, for example, a BEFORE ROW trigger may not process rows that should be available.
Reject uses of undefined variables in jsonpath existence checks.
Fix for jsonb subscripting that come directly from a text column in a table.
Honor updated values of checkpoint_completion_target on reload.
Log the correct ending timestamp in recovery_target_xid mode.
Fix issue to allow column lists longer than 100 when using logical replication.
Prevent "wrong tuple length" failure at the end of VACUUM.
Avoid an immediate commit after ANALYZE when using query pipelining.
Several fixes to the query planner, including one that provides more opportunities for using memoization with partitionwise joins.
Fix for statistics collection to correctly handle when a relation changes type (e.g. a table is converted to a view).
Ensure full text search queries can be cancelled while performing phrase matches.
Fix deadlock between DROP DATABASE and logical replication worker process.
Fix small session-lifespan memory leak when CREATE SUBSCRIPTION fails its connection attempt.
Performance improvement for replicas with hot_standby enabled that are processing SELECT queries.
Several fixes for logical decoding that improve its stability and bloat handling.
Fix the default logical replication plug-in, pgoutput, to not send columns that are not listed in a table's replication column list.
Fix possible corruption of very large tablespace map files in pg_basebackup.
Remove a harmless warning from pg_dump in --if-exists mode when the public schema has a non-default owner.
Fix the psql commands \sf and \ef to handle SQL-language functions that have SQL-standard function bodies (i.e. BEGIN ATOMIC).
Fix tab completion of ALTER FUNCTION/PROCEDURE/ROUTINE ... SET SCHEMA.
Update the pageinspect extension to mark its disk-accessing functions as PARALLEL RESTRICTED.
Fix the seg extension to not crash or print garbage if an input number has more than 127 digits.


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

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

Modified files:

Index: pkgsrc/databases/postgresql11/Makefile
diff -u pkgsrc/databases/postgresql11/Makefile:1.26 pkgsrc/databases/postgresql11/Makefile:1.27
--- pkgsrc/databases/postgresql11/Makefile:1.26 Wed Nov 23 16:19:38 2022
+++ pkgsrc/databases/postgresql11/Makefile      Wed Feb 15 20:50:56 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.26 2022/11/23 16:19:38 adam Exp $
+# $NetBSD: Makefile,v 1.27 2023/02/15 20:50:56 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql11-client>=${PKGVERSION_NOREV}:../../databases/postgresql11-client

Index: pkgsrc/databases/postgresql11/Makefile.common
diff -u pkgsrc/databases/postgresql11/Makefile.common:1.31 pkgsrc/databases/postgresql11/Makefile.common:1.32
--- pkgsrc/databases/postgresql11/Makefile.common:1.31  Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql11/Makefile.common       Wed Feb 15 20:50:56 2023
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.31 2022/11/13 09:34:25 adam Exp $
+# $NetBSD: Makefile.common,v 1.32 2023/02/15 20:50:56 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql11-pltcl/Makefile
 # used by databases/postgresql11-server/Makefile
 
-DISTNAME=      postgresql-11.18
+DISTNAME=      postgresql-11.19
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql11/distinfo
diff -u pkgsrc/databases/postgresql11/distinfo:1.25 pkgsrc/databases/postgresql11/distinfo:1.26
--- pkgsrc/databases/postgresql11/distinfo:1.25 Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql11/distinfo      Wed Feb 15 20:50:56 2023
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.25 2022/11/13 09:34:25 adam Exp $
+$NetBSD: distinfo,v 1.26 2023/02/15 20:50:56 adam Exp $
 
-BLAKE2s (postgresql-11.18.tar.bz2) = f253b5805de3346c955da01667cd2c954363ff02ba9118f442868fcb1bda30e5
-SHA512 (postgresql-11.18.tar.bz2) = 17b4f9a0200814ae210076a677b9c68375d896bb1817b4f8b327ee208da9a1672625cdcbd213af2b01fe501a051436e9acf5cc9ed0a2b798f257d07b08cdf1b8
-Size (postgresql-11.18.tar.bz2) = 20428126 bytes
+BLAKE2s (postgresql-11.19.tar.bz2) = fb6f36b34a677ac8616cc746311917c82a59eaea2d14934335ae7ef0c746aa3a
+SHA512 (postgresql-11.19.tar.bz2) = 0b9247d82a0eaddd8254799197c3bef1ba47a633f616a556167ebcf956961a50955c11e98034a717fb77ff18987ccb8fd80b98588c2ec3c70fd2d62bc27fe05b
+Size (postgresql-11.19.tar.bz2) = 20457793 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
@@ -16,4 +16,4 @@ SHA1 (patch-src_fe__utils_Makefile) = 3c
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 0168f5bc105ffc89d5db40907a08966d8465f5a0
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 161a8f7af61b3a33b255fdee9fa7d4918decde7d
-SHA1 (patch-src_pl_plperl_plperl.h) = 2be5cbb71e5c5662a58b90058800ed67da0fb851
+SHA1 (patch-src_pl_plperl_plperl.h) = 5a16c23e2f091978eedd834378753d84f89902ef

Index: pkgsrc/databases/postgresql11-client/Makefile
diff -u pkgsrc/databases/postgresql11-client/Makefile:1.27 pkgsrc/databases/postgresql11-client/Makefile:1.28
--- pkgsrc/databases/postgresql11-client/Makefile:1.27  Wed Nov 23 16:19:38 2022
+++ pkgsrc/databases/postgresql11-client/Makefile       Wed Feb 15 20:50:56 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.27 2022/11/23 16:19:38 adam Exp $
+# $NetBSD: Makefile,v 1.28 2023/02/15 20:50:56 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql11/Makefile.common"

Index: pkgsrc/databases/postgresql11-contrib/Makefile
diff -u pkgsrc/databases/postgresql11-contrib/Makefile:1.24 pkgsrc/databases/postgresql11-contrib/Makefile:1.25
--- pkgsrc/databases/postgresql11-contrib/Makefile:1.24 Wed Nov 23 16:19:38 2022
+++ pkgsrc/databases/postgresql11-contrib/Makefile      Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2022/11/23 16:19:38 adam Exp $
+# $NetBSD: Makefile,v 1.25 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql11/Makefile.common"

Index: pkgsrc/databases/postgresql11-docs/Makefile
diff -u pkgsrc/databases/postgresql11-docs/Makefile:1.18 pkgsrc/databases/postgresql11-docs/Makefile:1.19
--- pkgsrc/databases/postgresql11-docs/Makefile:1.18    Wed Nov 23 16:19:38 2022
+++ pkgsrc/databases/postgresql11-docs/Makefile Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2022/11/23 16:19:38 adam Exp $
+# $NetBSD: Makefile,v 1.19 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql11/Makefile.common"

Index: pkgsrc/databases/postgresql11-docs/PLIST
diff -u pkgsrc/databases/postgresql11-docs/PLIST:1.19 pkgsrc/databases/postgresql11-docs/PLIST:1.20
--- pkgsrc/databases/postgresql11-docs/PLIST:1.19       Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql11-docs/PLIST    Wed Feb 15 20:50:57 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.19 2022/11/13 09:34:25 adam Exp $
+@comment $NetBSD: PLIST,v 1.20 2023/02/15 20:50:57 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -964,6 +964,7 @@ share/doc/postgresql/html/release-11-15.
 share/doc/postgresql/html/release-11-16.html
 share/doc/postgresql/html/release-11-17.html
 share/doc/postgresql/html/release-11-18.html
+share/doc/postgresql/html/release-11-19.html
 share/doc/postgresql/html/release-11-2.html
 share/doc/postgresql/html/release-11-3.html
 share/doc/postgresql/html/release-11-4.html

Index: pkgsrc/databases/postgresql11-plperl/Makefile
diff -u pkgsrc/databases/postgresql11-plperl/Makefile:1.22 pkgsrc/databases/postgresql11-plperl/Makefile:1.23
--- pkgsrc/databases/postgresql11-plperl/Makefile:1.22  Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql11-plperl/Makefile       Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.23 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server

Index: pkgsrc/databases/postgresql11-plpython/Makefile
diff -u pkgsrc/databases/postgresql11-plpython/Makefile:1.26 pkgsrc/databases/postgresql11-plpython/Makefile:1.27
--- pkgsrc/databases/postgresql11-plpython/Makefile:1.26        Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql11-plpython/Makefile     Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.26 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.27 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server

Index: pkgsrc/databases/postgresql11-pltcl/Makefile
diff -u pkgsrc/databases/postgresql11-pltcl/Makefile:1.22 pkgsrc/databases/postgresql11-pltcl/Makefile:1.23
--- pkgsrc/databases/postgresql11-pltcl/Makefile:1.22   Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql11-pltcl/Makefile        Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.23 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql11-server>=${PKGVERSION_NOREV}:../../databases/postgresql11-server

Index: pkgsrc/databases/postgresql11-server/Makefile
diff -u pkgsrc/databases/postgresql11-server/Makefile:1.25 pkgsrc/databases/postgresql11-server/Makefile:1.26
--- pkgsrc/databases/postgresql11-server/Makefile:1.25  Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql11-server/Makefile       Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.26 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql11-server/PLIST
diff -u pkgsrc/databases/postgresql11-server/PLIST:1.7 pkgsrc/databases/postgresql11-server/PLIST:1.8
--- pkgsrc/databases/postgresql11-server/PLIST:1.7      Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql11-server/PLIST  Wed Feb 15 20:50:57 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:25 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2023/02/15 20:50:57 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -822,6 +822,7 @@ share/postgresql/timezone/America/Cayenn
 share/postgresql/timezone/America/Cayman
 share/postgresql/timezone/America/Chicago
 share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Ciudad_Juarez
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica

Index: pkgsrc/databases/postgresql11/patches/patch-src_pl_plperl_plperl.h
diff -u pkgsrc/databases/postgresql11/patches/patch-src_pl_plperl_plperl.h:1.1 pkgsrc/databases/postgresql11/patches/patch-src_pl_plperl_plperl.h:1.2
--- pkgsrc/databases/postgresql11/patches/patch-src_pl_plperl_plperl.h:1.1      Tue Oct 23 16:02:51 2018
+++ pkgsrc/databases/postgresql11/patches/patch-src_pl_plperl_plperl.h  Wed Feb 15 20:50:56 2023
@@ -1,8 +1,8 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2018/10/23 16:02:51 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2023/02/15 20:50:56 adam Exp $
 
---- src/pl/plperl/plperl.h.orig        2018-10-15 21:12:02.000000000 +0000
+--- src/pl/plperl/plperl.h.orig        2023-02-06 21:46:39.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -55,6 +55,10 @@
+@@ -57,6 +57,11 @@
  #define HAS_BOOL 1
  #endif
  
@@ -10,10 +10,11 @@ $NetBSD: patch-src_pl_plperl_plperl.h,v 
 +#define list_head sun_list_head
 +#define list_tail sun_list_tail
 +#endif
- 
++
  /*
-  * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -98,6 +102,11 @@
+  * Newer versions of the perl headers trigger a lot of warnings with our
+  * compiler flags (at least -Wdeclaration-after-statement,
+@@ -109,6 +114,11 @@
  #include "XSUB.h"
  #endif
  

Index: pkgsrc/databases/postgresql12/Makefile
diff -u pkgsrc/databases/postgresql12/Makefile:1.25 pkgsrc/databases/postgresql12/Makefile:1.26
--- pkgsrc/databases/postgresql12/Makefile:1.25 Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql12/Makefile      Wed Feb 15 20:50:57 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.25 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.26 2023/02/15 20:50:57 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql12-client>=${PKGVERSION_NOREV}:../../databases/postgresql12-client

Index: pkgsrc/databases/postgresql12/Makefile.common
diff -u pkgsrc/databases/postgresql12/Makefile.common:1.24 pkgsrc/databases/postgresql12/Makefile.common:1.25
--- pkgsrc/databases/postgresql12/Makefile.common:1.24  Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql12/Makefile.common       Wed Feb 15 20:50:57 2023
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.24 2022/11/13 09:34:25 adam Exp $
+# $NetBSD: Makefile.common,v 1.25 2023/02/15 20:50:57 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql12-pltcl/Makefile
 # used by databases/postgresql12-server/Makefile
 
-DISTNAME=      postgresql-12.13
+DISTNAME=      postgresql-12.14
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql12/distinfo
diff -u pkgsrc/databases/postgresql12/distinfo:1.18 pkgsrc/databases/postgresql12/distinfo:1.19
--- pkgsrc/databases/postgresql12/distinfo:1.18 Sun Nov 13 09:34:25 2022
+++ pkgsrc/databases/postgresql12/distinfo      Wed Feb 15 20:50:57 2023
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.18 2022/11/13 09:34:25 adam Exp $
+$NetBSD: distinfo,v 1.19 2023/02/15 20:50:57 adam Exp $
 
-BLAKE2s (postgresql-12.13.tar.bz2) = d844dbb61b463277f48de83b063d97f2c9b9d4e5c61018fc529b523f3992dbc6
-SHA512 (postgresql-12.13.tar.bz2) = a502236dcc4c56645dd57ed3c920d996adace3bc3a855c869344c8580393ad4c6ad17503928564683817066f6e9c5794f3d214b5f8e3b900ebb23474673bac24
-Size (postgresql-12.13.tar.bz2) = 21114311 bytes
+BLAKE2s (postgresql-12.14.tar.bz2) = 9a011737400ac72595f060933810f43168fb04dbe7349373b93d871cd782d529
+SHA512 (postgresql-12.14.tar.bz2) = a859067119cc21702ab1af6507bf703e4263d9399745cd7b025a3c73d55367ba0f960fd2b1b4af43e73b8448bb2e52555734d60a5f306041719190f28a8bd505
+Size (postgresql-12.14.tar.bz2) = 21124742 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
@@ -14,4 +14,4 @@ SHA1 (patch-src_backend_Makefile) = 736f
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 10bf43bee54a6a1b6086c1652076544b05bf0192
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 161a8f7af61b3a33b255fdee9fa7d4918decde7d
-SHA1 (patch-src_pl_plperl_plperl.h) = 4ea16bbb0f9f98a609e67ceb858f22cc77be89ae
+SHA1 (patch-src_pl_plperl_plperl.h) = cd25ac7fba4bce9fab34956d4ff374afc86be9d7

Index: pkgsrc/databases/postgresql12-client/Makefile
diff -u pkgsrc/databases/postgresql12-client/Makefile:1.29 pkgsrc/databases/postgresql12-client/Makefile:1.30
--- pkgsrc/databases/postgresql12-client/Makefile:1.29  Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql12-client/Makefile       Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.29 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.30 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql12/Makefile.common"

Index: pkgsrc/databases/postgresql12-contrib/Makefile
diff -u pkgsrc/databases/postgresql12-contrib/Makefile:1.24 pkgsrc/databases/postgresql12-contrib/Makefile:1.25
--- pkgsrc/databases/postgresql12-contrib/Makefile:1.24 Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql12-contrib/Makefile      Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.25 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql12/Makefile.common"

Index: pkgsrc/databases/postgresql12-docs/Makefile
diff -u pkgsrc/databases/postgresql12-docs/Makefile:1.18 pkgsrc/databases/postgresql12-docs/Makefile:1.19
--- pkgsrc/databases/postgresql12-docs/Makefile:1.18    Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql12-docs/Makefile Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.19 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql12/Makefile.common"

Index: pkgsrc/databases/postgresql12-docs/PLIST
diff -u pkgsrc/databases/postgresql12-docs/PLIST:1.14 pkgsrc/databases/postgresql12-docs/PLIST:1.15
--- pkgsrc/databases/postgresql12-docs/PLIST:1.14       Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql12-docs/PLIST    Wed Feb 15 20:50:58 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2022/11/13 09:34:26 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2023/02/15 20:50:58 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -967,6 +967,7 @@ share/doc/postgresql/html/release-12-10.
 share/doc/postgresql/html/release-12-11.html
 share/doc/postgresql/html/release-12-12.html
 share/doc/postgresql/html/release-12-13.html
+share/doc/postgresql/html/release-12-14.html
 share/doc/postgresql/html/release-12-2.html
 share/doc/postgresql/html/release-12-3.html
 share/doc/postgresql/html/release-12-4.html

Index: pkgsrc/databases/postgresql12-plperl/Makefile
diff -u pkgsrc/databases/postgresql12-plperl/Makefile:1.22 pkgsrc/databases/postgresql12-plperl/Makefile:1.23
--- pkgsrc/databases/postgresql12-plperl/Makefile:1.22  Wed Nov 23 16:19:39 2022
+++ pkgsrc/databases/postgresql12-plperl/Makefile       Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2022/11/23 16:19:39 adam Exp $
+# $NetBSD: Makefile,v 1.23 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server

Index: pkgsrc/databases/postgresql12-plpython/Makefile
diff -u pkgsrc/databases/postgresql12-plpython/Makefile:1.24 pkgsrc/databases/postgresql12-plpython/Makefile:1.25
--- pkgsrc/databases/postgresql12-plpython/Makefile:1.24        Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql12-plpython/Makefile     Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.25 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server

Index: pkgsrc/databases/postgresql12-pltcl/Makefile
diff -u pkgsrc/databases/postgresql12-pltcl/Makefile:1.22 pkgsrc/databases/postgresql12-pltcl/Makefile:1.23
--- pkgsrc/databases/postgresql12-pltcl/Makefile:1.22   Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql12-pltcl/Makefile        Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.22 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.23 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql12-server>=${PKGVERSION_NOREV}:../../databases/postgresql12-server

Index: pkgsrc/databases/postgresql12-server/Makefile
diff -u pkgsrc/databases/postgresql12-server/Makefile:1.24 pkgsrc/databases/postgresql12-server/Makefile:1.25
--- pkgsrc/databases/postgresql12-server/Makefile:1.24  Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql12-server/Makefile       Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.24 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.25 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql12-server/PLIST
diff -u pkgsrc/databases/postgresql12-server/PLIST:1.7 pkgsrc/databases/postgresql12-server/PLIST:1.8
--- pkgsrc/databases/postgresql12-server/PLIST:1.7      Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql12-server/PLIST  Wed Feb 15 20:50:58 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:26 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2023/02/15 20:50:58 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -838,6 +838,7 @@ share/postgresql/timezone/America/Cayenn
 share/postgresql/timezone/America/Cayman
 share/postgresql/timezone/America/Chicago
 share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Ciudad_Juarez
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica

Index: pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_plperl.h
diff -u pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_plperl.h:1.1 pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_plperl.h:1.2
--- pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_plperl.h:1.1      Mon Oct  7 19:21:48 2019
+++ pkgsrc/databases/postgresql12/patches/patch-src_pl_plperl_plperl.h  Wed Feb 15 20:50:57 2023
@@ -1,8 +1,8 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2019/10/07 19:21:48 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2023/02/15 20:50:57 adam Exp $
 
---- src/pl/plperl/plperl.h.orig        2019-09-30 20:06:55.000000000 +0000
+--- src/pl/plperl/plperl.h.orig        2023-02-06 21:45:00.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -68,6 +68,10 @@
+@@ -70,6 +70,11 @@
  #define HAS_BOOL 1
  #endif
  
@@ -10,10 +10,11 @@ $NetBSD: patch-src_pl_plperl_plperl.h,v 
 +#define list_head sun_list_head
 +#define list_tail sun_list_tail
 +#endif
- 
++
  /*
-  * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -110,6 +114,11 @@
+  * Newer versions of the perl headers trigger a lot of warnings with our
+  * compiler flags (at least -Wdeclaration-after-statement,
+@@ -121,6 +126,11 @@
  #include "XSUB.h"
  #endif
  

Index: pkgsrc/databases/postgresql13/Makefile
diff -u pkgsrc/databases/postgresql13/Makefile:1.16 pkgsrc/databases/postgresql13/Makefile:1.17
--- pkgsrc/databases/postgresql13/Makefile:1.16 Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13/Makefile      Wed Feb 15 20:50:58 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.17 2023/02/15 20:50:58 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql13-client>=${PKGVERSION_NOREV}:../../databases/postgresql13-client
Index: pkgsrc/databases/postgresql13/distinfo
diff -u pkgsrc/databases/postgresql13/distinfo:1.16 pkgsrc/databases/postgresql13/distinfo:1.17
--- pkgsrc/databases/postgresql13/distinfo:1.16 Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql13/distinfo      Wed Feb 15 20:50:58 2023
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.16 2022/11/13 09:34:26 adam Exp $
+$NetBSD: distinfo,v 1.17 2023/02/15 20:50:58 adam Exp $
 
-BLAKE2s (postgresql-13.9.tar.bz2) = 063a88e670c98acfa1f37c7819918f2563048d3c3e14ce1dc2c4f6d825ba4b2c
-SHA512 (postgresql-13.9.tar.bz2) = 7f226d917c97752a49bb603829789c02820d5a746e89bf879b63cad6ce22b0000762a2f5584af1a928fcb9a444abbf78f6fd8761898291830a21ac42b2d72858
-Size (postgresql-13.9.tar.bz2) = 21439045 bytes
+BLAKE2s (postgresql-13.10.tar.bz2) = 1f7860c9b5588818802ad120a755614095545665fb277105b174da829a1c3e84
+SHA512 (postgresql-13.10.tar.bz2) = 328c81f7c2ca2bad92fa62f4b0377d7cc104f294636db019c68ceccb580003eebe79455bbafa24eab2b3cce305e3d9c702a8544b38556f9c3431cc3c78d00cff
+Size (postgresql-13.10.tar.bz2) = 21457594 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
@@ -15,4 +15,4 @@ SHA1 (patch-src_fe__utils_Makefile) = c4
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 10bf43bee54a6a1b6086c1652076544b05bf0192
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 161a8f7af61b3a33b255fdee9fa7d4918decde7d
-SHA1 (patch-src_pl_plperl_plperl.h) = 4ea16bbb0f9f98a609e67ceb858f22cc77be89ae
+SHA1 (patch-src_pl_plperl_plperl.h) = 99f04b6a733a799a15e46a011697729be6be4717

Index: pkgsrc/databases/postgresql13/Makefile.common
diff -u pkgsrc/databases/postgresql13/Makefile.common:1.17 pkgsrc/databases/postgresql13/Makefile.common:1.18
--- pkgsrc/databases/postgresql13/Makefile.common:1.17  Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql13/Makefile.common       Wed Feb 15 20:50:58 2023
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2022/11/13 09:34:26 adam Exp $
+# $NetBSD: Makefile.common,v 1.18 2023/02/15 20:50:58 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.9
+DISTNAME=      postgresql-13.10
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql13-client/Makefile
diff -u pkgsrc/databases/postgresql13-client/Makefile:1.23 pkgsrc/databases/postgresql13-client/Makefile:1.24
--- pkgsrc/databases/postgresql13-client/Makefile:1.23  Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13-client/Makefile       Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.23 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.24 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql13/Makefile.common"

Index: pkgsrc/databases/postgresql13-contrib/Makefile
diff -u pkgsrc/databases/postgresql13-contrib/Makefile:1.17 pkgsrc/databases/postgresql13-contrib/Makefile:1.18
--- pkgsrc/databases/postgresql13-contrib/Makefile:1.17 Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13-contrib/Makefile      Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.18 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-contrib-/}
-PKGREVISION=   1
 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.14 pkgsrc/databases/postgresql13-docs/Makefile:1.15
--- pkgsrc/databases/postgresql13-docs/Makefile:1.14    Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13-docs/Makefile Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.15 2023/02/15 20:50:59 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.10 pkgsrc/databases/postgresql13-docs/PLIST:1.11
--- pkgsrc/databases/postgresql13-docs/PLIST:1.10       Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql13-docs/PLIST    Wed Feb 15 20:50:59 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2022/11/13 09:34:26 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2023/02/15 20:50:59 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -971,6 +971,7 @@ share/doc/postgresql/html/regress-tap.ht
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-13-1.html
+share/doc/postgresql/html/release-13-10.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.17 pkgsrc/databases/postgresql13-plperl/Makefile:1.18
--- pkgsrc/databases/postgresql13-plperl/Makefile:1.17  Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13-plperl/Makefile       Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.18 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-plpython/Makefile
diff -u pkgsrc/databases/postgresql13-plpython/Makefile:1.18 pkgsrc/databases/postgresql13-plpython/Makefile:1.19
--- pkgsrc/databases/postgresql13-plpython/Makefile:1.18        Wed Nov 23 16:19:40 2022
+++ pkgsrc/databases/postgresql13-plpython/Makefile     Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.18 2022/11/23 16:19:40 adam Exp $
+# $NetBSD: Makefile,v 1.19 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-pltcl/Makefile
diff -u pkgsrc/databases/postgresql13-pltcl/Makefile:1.16 pkgsrc/databases/postgresql13-pltcl/Makefile:1.17
--- pkgsrc/databases/postgresql13-pltcl/Makefile:1.16   Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql13-pltcl/Makefile        Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.17 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql13-server>=${PKGVERSION_NOREV}:../../databases/postgresql13-server

Index: pkgsrc/databases/postgresql13-server/Makefile
diff -u pkgsrc/databases/postgresql13-server/Makefile:1.16 pkgsrc/databases/postgresql13-server/Makefile:1.17
--- pkgsrc/databases/postgresql13-server/Makefile:1.16  Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql13-server/Makefile       Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.16 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.17 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/13-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql13-server/PLIST
diff -u pkgsrc/databases/postgresql13-server/PLIST:1.5 pkgsrc/databases/postgresql13-server/PLIST:1.6
--- pkgsrc/databases/postgresql13-server/PLIST:1.5      Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql13-server/PLIST  Wed Feb 15 20:50:59 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2022/11/13 09:34:26 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2023/02/15 20:50:59 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -839,6 +839,7 @@ share/postgresql/timezone/America/Cayenn
 share/postgresql/timezone/America/Cayman
 share/postgresql/timezone/America/Chicago
 share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Ciudad_Juarez
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica

Index: pkgsrc/databases/postgresql13/patches/patch-src_pl_plperl_plperl.h
diff -u pkgsrc/databases/postgresql13/patches/patch-src_pl_plperl_plperl.h:1.1 pkgsrc/databases/postgresql13/patches/patch-src_pl_plperl_plperl.h:1.2
--- pkgsrc/databases/postgresql13/patches/patch-src_pl_plperl_plperl.h:1.1      Sun Oct 18 09:24:02 2020
+++ pkgsrc/databases/postgresql13/patches/patch-src_pl_plperl_plperl.h  Wed Feb 15 20:50:58 2023
@@ -1,8 +1,8 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2020/10/18 09:24:02 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2023/02/15 20:50:58 adam Exp $
 
---- src/pl/plperl/plperl.h.orig        2019-09-30 20:06:55.000000000 +0000
+--- src/pl/plperl/plperl.h.orig        2023-02-06 21:42:56.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -68,6 +68,10 @@
+@@ -70,6 +70,11 @@
  #define HAS_BOOL 1
  #endif
  
@@ -10,10 +10,11 @@ $NetBSD: patch-src_pl_plperl_plperl.h,v 
 +#define list_head sun_list_head
 +#define list_tail sun_list_tail
 +#endif
- 
++
  /*
-  * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -110,6 +114,11 @@
+  * Newer versions of the perl headers trigger a lot of warnings with our
+  * compiler flags (at least -Wdeclaration-after-statement,
+@@ -121,6 +126,11 @@
  #include "XSUB.h"
  #endif
  

Index: pkgsrc/databases/postgresql14/Makefile
diff -u pkgsrc/databases/postgresql14/Makefile:1.11 pkgsrc/databases/postgresql14/Makefile:1.12
--- pkgsrc/databases/postgresql14/Makefile:1.11 Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14/Makefile      Wed Feb 15 20:50:59 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.12 2023/02/15 20:50:59 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-/}
-PKGREVISION=   1
 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.9 pkgsrc/databases/postgresql14/Makefile.common:1.10
--- pkgsrc/databases/postgresql14/Makefile.common:1.9   Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql14/Makefile.common       Wed Feb 15 20:50:59 2023
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.9 2022/11/13 09:34:26 adam Exp $
+# $NetBSD: Makefile.common,v 1.10 2023/02/15 20:50:59 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.6
+DISTNAME=      postgresql-14.7
 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.9 pkgsrc/databases/postgresql14/distinfo:1.10
--- pkgsrc/databases/postgresql14/distinfo:1.9  Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql14/distinfo      Wed Feb 15 20:50:59 2023
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.9 2022/11/13 09:34:26 adam Exp $
+$NetBSD: distinfo,v 1.10 2023/02/15 20:50:59 adam Exp $
 
-BLAKE2s (postgresql-14.6.tar.bz2) = 4e543cb810a85d2f522c22b296ae98c958363bf66e881f13d9883a5263302878
-SHA512 (postgresql-14.6.tar.bz2) = 133083eb5709ace65dd81d326a960654dd6cfb35b3e85a35f71763c59dad0052a561c2aa1d1f52652b4bf81ed71edd232f170d483989d65ca354e653331faf2e
-Size (postgresql-14.6.tar.bz2) = 22177474 bytes
+BLAKE2s (postgresql-14.7.tar.bz2) = 8cbf96fb5d594ccf93da17e7a1551ff650542730f4f36fedc4f45d1260bf37e8
+SHA512 (postgresql-14.7.tar.bz2) = 931c3850d09a90b44b986f0ea6eb96eb549919ffd28ca71a7f1896e40dbbbc77601179d480c614f80cf67e5c1a4ccb4d38e06c846c13262723de621463a95508
+Size (postgresql-14.7.tar.bz2) = 22182073 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
@@ -14,4 +14,4 @@ SHA1 (patch-src_backend_Makefile) = 736f
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 10bf43bee54a6a1b6086c1652076544b05bf0192
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 161a8f7af61b3a33b255fdee9fa7d4918decde7d
-SHA1 (patch-src_pl_plperl_plperl.h) = 4ea16bbb0f9f98a609e67ceb858f22cc77be89ae
+SHA1 (patch-src_pl_plperl_plperl.h) = fd65b9930a150a9bbd1fd3b5771144a6608126a2

Index: pkgsrc/databases/postgresql14-client/Makefile
diff -u pkgsrc/databases/postgresql14-client/Makefile:1.13 pkgsrc/databases/postgresql14-client/Makefile:1.14
--- pkgsrc/databases/postgresql14-client/Makefile:1.13  Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14-client/Makefile       Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.14 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql14/Makefile.common"

Index: pkgsrc/databases/postgresql14-contrib/Makefile
diff -u pkgsrc/databases/postgresql14-contrib/Makefile:1.9 pkgsrc/databases/postgresql14-contrib/Makefile:1.10
--- pkgsrc/databases/postgresql14-contrib/Makefile:1.9  Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14-contrib/Makefile      Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.10 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-contrib-/}
-PKGREVISION=   1
 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.9 pkgsrc/databases/postgresql14-docs/Makefile:1.10
--- pkgsrc/databases/postgresql14-docs/Makefile:1.9     Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14-docs/Makefile Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.10 2023/02/15 20:51:00 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.7 pkgsrc/databases/postgresql14-docs/PLIST:1.8
--- pkgsrc/databases/postgresql14-docs/PLIST:1.7        Sun Nov 13 09:34:26 2022
+++ pkgsrc/databases/postgresql14-docs/PLIST    Wed Feb 15 20:51:00 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2022/11/13 09:34:26 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2023/02/15 20:51:00 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -992,6 +992,7 @@ share/doc/postgresql/html/release-14-3.h
 share/doc/postgresql/html/release-14-4.html
 share/doc/postgresql/html/release-14-5.html
 share/doc/postgresql/html/release-14-6.html
+share/doc/postgresql/html/release-14-7.html
 share/doc/postgresql/html/release-14.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql14-plperl/Makefile
diff -u pkgsrc/databases/postgresql14-plperl/Makefile:1.10 pkgsrc/databases/postgresql14-plperl/Makefile:1.11
--- pkgsrc/databases/postgresql14-plperl/Makefile:1.10  Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14-plperl/Makefile       Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.11 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-plpython/Makefile
diff -u pkgsrc/databases/postgresql14-plpython/Makefile:1.10 pkgsrc/databases/postgresql14-plpython/Makefile:1.11
--- pkgsrc/databases/postgresql14-plpython/Makefile:1.10        Wed Nov 23 16:19:41 2022
+++ pkgsrc/databases/postgresql14-plpython/Makefile     Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2022/11/23 16:19:41 adam Exp $
+# $NetBSD: Makefile,v 1.11 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-pltcl/Makefile
diff -u pkgsrc/databases/postgresql14-pltcl/Makefile:1.9 pkgsrc/databases/postgresql14-pltcl/Makefile:1.10
--- pkgsrc/databases/postgresql14-pltcl/Makefile:1.9    Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql14-pltcl/Makefile        Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.10 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql14-server>=${PKGVERSION_NOREV}:../../databases/postgresql14-server

Index: pkgsrc/databases/postgresql14-server/Makefile
diff -u pkgsrc/databases/postgresql14-server/Makefile:1.9 pkgsrc/databases/postgresql14-server/Makefile:1.10
--- pkgsrc/databases/postgresql14-server/Makefile:1.9   Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql14-server/Makefile       Wed Feb 15 20:51:00 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.10 2023/02/15 20:51:00 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/14-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql14-server/PLIST
diff -u pkgsrc/databases/postgresql14-server/PLIST:1.5 pkgsrc/databases/postgresql14-server/PLIST:1.6
--- pkgsrc/databases/postgresql14-server/PLIST:1.5      Sun Nov 13 09:34:27 2022
+++ pkgsrc/databases/postgresql14-server/PLIST  Wed Feb 15 20:51:00 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2022/11/13 09:34:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2023/02/15 20:51:00 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -862,6 +862,7 @@ share/postgresql/timezone/America/Cayenn
 share/postgresql/timezone/America/Cayman
 share/postgresql/timezone/America/Chicago
 share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Ciudad_Juarez
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica

Index: pkgsrc/databases/postgresql14/patches/patch-src_pl_plperl_plperl.h
diff -u pkgsrc/databases/postgresql14/patches/patch-src_pl_plperl_plperl.h:1.1 pkgsrc/databases/postgresql14/patches/patch-src_pl_plperl_plperl.h:1.2
--- pkgsrc/databases/postgresql14/patches/patch-src_pl_plperl_plperl.h:1.1      Fri Oct  8 10:23:43 2021
+++ pkgsrc/databases/postgresql14/patches/patch-src_pl_plperl_plperl.h  Wed Feb 15 20:51:00 2023
@@ -1,19 +1,20 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2021/10/08 10:23:43 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2023/02/15 20:51:00 adam Exp $
 
---- src/pl/plperl/plperl.h.orig        2019-09-30 20:06:55.000000000 +0000
+--- src/pl/plperl/plperl.h.orig        2023-02-06 21:41:14.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -68,6 +68,10 @@
+@@ -70,6 +70,11 @@
  #define HAS_BOOL 1
  #endif
  
 +#ifdef __sun
-+#define list_head sun_list_head
-+#define list_tail sun_list_tail
++#undef list_head
++#undef list_tail
 +#endif
- 
++
  /*
-  * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -110,6 +114,11 @@
+  * Newer versions of the perl headers trigger a lot of warnings with our
+  * compiler flags (at least -Wdeclaration-after-statement,
+@@ -122,6 +127,11 @@
  #include "XSUB.h"
  #endif
  

Index: pkgsrc/databases/postgresql15/Makefile
diff -u pkgsrc/databases/postgresql15/Makefile:1.2 pkgsrc/databases/postgresql15/Makefile:1.3
--- pkgsrc/databases/postgresql15/Makefile:1.2  Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15/Makefile      Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql15-client>=${PKGVERSION_NOREV}:../../databases/postgresql15-client
Index: pkgsrc/databases/postgresql15/distinfo
diff -u pkgsrc/databases/postgresql15/distinfo:1.2 pkgsrc/databases/postgresql15/distinfo:1.3
--- pkgsrc/databases/postgresql15/distinfo:1.2  Sun Nov 13 09:34:27 2022
+++ pkgsrc/databases/postgresql15/distinfo      Wed Feb 15 20:51:01 2023
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.2 2022/11/13 09:34:27 adam Exp $
+$NetBSD: distinfo,v 1.3 2023/02/15 20:51:01 adam Exp $
 
-BLAKE2s (postgresql-15.1.tar.bz2) = f9a7da05d228f613866220913703a4404e07150e5c317dab2774666c406f42cb
-SHA512 (postgresql-15.1.tar.bz2) = 803900363106d2e343305e6d1546016b6a6a37bbd49d7a84a9a6467c1dc3fc4eb52698411af9c2178590c2f7680967466b1a211a76955dcec5445d0b8b254202
-Size (postgresql-15.1.tar.bz2) = 22666134 bytes
+BLAKE2s (postgresql-15.2.tar.bz2) = 5ded1344827bfe28c84ac9becb766ca0f31795c296507fc61ab52b0449bfbf6a
+SHA512 (postgresql-15.2.tar.bz2) = 115a8a4234791bba4e6dcc4617e9dd77abedcf767894ce9472c59cce9d5d4ef2d4e1746f3a0c7a99de4fc4385fb716652b70dce9f48be45a9db5a682517db7e8
+Size (postgresql-15.2.tar.bz2) = 22688379 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
@@ -13,4 +13,4 @@ SHA1 (patch-src_backend_Makefile) = 28a3
 SHA1 (patch-src_interfaces_libpq_Makefile) = 61bcf84eb69b6ec9faabab0b61913766f4b20f8c
 SHA1 (patch-src_makefiles_Makefile.solaris) = 10bf43bee54a6a1b6086c1652076544b05bf0192
 SHA1 (patch-src_pl_plperl_GNUmakefile) = 161a8f7af61b3a33b255fdee9fa7d4918decde7d
-SHA1 (patch-src_pl_plperl_plperl.h) = 4ea16bbb0f9f98a609e67ceb858f22cc77be89ae
+SHA1 (patch-src_pl_plperl_plperl.h) = 67b71bee267448088c43ae1f206d6eaee4c08dea

Index: pkgsrc/databases/postgresql15/Makefile.common
diff -u pkgsrc/databases/postgresql15/Makefile.common:1.3 pkgsrc/databases/postgresql15/Makefile.common:1.4
--- pkgsrc/databases/postgresql15/Makefile.common:1.3   Sun Nov 13 09:34:27 2022
+++ pkgsrc/databases/postgresql15/Makefile.common       Wed Feb 15 20:51:01 2023
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.3 2022/11/13 09:34:27 adam Exp $
+# $NetBSD: Makefile.common,v 1.4 2023/02/15 20:51:01 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.1
+DISTNAME=      postgresql-15.2
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql15-client/Makefile
diff -u pkgsrc/databases/postgresql15-client/Makefile:1.2 pkgsrc/databases/postgresql15-client/Makefile:1.3
--- pkgsrc/databases/postgresql15-client/Makefile:1.2   Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-client/Makefile       Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql15/Makefile.common"

Index: pkgsrc/databases/postgresql15-contrib/Makefile
diff -u pkgsrc/databases/postgresql15-contrib/Makefile:1.2 pkgsrc/databases/postgresql15-contrib/Makefile:1.3
--- pkgsrc/databases/postgresql15-contrib/Makefile:1.2  Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-contrib/Makefile      Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql15/Makefile.common"
Index: pkgsrc/databases/postgresql15-contrib/PLIST
diff -u pkgsrc/databases/postgresql15-contrib/PLIST:1.2 pkgsrc/databases/postgresql15-contrib/PLIST:1.3
--- pkgsrc/databases/postgresql15-contrib/PLIST:1.2     Fri Dec  2 09:34:25 2022
+++ pkgsrc/databases/postgresql15-contrib/PLIST Wed Feb 15 20:51:01 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2022/12/02 09:34:25 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2023/02/15 20:51:01 adam Exp $
 bin/oid2name
 bin/vacuumlo
 include/postgresql/server/extension/cube/cubedata.h
@@ -309,6 +309,7 @@ share/postgresql/extension/moddatetime--
 share/postgresql/extension/moddatetime.control
 share/postgresql/extension/pageinspect--1.0--1.1.sql
 share/postgresql/extension/pageinspect--1.1--1.2.sql
+share/postgresql/extension/pageinspect--1.10--1.11.sql
 share/postgresql/extension/pageinspect--1.2--1.3.sql
 share/postgresql/extension/pageinspect--1.3--1.4.sql
 share/postgresql/extension/pageinspect--1.4--1.5.sql

Index: pkgsrc/databases/postgresql15-docs/Makefile
diff -u pkgsrc/databases/postgresql15-docs/Makefile:1.2 pkgsrc/databases/postgresql15-docs/Makefile:1.3
--- pkgsrc/databases/postgresql15-docs/Makefile:1.2     Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-docs/Makefile Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 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.2 pkgsrc/databases/postgresql15-docs/PLIST:1.3
--- pkgsrc/databases/postgresql15-docs/PLIST:1.2        Sun Nov 13 09:34:27 2022
+++ pkgsrc/databases/postgresql15-docs/PLIST    Wed Feb 15 20:51:01 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2022/11/13 09:34:27 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2023/02/15 20:51:01 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -1000,6 +1000,7 @@ share/doc/postgresql/html/regress-tap.ht
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-15-1.html
+share/doc/postgresql/html/release-15-2.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.2 pkgsrc/databases/postgresql15-plperl/Makefile:1.3
--- pkgsrc/databases/postgresql15-plperl/Makefile:1.2   Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-plperl/Makefile       Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql15-server>=${PKGVERSION_NOREV}:../../databases/postgresql15-server

Index: pkgsrc/databases/postgresql15-plpython/Makefile
diff -u pkgsrc/databases/postgresql15-plpython/Makefile:1.2 pkgsrc/databases/postgresql15-plpython/Makefile:1.3
--- pkgsrc/databases/postgresql15-plpython/Makefile:1.2 Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-plpython/Makefile     Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-plpython-/}
-PKGREVISION=   1
 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.2 pkgsrc/databases/postgresql15-pltcl/Makefile:1.3
--- pkgsrc/databases/postgresql15-pltcl/Makefile:1.2    Wed Nov 23 16:19:42 2022
+++ pkgsrc/databases/postgresql15-pltcl/Makefile        Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:42 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-pltcl-/}
-PKGREVISION=   1
 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.2 pkgsrc/databases/postgresql15-server/Makefile:1.3
--- pkgsrc/databases/postgresql15-server/Makefile:1.2   Wed Nov 23 16:19:43 2022
+++ pkgsrc/databases/postgresql15-server/Makefile       Wed Feb 15 20:51:01 2023
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.2 2022/11/23 16:19:43 adam Exp $
+# $NetBSD: Makefile,v 1.3 2023/02/15 20:51:01 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/15-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql15-server/PLIST
diff -u pkgsrc/databases/postgresql15-server/PLIST:1.3 pkgsrc/databases/postgresql15-server/PLIST:1.4
--- pkgsrc/databases/postgresql15-server/PLIST:1.3      Fri Dec  2 09:30:31 2022
+++ pkgsrc/databases/postgresql15-server/PLIST  Wed Feb 15 20:51:01 2023
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2022/12/02 09:30:31 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2023/02/15 20:51:01 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -899,6 +899,7 @@ share/postgresql/timezone/America/Cayenn
 share/postgresql/timezone/America/Cayman
 share/postgresql/timezone/America/Chicago
 share/postgresql/timezone/America/Chihuahua
+share/postgresql/timezone/America/Ciudad_Juarez
 share/postgresql/timezone/America/Coral_Harbour
 share/postgresql/timezone/America/Cordoba
 share/postgresql/timezone/America/Costa_Rica

Index: pkgsrc/databases/postgresql15/patches/patch-src_pl_plperl_plperl.h
diff -u pkgsrc/databases/postgresql15/patches/patch-src_pl_plperl_plperl.h:1.1 pkgsrc/databases/postgresql15/patches/patch-src_pl_plperl_plperl.h:1.2
--- pkgsrc/databases/postgresql15/patches/patch-src_pl_plperl_plperl.h:1.1      Wed Oct 19 13:16:45 2022
+++ pkgsrc/databases/postgresql15/patches/patch-src_pl_plperl_plperl.h  Wed Feb 15 20:51:01 2023
@@ -1,8 +1,8 @@
-$NetBSD: patch-src_pl_plperl_plperl.h,v 1.1 2022/10/19 13:16:45 adam Exp $
+$NetBSD: patch-src_pl_plperl_plperl.h,v 1.2 2023/02/15 20:51:01 adam Exp $
 
---- src/pl/plperl/plperl.h.orig        2019-09-30 20:06:55.000000000 +0000
+--- src/pl/plperl/plperl.h.orig        2023-02-06 21:39:04.000000000 +0000
 +++ src/pl/plperl/plperl.h
-@@ -68,6 +68,10 @@
+@@ -70,6 +70,11 @@
  #define HAS_BOOL 1
  #endif
  
@@ -10,10 +10,11 @@ $NetBSD: patch-src_pl_plperl_plperl.h,v 
 +#define list_head sun_list_head
 +#define list_tail sun_list_tail
 +#endif
- 
++
  /*
-  * Get the basic Perl API.  We use PERL_NO_GET_CONTEXT mode so that our code
-@@ -110,6 +114,11 @@
+  * Newer versions of the perl headers trigger a lot of warnings with our
+  * compiler flags (at least -Wdeclaration-after-statement,
+@@ -122,6 +127,11 @@
  #include "XSUB.h"
  #endif

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

Home | Main Index | Thread Index | Old Index