pkgsrc-Changes archive

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

CVS commit: pkgsrc/databases



Module Name:    pkgsrc
Committed By:   adam
Date:           Fri Aug 14 06:56:26 UTC 2020

Modified Files:
        pkgsrc/databases/postgresql10: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql10-client: Makefile PLIST
        pkgsrc/databases/postgresql10-contrib: Makefile
        pkgsrc/databases/postgresql10-docs: Makefile PLIST
        pkgsrc/databases/postgresql10-plperl: Makefile
        pkgsrc/databases/postgresql10-plpython: Makefile
        pkgsrc/databases/postgresql10-pltcl: Makefile
        pkgsrc/databases/postgresql10-server: Makefile
        pkgsrc/databases/postgresql11: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql11-client: Makefile PLIST
        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
        pkgsrc/databases/postgresql12: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql12-client: Makefile PLIST
        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/postgresql95: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql95-client: Makefile
        pkgsrc/databases/postgresql95-contrib: Makefile
        pkgsrc/databases/postgresql95-docs: Makefile PLIST
        pkgsrc/databases/postgresql95-plperl: Makefile
        pkgsrc/databases/postgresql95-plpython: Makefile
        pkgsrc/databases/postgresql95-pltcl: Makefile
        pkgsrc/databases/postgresql95-server: Makefile
        pkgsrc/databases/postgresql96: Makefile Makefile.common distinfo
        pkgsrc/databases/postgresql96-client: Makefile
        pkgsrc/databases/postgresql96-contrib: Makefile
        pkgsrc/databases/postgresql96-docs: Makefile PLIST
        pkgsrc/databases/postgresql96-plperl: Makefile
        pkgsrc/databases/postgresql96-plpython: Makefile
        pkgsrc/databases/postgresql96-pltcl: Makefile
        pkgsrc/databases/postgresql96-server: Makefile

Log Message:
postgresql: updated to 12.4, 11.9, 10.14, 9.6.19, 9.5.23

PostgreSQL 12.4, 11.9, 10.14, 9.6.19, 9.5.23

Security Issues

CVE-2020-14349: Uncontrolled search path element in logical replication.
Versions Affected: 10 - 12.

The PostgreSQL search_path setting determines schemas searched for tables, functions, operators, etc. The CVE-2018-1058 fix caused most PostgreSQL-provided client applications to sanitize 
search_path, but logical replication continued to leave search_path unchanged. Users of a replication publisher or subscriber database can create objects in the public schema and harness them to 
execute arbitrary SQL functions under the identity running replication, often a superuser. Installations having adopted a documented secure schema usage pattern are not vulnerable.

The PostgreSQL project thanks Noah Misch for reporting this problem.

CVE-2020-14350: Uncontrolled search path element in CREATE EXTENSION.
Versions Affected: 9.5 - 12. The security team typically does not test unsupported versions, but this problem is quite old.

When a superuser runs certain CREATE EXTENSION statements, users may be able to execute arbitrary SQL functions under the identity of that superuser. The attacker must have permission to create 
objects in the new extension's schema or a schema of a prerequisite extension. Not all extensions are vulnerable.

In addition to correcting the extensions provided with PostgreSQL, the PostgreSQL Global Development Group is issuing guidance for third-party extension authors to secure their own work.

Bug Fixes and Improvements

This update also fixes over 50 bugs that were reported in the last several months. Some of these issues affect only version 12, but many affect all supported versions.

Some of these fixes include:

Fix edge cases in partition pruning involving multiple partition key columns with multiple or no constraining WHERE clauses.
Several fixes for query planning and execution involving partitions.
Fix for determining when to execute a column-specific UPDATE trigger on a logical replication subscriber.
pg_replication_slot_advance() now updates the oldest xmin and LSN values, as the failure to do this could prevent resources (e.g. WAL files) from being cleaned up.
Fix a performance regression in ts_headline().
Ensure that pg_read_file() and related functions read until EOF is reached, which fixes compatibility with pipes and other virtual files.
Forbid numeric NaN values in jsonpath computations, which do not exist in SQL nor JSON.
Several fixes for NaN inputs with aggregate functions. This fixes a change in PostgreSQL 12 where NaN values caused the following aggregates to emit values of 0 instead of NaN: corr(), covar_pop(), 
regr_intercept(), regr_r2(), regr_slope(), regr_sxx(), regr_sxy(), regr_syy(), stddev_pop(), and var_pop().
time and timetz values fractionally greater than 24:00:00 are now rejected.
Several fixes for EXPLAIN, including a fix for reporting resource usage when a plan uses parallel workers with "Gather Merge" nodes.
Fix timing of constraint revalidation in ALTER TABLE that could lead to odd errors.
Fix for REINDEX CONCURRENTLY that could prevent old values from being included in future logical decoding output.
Fix for LATERAL references that could potentially cause crashes during query execution.
Use the collation specified for a query when estimating operator costs
Fix conflict-checking anomalies in SERIALIZABLE transaction isolation mode.
Ensure checkpointer process discards file sync requests when fsync is off
Fix issue where pg_control could be written out with an inconsistent checksum, which could lead to the inability to restart the database if it crashed before the next pg_control update.
Ensure that libpq continues to try to read from the database connection socket after a write failure, as this allows the connection to collect any final error messages from the server.
Report out-of-disk-space errors properly in pg_dump and pg_basebackup
Several fixes for pg_restore, including a fix for parallel restore on tables that have both table-level and column-level privileges.
Fix for pg_upgrade to ensure it runs with vacuum_defer_cleanup_age set to 0.
Fix how pg_rewind handles just-deleted files in the source data directory
Fix failure to initialize local state correctly in contrib/dblink, which could lead to dblink_close() issuing an unexpected COMMIT on the remote server.
Change contrib/amcheck to not report about deleted index pages that are empty, as this is normal during WAL replay.


To generate a diff of this commit:
cvs rdiff -u -r1.17 -r1.18 pkgsrc/databases/postgresql10/Makefile
cvs rdiff -u -r1.21 -r1.22 pkgsrc/databases/postgresql10/Makefile.common
cvs rdiff -u -r1.15 -r1.16 pkgsrc/databases/postgresql10/distinfo
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql10-client/Makefile
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/postgresql10-client/PLIST
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql10-contrib/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql10-docs/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql10-docs/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql10-plperl/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql10-plpython/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql10-pltcl/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql10-server/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql11/Makefile
cvs rdiff -u -r1.14 -r1.15 pkgsrc/databases/postgresql11/Makefile.common
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql11/distinfo
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql11-client/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql11-client/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql11-contrib/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql11-docs/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql11-docs/PLIST
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql11-plperl/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql11-plpython/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql11-pltcl/Makefile
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/postgresql11-server/Makefile
cvs rdiff -u -r1.8 -r1.9 pkgsrc/databases/postgresql12/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql12/Makefile.common
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql12/distinfo
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql12-client/Makefile
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql12-client/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql12-contrib/Makefile
cvs rdiff -u -r1.3 -r1.4 pkgsrc/databases/postgresql12-docs/Makefile
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql12-docs/PLIST
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql12-plperl/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql12-plpython/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql12-pltcl/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql12-server/Makefile
cvs rdiff -u -r1.4 -r1.5 pkgsrc/databases/postgresql12-server/PLIST
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql95/Makefile
cvs rdiff -u -r1.32 -r1.33 pkgsrc/databases/postgresql95/Makefile.common
cvs rdiff -u -r1.24 -r1.25 pkgsrc/databases/postgresql95/distinfo
cvs rdiff -u -r1.13 -r1.14 pkgsrc/databases/postgresql95-client/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql95-contrib/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql95-docs/Makefile
cvs rdiff -u -r1.22 -r1.23 pkgsrc/databases/postgresql95-docs/PLIST
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql95-plperl/Makefile
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql95-plpython/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql95-pltcl/Makefile
cvs rdiff -u -r1.12 -r1.13 pkgsrc/databases/postgresql95-server/Makefile
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql96/Makefile
cvs rdiff -u -r1.26 -r1.27 pkgsrc/databases/postgresql96/Makefile.common
cvs rdiff -u -r1.20 -r1.21 pkgsrc/databases/postgresql96/distinfo
cvs rdiff -u -r1.11 -r1.12 pkgsrc/databases/postgresql96-client/Makefile
cvs rdiff -u -r1.10 -r1.11 pkgsrc/databases/postgresql96-contrib/Makefile
cvs rdiff -u -r1.5 -r1.6 pkgsrc/databases/postgresql96-docs/Makefile
cvs rdiff -u -r1.18 -r1.19 pkgsrc/databases/postgresql96-docs/PLIST
cvs rdiff -u -r1.6 -r1.7 pkgsrc/databases/postgresql96-plperl/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql96-plpython/Makefile
cvs rdiff -u -r1.7 -r1.8 pkgsrc/databases/postgresql96-pltcl/Makefile
cvs rdiff -u -r1.9 -r1.10 pkgsrc/databases/postgresql96-server/Makefile

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

Modified files:

Index: pkgsrc/databases/postgresql10/Makefile
diff -u pkgsrc/databases/postgresql10/Makefile:1.17 pkgsrc/databases/postgresql10/Makefile:1.18
--- pkgsrc/databases/postgresql10/Makefile:1.17 Tue Jun  2 08:23:26 2020
+++ pkgsrc/databases/postgresql10/Makefile      Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.17 2020/06/02 08:23:26 adam Exp $
+# $NetBSD: Makefile,v 1.18 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql10-client>=${PKGVERSION_NOREV}:../../databases/postgresql10-client

Index: pkgsrc/databases/postgresql10/Makefile.common
diff -u pkgsrc/databases/postgresql10/Makefile.common:1.21 pkgsrc/databases/postgresql10/Makefile.common:1.22
--- pkgsrc/databases/postgresql10/Makefile.common:1.21  Fri Aug  7 19:39:39 2020
+++ pkgsrc/databases/postgresql10/Makefile.common       Fri Aug 14 06:56:22 2020
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.21 2020/08/07 19:39:39 maya Exp $
+# $NetBSD: Makefile.common,v 1.22 2020/08/14 06:56:22 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=      postgresql-10.13
+DISTNAME=      postgresql-10.14
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql10/distinfo
diff -u pkgsrc/databases/postgresql10/distinfo:1.15 pkgsrc/databases/postgresql10/distinfo:1.16
--- pkgsrc/databases/postgresql10/distinfo:1.15 Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql10/distinfo      Fri Aug 14 06:56:22 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.15 2020/05/15 09:45:00 adam Exp $
+$NetBSD: distinfo,v 1.16 2020/08/14 06:56:22 adam Exp $
 
-SHA1 (postgresql-10.13.tar.bz2) = adb3d5a27abedcc712c9a3687c42631083c5ba0d
-RMD160 (postgresql-10.13.tar.bz2) = dfbe651ec0456cd567eecff9bb49e0da9dcddec9
-SHA512 (postgresql-10.13.tar.bz2) = 7b268aa4476ed9b168814891e8b19d182683ab4994d4a9b30e75eec93ffd9c860f8a0979ba1b7408acf8e217437b5cc20037b6ebf6ef01e9cf5ee99f091c8c92
-Size (postgresql-10.13.tar.bz2) = 19028339 bytes
+SHA1 (postgresql-10.14.tar.bz2) = db230e62422673814419e76508708164a2cbfb09
+RMD160 (postgresql-10.14.tar.bz2) = 7f73551d98a67bbfd285be9185e529a43755da50
+SHA512 (postgresql-10.14.tar.bz2) = eecd2aa8df7e4779606ec547b7bf0207ebb2be10a4b332f06c3b72116f0619fe27fb651f2fd4504c73b740ab7f92468919244a615d460bb9c35085174a0dbc78
+Size (postgresql-10.14.tar.bz2) = 19042154 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd

Index: pkgsrc/databases/postgresql10-client/Makefile
diff -u pkgsrc/databases/postgresql10-client/Makefile:1.9 pkgsrc/databases/postgresql10-client/Makefile:1.10
--- pkgsrc/databases/postgresql10-client/Makefile:1.9   Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-client/Makefile       Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql10/Makefile.common"

Index: pkgsrc/databases/postgresql10-client/PLIST
diff -u pkgsrc/databases/postgresql10-client/PLIST:1.8 pkgsrc/databases/postgresql10-client/PLIST:1.9
--- pkgsrc/databases/postgresql10-client/PLIST:1.8      Fri Oct 25 12:01:19 2019
+++ pkgsrc/databases/postgresql10-client/PLIST  Fri Aug 14 06:56:22 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.8 2019/10/25 12:01:19 triaxx Exp $
+@comment $NetBSD: PLIST,v 1.9 2020/08/14 06:56:22 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -251,6 +251,7 @@ include/postgresql/server/commands/varia
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/base64.h
 include/postgresql/server/common/config_info.h
+include/postgresql/server/common/connect.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
 include/postgresql/server/common/file_utils.h

Index: pkgsrc/databases/postgresql10-contrib/Makefile
diff -u pkgsrc/databases/postgresql10-contrib/Makefile:1.9 pkgsrc/databases/postgresql10-contrib/Makefile:1.10
--- pkgsrc/databases/postgresql10-contrib/Makefile:1.9  Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-contrib/Makefile      Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql10/Makefile.common"

Index: pkgsrc/databases/postgresql10-docs/Makefile
diff -u pkgsrc/databases/postgresql10-docs/Makefile:1.5 pkgsrc/databases/postgresql10-docs/Makefile:1.6
--- pkgsrc/databases/postgresql10-docs/Makefile:1.5     Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-docs/Makefile Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql10/Makefile.common"

Index: pkgsrc/databases/postgresql10-docs/PLIST
diff -u pkgsrc/databases/postgresql10-docs/PLIST:1.14 pkgsrc/databases/postgresql10-docs/PLIST:1.15
--- pkgsrc/databases/postgresql10-docs/PLIST:1.14       Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql10-docs/PLIST    Fri Aug 14 06:56:22 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2020/05/15 09:45:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2020/08/14 06:56:22 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -458,6 +458,7 @@ share/doc/postgresql/html/datetime-confi
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -913,6 +914,7 @@ share/doc/postgresql/html/release-10-10.
 share/doc/postgresql/html/release-10-11.html
 share/doc/postgresql/html/release-10-12.html
 share/doc/postgresql/html/release-10-13.html
+share/doc/postgresql/html/release-10-14.html
 share/doc/postgresql/html/release-10-2.html
 share/doc/postgresql/html/release-10-3.html
 share/doc/postgresql/html/release-10-4.html

Index: pkgsrc/databases/postgresql10-plperl/Makefile
diff -u pkgsrc/databases/postgresql10-plperl/Makefile:1.6 pkgsrc/databases/postgresql10-plperl/Makefile:1.7
--- pkgsrc/databases/postgresql10-plperl/Makefile:1.6   Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-plperl/Makefile       Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.6 2020/06/02 08:23:27 adam Exp $
+#$ $NetBSD: Makefile,v 1.7 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server

Index: pkgsrc/databases/postgresql10-plpython/Makefile
diff -u pkgsrc/databases/postgresql10-plpython/Makefile:1.9 pkgsrc/databases/postgresql10-plpython/Makefile:1.10
--- pkgsrc/databases/postgresql10-plpython/Makefile:1.9 Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-plpython/Makefile     Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server

Index: pkgsrc/databases/postgresql10-pltcl/Makefile
diff -u pkgsrc/databases/postgresql10-pltcl/Makefile:1.7 pkgsrc/databases/postgresql10-pltcl/Makefile:1.8
--- pkgsrc/databases/postgresql10-pltcl/Makefile:1.7    Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-pltcl/Makefile        Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql10-server>=${PKGVERSION_NOREV}:../../databases/postgresql10-server

Index: pkgsrc/databases/postgresql10-server/Makefile
diff -u pkgsrc/databases/postgresql10-server/Makefile:1.11 pkgsrc/databases/postgresql10-server/Makefile:1.12
--- pkgsrc/databases/postgresql10-server/Makefile:1.11  Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql10-server/Makefile       Fri Aug 14 06:56:22 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.12 2020/08/14 06:56:22 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/10-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql11/Makefile
diff -u pkgsrc/databases/postgresql11/Makefile:1.10 pkgsrc/databases/postgresql11/Makefile:1.11
--- pkgsrc/databases/postgresql11/Makefile:1.10 Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql11/Makefile      Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.11 2020/08/14 06:56:23 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.14 pkgsrc/databases/postgresql11/Makefile.common:1.15
--- pkgsrc/databases/postgresql11/Makefile.common:1.14  Fri Aug  7 19:39:39 2020
+++ pkgsrc/databases/postgresql11/Makefile.common       Fri Aug 14 06:56:23 2020
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.14 2020/08/07 19:39:39 maya Exp $
+# $NetBSD: Makefile.common,v 1.15 2020/08/14 06:56:23 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.8
+DISTNAME=      postgresql-11.9
 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.9 pkgsrc/databases/postgresql11/distinfo:1.10
--- pkgsrc/databases/postgresql11/distinfo:1.9  Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql11/distinfo      Fri Aug 14 06:56:23 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.9 2020/05/15 09:45:00 adam Exp $
+$NetBSD: distinfo,v 1.10 2020/08/14 06:56:23 adam Exp $
 
-SHA1 (postgresql-11.8.tar.bz2) = 82f2b0f6daa5f0ce54127676b8dc5f7fb2680e50
-RMD160 (postgresql-11.8.tar.bz2) = fc279ef554a50b79341454f9c538278d3aa13f0e
-SHA512 (postgresql-11.8.tar.bz2) = fc3d0ebd224de60bda3fa71b6832958698238e9088cf46a80c376b8996cc3b2d017fde5dce1c1da1e5e6e23b78054aafad7ee1caa744bfb12c52317ccc8a1922
-Size (postgresql-11.8.tar.bz2) = 19922770 bytes
+SHA1 (postgresql-11.9.tar.bz2) = aedb423d7f42a46fccf64ff1411fd8f5180f51e7
+RMD160 (postgresql-11.9.tar.bz2) = 8a1afd0d5d4e5f3d6e27d30c268dabf66a0db51c
+SHA512 (postgresql-11.9.tar.bz2) = 2c5c2f51aa01f02af4aa0849441767383e30fef69dd52efa442892f39d2456bfa8bf01f633a265e00eca0745e792609d2c1d33f77d8f29a02f5f374c84f2bf6e
+Size (postgresql-11.9.tar.bz2) = 19959019 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd

Index: pkgsrc/databases/postgresql11-client/Makefile
diff -u pkgsrc/databases/postgresql11-client/Makefile:1.5 pkgsrc/databases/postgresql11-client/Makefile:1.6
--- pkgsrc/databases/postgresql11-client/Makefile:1.5   Tue Jun  2 08:23:27 2020
+++ pkgsrc/databases/postgresql11-client/Makefile       Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:27 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql11/Makefile.common"

Index: pkgsrc/databases/postgresql11-client/PLIST
diff -u pkgsrc/databases/postgresql11-client/PLIST:1.6 pkgsrc/databases/postgresql11-client/PLIST:1.7
--- pkgsrc/databases/postgresql11-client/PLIST:1.6      Tue Nov 19 18:42:41 2019
+++ pkgsrc/databases/postgresql11-client/PLIST  Fri Aug 14 06:56:23 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2019/11/19 18:42:41 schmonz Exp $
+@comment $NetBSD: PLIST,v 1.7 2020/08/14 06:56:23 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -309,6 +309,7 @@ include/postgresql/server/commands/varia
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/base64.h
 include/postgresql/server/common/config_info.h
+include/postgresql/server/common/connect.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
 include/postgresql/server/common/file_perm.h

Index: pkgsrc/databases/postgresql11-contrib/Makefile
diff -u pkgsrc/databases/postgresql11-contrib/Makefile:1.6 pkgsrc/databases/postgresql11-contrib/Makefile:1.7
--- pkgsrc/databases/postgresql11-contrib/Makefile:1.6  Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-contrib/Makefile      Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.7 2020/08/14 06:56:23 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.3 pkgsrc/databases/postgresql11-docs/Makefile:1.4
--- pkgsrc/databases/postgresql11-docs/Makefile:1.3     Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-docs/Makefile Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.4 2020/08/14 06:56:23 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.9 pkgsrc/databases/postgresql11-docs/PLIST:1.10
--- pkgsrc/databases/postgresql11-docs/PLIST:1.9        Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql11-docs/PLIST    Fri Aug 14 06:56:23 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2020/05/15 09:45:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2020/08/14 06:56:23 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -483,6 +483,7 @@ share/doc/postgresql/html/datetime-confi
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -952,6 +953,7 @@ share/doc/postgresql/html/release-11-5.h
 share/doc/postgresql/html/release-11-6.html
 share/doc/postgresql/html/release-11-7.html
 share/doc/postgresql/html/release-11-8.html
+share/doc/postgresql/html/release-11-9.html
 share/doc/postgresql/html/release-11.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql11-plperl/Makefile
diff -u pkgsrc/databases/postgresql11-plperl/Makefile:1.4 pkgsrc/databases/postgresql11-plperl/Makefile:1.5
--- pkgsrc/databases/postgresql11-plperl/Makefile:1.4   Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-plperl/Makefile       Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.4 2020/06/02 08:23:28 adam Exp $
+#$ $NetBSD: Makefile,v 1.5 2020/08/14 06:56:23 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.7 pkgsrc/databases/postgresql11-plpython/Makefile:1.8
--- pkgsrc/databases/postgresql11-plpython/Makefile:1.7 Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-plpython/Makefile     Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:23 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.5 pkgsrc/databases/postgresql11-pltcl/Makefile:1.6
--- pkgsrc/databases/postgresql11-pltcl/Makefile:1.5    Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-pltcl/Makefile        Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:23 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.8 pkgsrc/databases/postgresql11-server/Makefile:1.9
--- pkgsrc/databases/postgresql11-server/Makefile:1.8   Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql11-server/Makefile       Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.9 2020/08/14 06:56:23 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/11-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql12/Makefile
diff -u pkgsrc/databases/postgresql12/Makefile:1.8 pkgsrc/databases/postgresql12/Makefile:1.9
--- pkgsrc/databases/postgresql12/Makefile:1.8  Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql12/Makefile      Fri Aug 14 06:56:23 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.8 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.9 2020/08/14 06:56:23 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.7 pkgsrc/databases/postgresql12/Makefile.common:1.8
--- pkgsrc/databases/postgresql12/Makefile.common:1.7   Fri Aug  7 19:39:39 2020
+++ pkgsrc/databases/postgresql12/Makefile.common       Fri Aug 14 06:56:23 2020
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.7 2020/08/07 19:39:39 maya Exp $
+# $NetBSD: Makefile.common,v 1.8 2020/08/14 06:56:23 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.3
+DISTNAME=      postgresql-12.4
 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.4 pkgsrc/databases/postgresql12/distinfo:1.5
--- pkgsrc/databases/postgresql12/distinfo:1.4  Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql12/distinfo      Fri Aug 14 06:56:23 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.4 2020/05/15 09:45:00 adam Exp $
+$NetBSD: distinfo,v 1.5 2020/08/14 06:56:23 adam Exp $
 
-SHA1 (postgresql-12.3.tar.bz2) = 2730f6c0c22037646c84b902a13f5aaa56308ab8
-RMD160 (postgresql-12.3.tar.bz2) = 9b8bda078877344f15f627b0b099da613f290362
-SHA512 (postgresql-12.3.tar.bz2) = 68e2d244ae2a9f2138d7569bcadc1cf6f62a410fa56ad1d4ac53206f2adefabb5ae136110b41ca9246df0f8b8cb039918997e0f8a81fc7e6efb7ad10b3a59ba1
-Size (postgresql-12.3.tar.bz2) = 20439892 bytes
+SHA1 (postgresql-12.4.tar.bz2) = 5a64e3916a42547227f2afec359d1c9ddc3eba8e
+RMD160 (postgresql-12.4.tar.bz2) = e469f58fe8261ad0739adaa94e56b16f4af8b9a0
+SHA512 (postgresql-12.4.tar.bz2) = 36daf10878ca153370829178786dd6ee366ab4d4d6dc9c527536740fdb14b688ae4c33f850eb4243a7667d23f87e4bfd1ddee0755447ad4f3996e423e391c2f3
+Size (postgresql-12.4.tar.bz2) = 20669776 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd

Index: pkgsrc/databases/postgresql12-client/Makefile
diff -u pkgsrc/databases/postgresql12-client/Makefile:1.6 pkgsrc/databases/postgresql12-client/Makefile:1.7
--- pkgsrc/databases/postgresql12-client/Makefile:1.6   Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql12-client/Makefile       Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.7 2020/08/14 06:56:24 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/12-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql12/Makefile.common"

Index: pkgsrc/databases/postgresql12-client/PLIST
diff -u pkgsrc/databases/postgresql12-client/PLIST:1.4 pkgsrc/databases/postgresql12-client/PLIST:1.5
--- pkgsrc/databases/postgresql12-client/PLIST:1.4      Fri May 15 20:27:12 2020
+++ pkgsrc/databases/postgresql12-client/PLIST  Fri Aug 14 06:56:24 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2020/05/15 20:27:12 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2020/08/14 06:56:24 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -314,6 +314,7 @@ include/postgresql/server/commands/varia
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/base64.h
 include/postgresql/server/common/config_info.h
+include/postgresql/server/common/connect.h
 include/postgresql/server/common/controldata_utils.h
 include/postgresql/server/common/fe_memutils.h
 include/postgresql/server/common/file_perm.h
@@ -1069,6 +1070,7 @@ ${PLIST.nls}share/locale/zh_CN/LC_MESSAG
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/libpq5-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_archivecleanup-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_basebackup-12.mo
+${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_checksums-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_config-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_controldata-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/pg_ctl-12.mo

Index: pkgsrc/databases/postgresql12-contrib/Makefile
diff -u pkgsrc/databases/postgresql12-contrib/Makefile:1.6 pkgsrc/databases/postgresql12-contrib/Makefile:1.7
--- pkgsrc/databases/postgresql12-contrib/Makefile:1.6  Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql12-contrib/Makefile      Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.7 2020/08/14 06:56:24 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.3 pkgsrc/databases/postgresql12-docs/Makefile:1.4
--- pkgsrc/databases/postgresql12-docs/Makefile:1.3     Tue Jun  2 08:23:28 2020
+++ pkgsrc/databases/postgresql12-docs/Makefile Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.3 2020/06/02 08:23:28 adam Exp $
+# $NetBSD: Makefile,v 1.4 2020/08/14 06:56:24 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.4 pkgsrc/databases/postgresql12-docs/PLIST:1.5
--- pkgsrc/databases/postgresql12-docs/PLIST:1.4        Fri May 15 09:45:00 2020
+++ pkgsrc/databases/postgresql12-docs/PLIST    Fri Aug 14 06:56:24 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2020/05/15 09:45:00 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2020/08/14 06:56:24 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -486,6 +486,7 @@ share/doc/postgresql/html/datetime-confi
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -954,6 +955,7 @@ share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-12-1.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
 share/doc/postgresql/html/release-12.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html

Index: pkgsrc/databases/postgresql12-plperl/Makefile
diff -u pkgsrc/databases/postgresql12-plperl/Makefile:1.4 pkgsrc/databases/postgresql12-plperl/Makefile:1.5
--- pkgsrc/databases/postgresql12-plperl/Makefile:1.4   Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql12-plperl/Makefile       Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.4 2020/06/02 08:23:29 adam Exp $
+#$ $NetBSD: Makefile,v 1.5 2020/08/14 06:56:24 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.5 pkgsrc/databases/postgresql12-plpython/Makefile:1.6
--- pkgsrc/databases/postgresql12-plpython/Makefile:1.5 Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql12-plpython/Makefile     Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:24 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.5 pkgsrc/databases/postgresql12-pltcl/Makefile:1.6
--- pkgsrc/databases/postgresql12-pltcl/Makefile:1.5    Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql12-pltcl/Makefile        Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:24 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.7 pkgsrc/databases/postgresql12-server/Makefile:1.8
--- pkgsrc/databases/postgresql12-server/Makefile:1.7   Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql12-server/Makefile       Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:24 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.4 pkgsrc/databases/postgresql12-server/PLIST:1.5
--- pkgsrc/databases/postgresql12-server/PLIST:1.4      Fri May 15 09:45:01 2020
+++ pkgsrc/databases/postgresql12-server/PLIST  Fri Aug 14 06:56:24 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2020/05/15 09:45:01 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2020/08/14 06:56:24 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -725,6 +725,7 @@ ${PLIST.nls}share/locale/sv/LC_MESSAGES/
 ${PLIST.nls}share/locale/tr/LC_MESSAGES/plpgsql-12.mo
 ${PLIST.nls}share/locale/tr/LC_MESSAGES/postgres-12.mo
 ${PLIST.nls}share/locale/uk/LC_MESSAGES/plpgsql-12.mo
+${PLIST.nls}share/locale/uk/LC_MESSAGES/postgres-12.mo
 ${PLIST.nls}share/locale/vi/LC_MESSAGES/plpgsql-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/plpgsql-12.mo
 ${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/postgres-12.mo

Index: pkgsrc/databases/postgresql95/Makefile
diff -u pkgsrc/databases/postgresql95/Makefile:1.10 pkgsrc/databases/postgresql95/Makefile:1.11
--- pkgsrc/databases/postgresql95/Makefile:1.10 Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql95/Makefile      Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.11 2020/08/14 06:56:24 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql95-client>=${PKGVERSION_NOREV}:../../databases/postgresql95-client

Index: pkgsrc/databases/postgresql95/Makefile.common
diff -u pkgsrc/databases/postgresql95/Makefile.common:1.32 pkgsrc/databases/postgresql95/Makefile.common:1.33
--- pkgsrc/databases/postgresql95/Makefile.common:1.32  Fri Aug  7 19:39:40 2020
+++ pkgsrc/databases/postgresql95/Makefile.common       Fri Aug 14 06:56:24 2020
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.32 2020/08/07 19:39:40 maya Exp $
+# $NetBSD: Makefile.common,v 1.33 2020/08/14 06:56:24 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql95-pltcl/Makefile
 # used by databases/postgresql95-server/Makefile
 
-DISTNAME=      postgresql-9.5.22
+DISTNAME=      postgresql-9.5.23
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql95/distinfo
diff -u pkgsrc/databases/postgresql95/distinfo:1.24 pkgsrc/databases/postgresql95/distinfo:1.25
--- pkgsrc/databases/postgresql95/distinfo:1.24 Fri May 15 09:45:01 2020
+++ pkgsrc/databases/postgresql95/distinfo      Fri Aug 14 06:56:24 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.24 2020/05/15 09:45:01 adam Exp $
+$NetBSD: distinfo,v 1.25 2020/08/14 06:56:24 adam Exp $
 
-SHA1 (postgresql-9.5.22.tar.bz2) = 5f67ef49a6751293f999db48b60dc91338735a79
-RMD160 (postgresql-9.5.22.tar.bz2) = 3a2b8b26d73f4fa5a47f538b0cdef35d697f5101
-SHA512 (postgresql-9.5.22.tar.bz2) = 489321fa49e17308d3a78353edf73a16295c1377ad429a94636df069d2bf55f538ba6570e3d2991dd28bcca45fee77c6c41fa9bade35ea7f9e581abff4c9a401
-Size (postgresql-9.5.22.tar.bz2) = 17667386 bytes
+SHA1 (postgresql-9.5.23.tar.bz2) = fb20ae72f83a5dc7b3a3473f725ebbead3d622bd
+RMD160 (postgresql-9.5.23.tar.bz2) = a1656262117211e31e2699e8269de1379419f518
+SHA512 (postgresql-9.5.23.tar.bz2) = b7a1e936a0043b57b3ece79610855820d2ea6a86e4a4be0c4c8358bf3e1ef8fa88bc60106d6b865d86231d16b5e3c098b4dbd93125a125b3cc5d468ffea64db1
+Size (postgresql-9.5.23.tar.bz2) = 17682366 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 14c9564577d0df6f82ae0027aeada2f3a6a8f07c
 SHA1 (patch-configure) = 18dd4af7f043b090beda157dfd52531b551eafd0

Index: pkgsrc/databases/postgresql95-client/Makefile
diff -u pkgsrc/databases/postgresql95-client/Makefile:1.13 pkgsrc/databases/postgresql95-client/Makefile:1.14
--- pkgsrc/databases/postgresql95-client/Makefile:1.13  Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql95-client/Makefile       Fri Aug 14 06:56:24 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.14 2020/08/14 06:56:24 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql95/Makefile.common"

Index: pkgsrc/databases/postgresql95-contrib/Makefile
diff -u pkgsrc/databases/postgresql95-contrib/Makefile:1.10 pkgsrc/databases/postgresql95-contrib/Makefile:1.11
--- pkgsrc/databases/postgresql95-contrib/Makefile:1.10 Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql95-contrib/Makefile      Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.11 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql95/Makefile.common"

Index: pkgsrc/databases/postgresql95-docs/Makefile
diff -u pkgsrc/databases/postgresql95-docs/Makefile:1.7 pkgsrc/databases/postgresql95-docs/Makefile:1.8
--- pkgsrc/databases/postgresql95-docs/Makefile:1.7     Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql95-docs/Makefile Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:29 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql95/Makefile.common"

Index: pkgsrc/databases/postgresql95-docs/PLIST
diff -u pkgsrc/databases/postgresql95-docs/PLIST:1.22 pkgsrc/databases/postgresql95-docs/PLIST:1.23
--- pkgsrc/databases/postgresql95-docs/PLIST:1.22       Tue May 19 07:05:28 2020
+++ pkgsrc/databases/postgresql95-docs/PLIST    Fri Aug 14 06:56:25 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.22 2020/05/19 07:05:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.23 2020/08/14 06:56:25 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -441,6 +441,7 @@ share/doc/postgresql/html/datetime-confi
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -882,6 +883,7 @@ share/doc/postgresql/html/release-9-5-2.
 share/doc/postgresql/html/release-9-5-20.html
 share/doc/postgresql/html/release-9-5-21.html
 share/doc/postgresql/html/release-9-5-22.html
+share/doc/postgresql/html/release-9-5-23.html
 share/doc/postgresql/html/release-9-5-3.html
 share/doc/postgresql/html/release-9-5-4.html
 share/doc/postgresql/html/release-9-5-5.html

Index: pkgsrc/databases/postgresql95-plperl/Makefile
diff -u pkgsrc/databases/postgresql95-plperl/Makefile:1.10 pkgsrc/databases/postgresql95-plperl/Makefile:1.11
--- pkgsrc/databases/postgresql95-plperl/Makefile:1.10  Tue Jun  2 08:23:29 2020
+++ pkgsrc/databases/postgresql95-plperl/Makefile       Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.10 2020/06/02 08:23:29 adam Exp $
+#$ $NetBSD: Makefile,v 1.11 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql95-server>=${PKGVERSION_NOREV}:../../databases/postgresql95-server

Index: pkgsrc/databases/postgresql95-plpython/Makefile
diff -u pkgsrc/databases/postgresql95-plpython/Makefile:1.11 pkgsrc/databases/postgresql95-plpython/Makefile:1.12
--- pkgsrc/databases/postgresql95-plpython/Makefile:1.11        Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql95-plpython/Makefile     Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.12 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql95-server>=${PKGVERSION_NOREV}:../../databases/postgresql95-server

Index: pkgsrc/databases/postgresql95-pltcl/Makefile
diff -u pkgsrc/databases/postgresql95-pltcl/Makefile:1.9 pkgsrc/databases/postgresql95-pltcl/Makefile:1.10
--- pkgsrc/databases/postgresql95-pltcl/Makefile:1.9    Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql95-pltcl/Makefile        Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql95-server>=${PKGVERSION_NOREV}:../../databases/postgresql95-server

Index: pkgsrc/databases/postgresql95-server/Makefile
diff -u pkgsrc/databases/postgresql95-server/Makefile:1.12 pkgsrc/databases/postgresql95-server/Makefile:1.13
--- pkgsrc/databases/postgresql95-server/Makefile:1.12  Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql95-server/Makefile       Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.12 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.13 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/95-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation

Index: pkgsrc/databases/postgresql96/Makefile
diff -u pkgsrc/databases/postgresql96/Makefile:1.6 pkgsrc/databases/postgresql96/Makefile:1.7
--- pkgsrc/databases/postgresql96/Makefile:1.6  Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96/Makefile      Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.6 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.7 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-/}
-PKGREVISION=   1
 COMMENT=       Robust, next generation, object-relational DBMS
 
 DEPENDS+=      postgresql96-client>=${PKGVERSION_NOREV}:../../databases/postgresql96-client

Index: pkgsrc/databases/postgresql96/Makefile.common
diff -u pkgsrc/databases/postgresql96/Makefile.common:1.26 pkgsrc/databases/postgresql96/Makefile.common:1.27
--- pkgsrc/databases/postgresql96/Makefile.common:1.26  Fri Aug  7 19:39:40 2020
+++ pkgsrc/databases/postgresql96/Makefile.common       Fri Aug 14 06:56:25 2020
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.26 2020/08/07 19:39:40 maya Exp $
+# $NetBSD: Makefile.common,v 1.27 2020/08/14 06:56:25 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql96-pltcl/Makefile
 # used by databases/postgresql96-server/Makefile
 
-DISTNAME=      postgresql-9.6.18
+DISTNAME=      postgresql-9.6.19
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2

Index: pkgsrc/databases/postgresql96/distinfo
diff -u pkgsrc/databases/postgresql96/distinfo:1.20 pkgsrc/databases/postgresql96/distinfo:1.21
--- pkgsrc/databases/postgresql96/distinfo:1.20 Fri May 15 09:45:01 2020
+++ pkgsrc/databases/postgresql96/distinfo      Fri Aug 14 06:56:25 2020
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.20 2020/05/15 09:45:01 adam Exp $
+$NetBSD: distinfo,v 1.21 2020/08/14 06:56:25 adam Exp $
 
-SHA1 (postgresql-9.6.18.tar.bz2) = 9b01c120d0c16ed111e25f80e791581354a463cd
-RMD160 (postgresql-9.6.18.tar.bz2) = 5b6216a193480c79a4d3a40aeedda91761bf3a2a
-SHA512 (postgresql-9.6.18.tar.bz2) = 78aad7042d22be4486511a9f3b5df2578b65a911b9e969e6196c945d84b9d9a79b40c01a8bdd3859cc67cd9a5d023cca5d83c1360cb14a9bb076ff3b5c1fff70
-Size (postgresql-9.6.18.tar.bz2) = 18836490 bytes
+SHA1 (postgresql-9.6.19.tar.bz2) = 72cde73fffd187bbd2e6c1de6d473cf5578754d2
+RMD160 (postgresql-9.6.19.tar.bz2) = 5efcd29859fefa41cb880ef28b6b5fb082e1d67d
+SHA512 (postgresql-9.6.19.tar.bz2) = 4d8d4a0e4645d71683a5fccb9cd88917e1870ba139f102e0ea82da9c8d1ad669f029e0feb6d409e2016dfd247229ec7daf04f7f2de3ab6c5b4053834ac244a26
+Size (postgresql-9.6.19.tar.bz2) = 18880036 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 14c9564577d0df6f82ae0027aeada2f3a6a8f07c
 SHA1 (patch-configure) = db34614cef013a91dc229be319e5f09c657c3f24

Index: pkgsrc/databases/postgresql96-client/Makefile
diff -u pkgsrc/databases/postgresql96-client/Makefile:1.11 pkgsrc/databases/postgresql96-client/Makefile:1.12
--- pkgsrc/databases/postgresql96-client/Makefile:1.11  Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96-client/Makefile       Fri Aug 14 06:56:25 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.11 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.12 2020/08/14 06:56:25 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-client-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database client programs
 
 .include "../../databases/postgresql96/Makefile.common"

Index: pkgsrc/databases/postgresql96-contrib/Makefile
diff -u pkgsrc/databases/postgresql96-contrib/Makefile:1.10 pkgsrc/databases/postgresql96-contrib/Makefile:1.11
--- pkgsrc/databases/postgresql96-contrib/Makefile:1.10 Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96-contrib/Makefile      Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.11 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-contrib-/}
-PKGREVISION=   1
 COMMENT=       Contrib subtree of tools and plug-ins
 
 .include "../../databases/postgresql96/Makefile.common"

Index: pkgsrc/databases/postgresql96-docs/Makefile
diff -u pkgsrc/databases/postgresql96-docs/Makefile:1.5 pkgsrc/databases/postgresql96-docs/Makefile:1.6
--- pkgsrc/databases/postgresql96-docs/Makefile:1.5     Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96-docs/Makefile Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.5 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.6 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-docs-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database documentation
 
 .include "../../databases/postgresql96/Makefile.common"

Index: pkgsrc/databases/postgresql96-docs/PLIST
diff -u pkgsrc/databases/postgresql96-docs/PLIST:1.18 pkgsrc/databases/postgresql96-docs/PLIST:1.19
--- pkgsrc/databases/postgresql96-docs/PLIST:1.18       Tue May 19 07:05:28 2020
+++ pkgsrc/databases/postgresql96-docs/PLIST    Fri Aug 14 06:56:26 2020
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.18 2020/05/19 07:05:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.19 2020/08/14 06:56:26 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -445,6 +445,7 @@ share/doc/postgresql/html/datetime-confi
 share/doc/postgresql/html/datetime-input-rules.html
 share/doc/postgresql/html/datetime-invalid-input.html
 share/doc/postgresql/html/datetime-keywords.html
+share/doc/postgresql/html/datetime-posix-timezone-specs.html
 share/doc/postgresql/html/datetime-units-history.html
 share/doc/postgresql/html/dblink.html
 share/doc/postgresql/html/ddl-alter.html
@@ -891,6 +892,7 @@ share/doc/postgresql/html/release-9-6-15
 share/doc/postgresql/html/release-9-6-16.html
 share/doc/postgresql/html/release-9-6-17.html
 share/doc/postgresql/html/release-9-6-18.html
+share/doc/postgresql/html/release-9-6-19.html
 share/doc/postgresql/html/release-9-6-2.html
 share/doc/postgresql/html/release-9-6-3.html
 share/doc/postgresql/html/release-9-6-4.html

Index: pkgsrc/databases/postgresql96-plperl/Makefile
diff -u pkgsrc/databases/postgresql96-plperl/Makefile:1.6 pkgsrc/databases/postgresql96-plperl/Makefile:1.7
--- pkgsrc/databases/postgresql96-plperl/Makefile:1.6   Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96-plperl/Makefile       Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-#$ $NetBSD: Makefile,v 1.6 2020/06/02 08:23:30 adam Exp $
+#$ $NetBSD: Makefile,v 1.7 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-plperl-/}
-PKGREVISION=   1
 COMMENT=       PL/Perl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql96-server>=${PKGVERSION_NOREV}:../../databases/postgresql96-server

Index: pkgsrc/databases/postgresql96-plpython/Makefile
diff -u pkgsrc/databases/postgresql96-plpython/Makefile:1.9 pkgsrc/databases/postgresql96-plpython/Makefile:1.10
--- pkgsrc/databases/postgresql96-plpython/Makefile:1.9 Tue Jun  2 08:23:30 2020
+++ pkgsrc/databases/postgresql96-plpython/Makefile     Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:30 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-plpython-/}
-PKGREVISION=   1
 COMMENT=       PL/Python procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql96-server>=${PKGVERSION_NOREV}:../../databases/postgresql96-server

Index: pkgsrc/databases/postgresql96-pltcl/Makefile
diff -u pkgsrc/databases/postgresql96-pltcl/Makefile:1.7 pkgsrc/databases/postgresql96-pltcl/Makefile:1.8
--- pkgsrc/databases/postgresql96-pltcl/Makefile:1.7    Tue Jun  2 08:23:31 2020
+++ pkgsrc/databases/postgresql96-pltcl/Makefile        Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.7 2020/06/02 08:23:31 adam Exp $
+# $NetBSD: Makefile,v 1.8 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-pltcl-/}
-PKGREVISION=   1
 COMMENT=       PL/Tcl procedural language for the PostgreSQL backend
 
 DEPENDS+=      postgresql96-server>=${PKGVERSION_NOREV}:../../databases/postgresql96-server

Index: pkgsrc/databases/postgresql96-server/Makefile
diff -u pkgsrc/databases/postgresql96-server/Makefile:1.9 pkgsrc/databases/postgresql96-server/Makefile:1.10
--- pkgsrc/databases/postgresql96-server/Makefile:1.9   Tue Jun  2 08:23:31 2020
+++ pkgsrc/databases/postgresql96-server/Makefile       Fri Aug 14 06:56:26 2020
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.9 2020/06/02 08:23:31 adam Exp $
+# $NetBSD: Makefile,v 1.10 2020/08/14 06:56:26 adam Exp $
 
 PKGNAME=       ${DISTNAME:S/-/96-server-/}
-PKGREVISION=   1
 COMMENT=       PostgreSQL database server programs
 
 # mips has no TAS implementation



Home | Main Index | Thread Index | Old Index