postgresqlNN: updated to 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25

PostgreSQL 12.1, 11.6, 10.11, 9.6.16, 9.5.20, and 9.4.25 Released!

PostgreSQL 9.4 EOL Approaching

PostgreSQL 9.4 will stop receiving fixes on February 13, 2020, which is the next planned cumulative update release. Please see our versioning policy for more information.

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 may also affect all supported versions.

Some of these fixes include:

Fix crash that occurs when ALTER TABLE adds a column without a default value along with other changes that require a table rewrite
Several fixes for REINDEX CONCURRENTLY.
Fix for VACUUM that would cause it to fail under a specific case involving a still-running transaction.
Fix for a memory leak that could occur when VACUUM runs on a GiST index.
Fix for an error that occurred when running CLUSTER on an expression index.
Fix failure for SET CONSTRAINTS ... DEFERRED on partitioned tables.
Several fixes for the creation and dropping of indexes on partitioned tables.
Fix for partition-wise joins that could lead to planner failures.
Ensure that offset expressions in WINDOW clauses are processed when a query's expressions are manipulated.
Fix misbehavior of bitshiftright() where it failed to zero out padding space in the last byte if the bit string length is not a multiple of 8. For how to correct your data, please see the "Updating" section.
Ensure an empty string that is evaluated by the position() functions returns 1, as per the SQL standard.
Fix for a parallel query failure when it is unable to request a background worker.
Fix crash triggered by a case involving a BEFORE UPDATE trigger.
Display the correct error when a query tries to access a TOAST table.
Allow encoding conversion to succeed on strings with output up to 1GB. Previously there was hard limit of 0.25GB on the input string.
Ensure that temporary WAL and history files are removed at the end of archive recovery.
Avoid failure in archive recovery if recovery_min_apply_delay is enabled.
Ignore restore_command, recovery_end_command, and recovery_min_apply_delay settings during crash recovery.
Several fixes for logical replication, including a failure when the publisher and subscriber had different REPLICA IDENTITY columns set.
Correctly timestamp replication messages for logical decoding, which in the broken case would lead to pg_stat_subscription.last_msg_send_time set to NULL.
Several fixes for libpq, including one that improves PostgreSQL 12 compatibility.
Several pg_upgrade fixes.
Fix how a parallel restore handles foreign key constraints on partitioned tables to ensure they are not created too soon.
pg_dump now outputs similarly named triggers and RLS policies in order based on table name, instead of OID.
Fix pg_rewind to not update the contents of pg_control when using the --dry-run option.

This update also contains tzdata release 2019c for DST law changes in Fiji and Norfolk Island. Historical corrections for Alberta, Austria, Belgium, British Columbia, Cambodia, Hong Kong, Indiana (Perry County), Kaliningrad, Kentucky, Michigan, Norfolk Island, South Korea, and Turkey.

19 files changed, 70 insertions, 62 deletions

diff --git a/databases/postgresql10-docs/PLIST b/databases/postgresql10-docs/PLIST
index b947d2258ef..6c5703ccaa8 100644
--- a/databases/postgresql10-docs/PLIST
+++ b/databases/postgresql10-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2019/08/11 11:40:10 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2019/11/19 05:54:51 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -910,6 +910,7 @@ share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
 share/doc/postgresql/html/release-10-1.html
 share/doc/postgresql/html/release-10-10.html
+share/doc/postgresql/html/release-10-11.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
@@ -1331,6 +1332,7 @@ share/doc/postgresql/html/xfunc-sql.html
 share/doc/postgresql/html/xfunc-volatility.html
 share/doc/postgresql/html/xfunc.html
 share/doc/postgresql/html/xindex.html
+share/doc/postgresql/html/xml-limits-conformance.html
 share/doc/postgresql/html/xml2.html
 share/doc/postgresql/html/xoper-optimization.html
 share/doc/postgresql/html/xoper.html
diff --git a/databases/postgresql10-plpython/PLIST b/databases/postgresql10-plpython/PLIST
index f1f555d0565..7c0787a93a5 100644
--- a/databases/postgresql10-plpython/PLIST
+++ b/databases/postgresql10-plpython/PLIST
@@ -1,23 +1,23 @@
-@comment $NetBSD: PLIST,v 1.4 2019/10/25 12:01:19 triaxx Exp $
+@comment $NetBSD: PLIST,v 1.5 2019/11/19 05:54:51 adam Exp $
 include/postgresql/server/plpy_util.h
 include/postgresql/server/plpython.h
 ${PLIST.py2x}lib/postgresql/hstore_plpython2.so
 ${PLIST.py3x}lib/postgresql/hstore_plpython3.so
 ${PLIST.py2x}lib/postgresql/plpython2.so
 ${PLIST.py3x}lib/postgresql/plpython3.so
-${PLIST}share/locale/cs/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/de/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/es/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/fr/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/it/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/ja/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/ko/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/pl/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/pt_BR/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/ru/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/sv/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/tr/LC_MESSAGES/plpython-10.mo
-${PLIST}share/locale/zh_CN/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/cs/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/de/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/es/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/fr/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/it/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/ja/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/ko/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/pl/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/pt_BR/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/ru/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/sv/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/tr/LC_MESSAGES/plpython-10.mo
+${PLIST.nls}share/locale/zh_CN/LC_MESSAGES/plpython-10.mo
 share/postgresql/extension/hstore_plpython2u--1.0.sql
 share/postgresql/extension/hstore_plpython2u.control
 share/postgresql/extension/hstore_plpython3u--1.0.sql
diff --git a/databases/postgresql10/Makefile.common b/databases/postgresql10/Makefile.common
index c135af7c1be..b317067c967 100644
--- a/databases/postgresql10/Makefile.common
+++ b/databases/postgresql10/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.17 2019/11/02 15:38:07 rillig Exp $
+# $NetBSD: Makefile.common,v 1.18 2019/11/19 05:54:51 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql10-pltcl/Makefile
 # used by databases/postgresql10-server/Makefile
 
-DISTNAME=	postgresql-10.10
+DISTNAME=	postgresql-10.11
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql10/distinfo b/databases/postgresql10/distinfo
index b1420d89105..be9433b4c3b 100644
--- a/databases/postgresql10/distinfo
+++ b/databases/postgresql10/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.12 2019/08/11 11:40:10 adam Exp $
+$NetBSD: distinfo,v 1.13 2019/11/19 05:54:51 adam Exp $
 
-SHA1 (postgresql-10.10.tar.bz2) = 388b082ea05e385f42ce1521f1a9f7d11561227b
-RMD160 (postgresql-10.10.tar.bz2) = e09deca5db2789d2d35a715fb2a8ff85c4736bb4
-SHA512 (postgresql-10.10.tar.bz2) = 60cafe4b27a194949aff482dcce4fa096a9916f37205868437a32afb8964df71934b619a0b891fe85eb7c7f9b11775cffbbedca589e78feb6c4184eb224b48bc
-Size (postgresql-10.10.tar.bz2) = 19012049 bytes
+SHA1 (postgresql-10.11.tar.bz2) = 39ce96ff01f7bf10163fccde19084ace2061f545
+RMD160 (postgresql-10.11.tar.bz2) = 199b583510d821969fd9a7d35539b73165d8ed8a
+SHA512 (postgresql-10.11.tar.bz2) = ce90b34e74d423b6db1f0e840b8e09579965c020fa2cfe3e567b604d3354d91e00a4347d559876be829aa89db44f84736e154495708ba9908f1d850446a1fc7b
+Size (postgresql-10.11.tar.bz2) = 19017947 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql11-docs/PLIST b/databases/postgresql11-docs/PLIST
index 0831861f251..d702da84a1f 100644
--- a/databases/postgresql11-docs/PLIST
+++ b/databases/postgresql11-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2019/08/11 11:40:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2019/11/19 05:54:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -949,6 +949,7 @@ share/doc/postgresql/html/release-11-2.html
 share/doc/postgresql/html/release-11-3.html
 share/doc/postgresql/html/release-11-4.html
 share/doc/postgresql/html/release-11-5.html
+share/doc/postgresql/html/release-11-6.html
 share/doc/postgresql/html/release-11.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
@@ -1376,6 +1377,7 @@ share/doc/postgresql/html/xfunc-sql.html
 share/doc/postgresql/html/xfunc-volatility.html
 share/doc/postgresql/html/xfunc.html
 share/doc/postgresql/html/xindex.html
+share/doc/postgresql/html/xml-limits-conformance.html
 share/doc/postgresql/html/xml2.html
 share/doc/postgresql/html/xoper-optimization.html
 share/doc/postgresql/html/xoper.html
diff --git a/databases/postgresql11/Makefile.common b/databases/postgresql11/Makefile.common
index 5c342cbf9c6..b5354efc88b 100644
--- a/databases/postgresql11/Makefile.common
+++ b/databases/postgresql11/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.10 2019/11/02 15:38:07 rillig Exp $
+# $NetBSD: Makefile.common,v 1.11 2019/11/19 05:54:51 adam Exp $
 #
 # This Makefile fragment is included by all PostgreSQL packages built from
 # the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
 # used by databases/postgresql11-pltcl/Makefile
 # used by databases/postgresql11-server/Makefile
 
-DISTNAME=	postgresql-11.5
+DISTNAME=	postgresql-11.6
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql11/distinfo b/databases/postgresql11/distinfo
index a18404b066f..6c440580466 100644
--- a/databases/postgresql11/distinfo
+++ b/databases/postgresql11/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.6 2019/08/11 11:40:10 adam Exp $
+$NetBSD: distinfo,v 1.7 2019/11/19 05:54:51 adam Exp $
 
-SHA1 (postgresql-11.5.tar.bz2) = 24ceee589a0aec775ea7c4c4a001c710ff27a0d4
-RMD160 (postgresql-11.5.tar.bz2) = 01e22d6f7ec31c89531ebfdb474f997eeaaa992c
-SHA512 (postgresql-11.5.tar.bz2) = 537148079dc6c33cfb9bf9722171e524707b42ef01369deb968d0d6e8fa9b7f16f6ce67139d9dc45fb7385defbf56aa2c0affe5ee9d76e996f31e47486192141
-Size (postgresql-11.5.tar.bz2) = 19773087 bytes
+SHA1 (postgresql-11.6.tar.bz2) = 96e0022f13834ba5eb8a0c223296f9a03628849f
+RMD160 (postgresql-11.6.tar.bz2) = 83a253a51e4d2de8c1752b07b21b9d49b2e987f4
+SHA512 (postgresql-11.6.tar.bz2) = de6833c0df8dbac7bc498ac573dc4c3645070d9bbdd6b5d89db3ef41e86e7fc19d5e6450aa46ee2a1392d86c33acf6b9364b2863caac49f45351a46647feecbd
+Size (postgresql-11.6.tar.bz2) = 19843202 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql12-docs/PLIST b/databases/postgresql12-docs/PLIST
index 0fd3f48bc23..fbdf9709770 100644
--- a/databases/postgresql12-docs/PLIST
+++ b/databases/postgresql12-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2019/10/07 19:21:49 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2019/11/19 05:54:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -951,6 +951,7 @@ share/doc/postgresql/html/regress-run.html
 share/doc/postgresql/html/regress-tap.html
 share/doc/postgresql/html/regress-variant.html
 share/doc/postgresql/html/regress.html
+share/doc/postgresql/html/release-12-1.html
 share/doc/postgresql/html/release-12.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff --git a/databases/postgresql12/Makefile.common b/databases/postgresql12/Makefile.common
index 4b94165a9bd..efce693c25c 100644
--- a/databases/postgresql12/Makefile.common
+++ b/databases/postgresql12/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.3 2019/11/02 15:38:07 rillig Exp $
+# $NetBSD: Makefile.common,v 1.4 2019/11/19 05:54:52 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.0
+DISTNAME=	postgresql-12.1
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql12/distinfo b/databases/postgresql12/distinfo
index 0a75bb59cec..585060cd2fb 100644
--- a/databases/postgresql12/distinfo
+++ b/databases/postgresql12/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.1 2019/10/07 19:21:48 adam Exp $
+$NetBSD: distinfo,v 1.2 2019/11/19 05:54:52 adam Exp $
 
-SHA1 (postgresql-12.0.tar.bz2) = bed695e1c6846337d5297439ef76969f5c9fdc20
-RMD160 (postgresql-12.0.tar.bz2) = 3633b7841072a1c81b521ad5383fca9200d44ee8
-SHA512 (postgresql-12.0.tar.bz2) = 231a0b5c181c33cb01c3f39de1802319b79eceec6997935ab8605dea1f4583a52d0d16e5a70fcdeea313462f062503361d543433ee03d858ba332c72a665f696
-Size (postgresql-12.0.tar.bz2) = 20177458 bytes
+SHA1 (postgresql-12.1.tar.bz2) = b9bd13230fa02a4d0105e92d15d56e7842119e26
+RMD160 (postgresql-12.1.tar.bz2) = 617b02e7d045b902a04adeed65b88ce93ff86e40
+SHA512 (postgresql-12.1.tar.bz2) = f45b1762fd60b6f7419305d108b7fc521e3a7afa833d3aacccba814465baf40d19f57ff9bf2909d726c4c94a1cd99a39f1aa8e45fd0364cdedbcbed36ff48caf
+Size (postgresql-12.1.tar.bz2) = 20213711 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff --git a/databases/postgresql94-docs/PLIST b/databases/postgresql94-docs/PLIST
index a9a7addd774..138cbf0583f 100644
--- a/databases/postgresql94-docs/PLIST
+++ b/databases/postgresql94-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.26 2019/08/11 11:40:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.27 2019/11/19 05:54:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -863,6 +863,7 @@ share/doc/postgresql/html/release-9-4-21.html
 share/doc/postgresql/html/release-9-4-22.html
 share/doc/postgresql/html/release-9-4-23.html
 share/doc/postgresql/html/release-9-4-24.html
+share/doc/postgresql/html/release-9-4-25.html
 share/doc/postgresql/html/release-9-4-3.html
 share/doc/postgresql/html/release-9-4-4.html
 share/doc/postgresql/html/release-9-4-5.html
diff --git a/databases/postgresql94/Makefile.common b/databases/postgresql94/Makefile.common
index 2b66c0c7b7e..d4426f2dcc3 100644
--- a/databases/postgresql94/Makefile.common
+++ b/databases/postgresql94/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.35 2019/11/02 15:38:08 rillig Exp $
+# $NetBSD: Makefile.common,v 1.36 2019/11/19 05:54:52 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/postgresql94-pltcl/Makefile
 # used by databases/postgresql94-server/Makefile
 
-DISTNAME=	postgresql-9.4.24
+DISTNAME=	postgresql-9.4.25
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql94/distinfo b/databases/postgresql94/distinfo
index faa3f4fd892..f83e0a63e29 100644
--- a/databases/postgresql94/distinfo
+++ b/databases/postgresql94/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.28 2019/08/11 11:40:11 adam Exp $
+$NetBSD: distinfo,v 1.29 2019/11/19 05:54:52 adam Exp $
 
-SHA1 (postgresql-9.4.24.tar.bz2) = c1b28864ff6a3799de897921b50c75301fad2d29
-RMD160 (postgresql-9.4.24.tar.bz2) = ef2761b5c01444d0c5ebb0b6c15a97fba02aa9fd
-SHA512 (postgresql-9.4.24.tar.bz2) = 8e7b4da8a5cf48cf4d98cce117614f7ab594087d0002f996c1fedc2a38af6eaa663ad3ce67ced6d6b0fd6d0b00aee932025bf50a4314933ba535716577e9393f
-Size (postgresql-9.4.24.tar.bz2) = 16842941 bytes
+SHA1 (postgresql-9.4.25.tar.bz2) = 7424a2e160cf5c91de3b0522e2f903d93824670b
+RMD160 (postgresql-9.4.25.tar.bz2) = 7e7f789db88749010fabbb4b1edf8dfad3d8bfb8
+SHA512 (postgresql-9.4.25.tar.bz2) = be45c47a17788be40a2beca058b5dcbf1ded985838d1c85229fbece174fca222d5ac07025c764d40c92f823d6bf784975a25b79a545b903434be8bcd24efb9a0
+Size (postgresql-9.4.25.tar.bz2) = 16849015 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 14c9564577d0df6f82ae0027aeada2f3a6a8f07c
 SHA1 (patch-configure) = 1c0fee3fb270863eb39118a65769ce170391cfec
diff --git a/databases/postgresql95-docs/PLIST b/databases/postgresql95-docs/PLIST
index 9273f8b5687..63a543cfc40 100644
--- a/databases/postgresql95-docs/PLIST
+++ b/databases/postgresql95-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.19 2019/08/11 11:40:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.20 2019/11/19 05:54:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -879,6 +879,7 @@ share/doc/postgresql/html/release-9-5-17.html
 share/doc/postgresql/html/release-9-5-18.html
 share/doc/postgresql/html/release-9-5-19.html
 share/doc/postgresql/html/release-9-5-2.html
+share/doc/postgresql/html/release-9-5-20.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
diff --git a/databases/postgresql95/Makefile.common b/databases/postgresql95/Makefile.common
index 5d5321200d9..cf1154461b9 100644
--- a/databases/postgresql95/Makefile.common
+++ b/databases/postgresql95/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.28 2019/11/02 15:38:08 rillig Exp $
+# $NetBSD: Makefile.common,v 1.29 2019/11/19 05:54:52 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.19
+DISTNAME=	postgresql-9.5.20
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql95/distinfo b/databases/postgresql95/distinfo
index 0814c4f0bf4..d0af7c8fe67 100644
--- a/databases/postgresql95/distinfo
+++ b/databases/postgresql95/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.21 2019/08/11 11:40:11 adam Exp $
+$NetBSD: distinfo,v 1.22 2019/11/19 05:54:52 adam Exp $
 
-SHA1 (postgresql-9.5.19.tar.bz2) = 9b0dcf4940e47c857200f37b8f4b00421a087958
-RMD160 (postgresql-9.5.19.tar.bz2) = bb7383430d9f52fac454b576601b7e9e837d2cfd
-SHA512 (postgresql-9.5.19.tar.bz2) = 46de40e49910311bf5291e1ece421ab9628641b18bf84cd1cb8093a584dd0358e3b6d2b086f82e9b06ce699a6e38018c3515ea591355078392e8d3d2fe4a7c64
-Size (postgresql-9.5.19.tar.bz2) = 17571998 bytes
+SHA1 (postgresql-9.5.20.tar.bz2) = 363dfb999d3f6f347f51c01de5953f0e3d3a8cd0
+RMD160 (postgresql-9.5.20.tar.bz2) = 768fe33d653ec872033d268bcbc3a6ac2b1cdd4f
+SHA512 (postgresql-9.5.20.tar.bz2) = 75558d05f6bee6fad65ad0b4dcb428b50bcf003c4fbd878747010988958464d7119dd8121a8817c3cad83c20bcae6cd550fc01fbca39f54e670d93fc70688bea
+Size (postgresql-9.5.20.tar.bz2) = 17610134 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 14c9564577d0df6f82ae0027aeada2f3a6a8f07c
 SHA1 (patch-configure) = 18dd4af7f043b090beda157dfd52531b551eafd0
diff --git a/databases/postgresql96-docs/PLIST b/databases/postgresql96-docs/PLIST
index a6a2a594c2d..895fc28e93e 100644
--- a/databases/postgresql96-docs/PLIST
+++ b/databases/postgresql96-docs/PLIST
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.15 2019/08/11 11:40:11 adam Exp $
+@comment $NetBSD: PLIST,v 1.16 2019/11/19 05:54:53 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -888,6 +888,7 @@ share/doc/postgresql/html/release-9-6-12.html
 share/doc/postgresql/html/release-9-6-13.html
 share/doc/postgresql/html/release-9-6-14.html
 share/doc/postgresql/html/release-9-6-15.html
+share/doc/postgresql/html/release-9-6-16.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
diff --git a/databases/postgresql96/Makefile.common b/databases/postgresql96/Makefile.common
index 17893063a4d..152e13cfab1 100644
--- a/databases/postgresql96/Makefile.common
+++ b/databases/postgresql96/Makefile.common
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.22 2019/11/02 15:38:08 rillig Exp $
+# $NetBSD: Makefile.common,v 1.23 2019/11/19 05:54:52 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.15
+DISTNAME=	postgresql-9.6.16
 CATEGORIES=	databases
 MASTER_SITES=	${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=	.tar.bz2
diff --git a/databases/postgresql96/distinfo b/databases/postgresql96/distinfo
index 544a921bb25..a40d58b5ed9 100644
--- a/databases/postgresql96/distinfo
+++ b/databases/postgresql96/distinfo
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.17 2019/08/11 11:40:11 adam Exp $
+$NetBSD: distinfo,v 1.18 2019/11/19 05:54:52 adam Exp $
 
-SHA1 (postgresql-9.6.15.tar.bz2) = 2375ff8387ed746093f575f2cc69a2dabb5d15ce
-RMD160 (postgresql-9.6.15.tar.bz2) = 54bc598b717cf19b21fa1c70df797e1085eaafac
-SHA512 (postgresql-9.6.15.tar.bz2) = cc35a059bf59ea3487c17a8432b791ca2a19afaa24b07403a8d33904b3a97ebe601e3036ca8ec766c54cb87a7def7d4618a425a4446e6832391185d7c71117db
-Size (postgresql-9.6.15.tar.bz2) = 18799121 bytes
+SHA1 (postgresql-9.6.16.tar.bz2) = 5fff91ee210a475dc41cbc39f5a596ae17a1513f
+RMD160 (postgresql-9.6.16.tar.bz2) = ee94f8721947a50c2e21e952fe1dbec71984e592
+SHA512 (postgresql-9.6.16.tar.bz2) = 7083d670883b203946f68bcf1216dd1cbd904220b4c95e25855f9a8904334fd7e87509c905f589398ad7b165869b75288c2e4f49b14263ce4891347ecd4485b4
+Size (postgresql-9.6.16.tar.bz2) = 18806372 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = 14c9564577d0df6f82ae0027aeada2f3a6a8f07c
 SHA1 (patch-configure) = db34614cef013a91dc229be319e5f09c657c3f24