[pkgsrc/trunk]: pkgsrc/databases postgresql: updated to 14.1, 13.5, 12.9, 11....

[adam <adam%pkgsrc.org@localhost>]

details:   https://anonhg.NetBSD.org/pkgsrc/rev/ea0f869e03fb
branches:  trunk
changeset: 769546:ea0f869e03fb
user:      adam <adam%pkgsrc.org@localhost>
date:      Tue Nov 16 10:14:36 2021 +0000

description:
postgresql: updated to 14.1, 13.5, 12.9, 11.14, 10.19, 9.6.24

PostgreSQL 14.1, 13.5, 12.9, 11.14, 10.19, and 9.6.24

Security Issues

CVE-2021-23214: Server processes unencrypted bytes from man-in-the-middle

Versions Affected: 9.6 - 14. The security team typically does not test unsupported versions, but this problem is quite old.

When the server is configured to use trust authentication with a clientcert requirement or to use cert authentication, a man-in-the-middle attacker can inject arbitrary SQL queries when a connection 
is first established, despite the use of SSL certificate verification and encryption.

The PostgreSQL project thanks Jacob Champion for reporting this problem.

CVE-2021-23222: libpq processes unencrypted bytes from man-in-the-middle

Versions Affected: 9.6 - 14. The security team typically does not test unsupported versions, but this problem is quite old.

A man-in-the-middle attacker can inject false responses to the client's first few queries, despite the use of SSL certificate verification and encryption.

If more preconditions hold, the attacker can exfiltrate the client's password or other confidential data that might be transmitted early in a session. The attacker must have a way to trick the 
client's intended server into making the confidential data accessible to the attacker. A known implementation having that property is a PostgreSQL configuration vulnerable to CVE-2021-23214.

As with any exploitation of CVE-2021-23214, the server must be using trust authentication with a clientcert requirement or using cert authentication. To disclose a password, the client must be in 
possession of a password, which is atypical when using an authentication configuration vulnerable to CVE-2021-23214. The attacker must have some other way to access the server to retrieve the 
exfiltrated data (a valid, unprivileged login account would be sufficient).

The PostgreSQL project thanks Jacob Champion for reporting this problem.

Bug Fixes and Improvements

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

Some of these fixes include:

Fix physical replication for cases where the primary crashes after shipping a WAL segment that ends with a partial WAL record. When applying this update, update your standby servers before the 
primary so that they will be ready to handle the fix if the primary happens to crash.
Fix parallel VACUUM so that it will process indexes below the min_parallel_index_scan_size threshold if the table has at least two indexes that are above that size. This problem does not affect 
autovacuum. If you are affected by this issue, you should reindex any manually-vacuumed tables.
Fix causes of CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY writing corrupt indexes. You should reindex any concurrently-built indexes.
Fix for attaching/detaching a partition that could allow certain INSERT/UPDATE queries to misbehave in active sessions.
Fix for creating a new range type with CREATE TYPE that could cause problems for later event triggers or subsequent executions of the CREATE TYPE command.
Fix updates of element fields in arrays of a domain that is a part of a composite.
Disallow the combination of FETCH FIRST WITH TIES and FOR UPDATE SKIP LOCKED.
Fix corner-case loss of precision in the numeric power() function.
Fix restoration of a Portal's snapshot inside a subtransaction, which could lead to a crash. For example, this could occur in PL/pgSQL when a COMMIT is immediately followed by a BEGIN ... EXCEPTION 
block that performs a query.
Clean up correctly if a transaction fails after exporting its snapshot. This could occur if a replication slot was created then rolled back, and then another replication slot was created in the same 
session.
Fix for "overflowed-subtransaction" wraparound tracking on standby servers that could lead to performance degradation.
Ensure that prepared transactions are properly accounted for during promotion of a standby server.
Ensure that the correct lock level is used when renaming a table.
Avoid crash when dropping a role that owns objects being dropped concurrently.
Disallow setting huge_pages to on when shared_memory_type is sysv
Fix query type checking in the PL/pgSQL RETURN QUERY.
Several fixes for pg_dump, including the ability to dump non-global default privileges correctly.
Use the CLDR project's data to map Windows time zone names to IANA time zones.
This update also contains tzdata release 2021e for DST law changes in Fiji, Jordan, Palestine, and Samoa, plus historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga.

Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. Also, the following zones have been merged into nearby, more-populous zones whose clocks have agreed with them since 1970: 
Africa/Accra, America/Atikokan, America/Blanc-Sablon, America/Creston, America/Curacao, America/Nassau, America/Port_of_Spain, Antarctica/DumontDUrville, and Antarctica/Syowa. In all these cases, the 
previous zone name remains as an alias.

diffstat:

 databases/postgresql10-docs/PLIST      |  3 ++-
 databases/postgresql10-server/PLIST    |  3 ++-
 databases/postgresql10/Makefile.common |  4 ++--
 databases/postgresql10/distinfo        |  8 ++++----
 databases/postgresql11-docs/PLIST      |  3 ++-
 databases/postgresql11-server/PLIST    |  3 ++-
 databases/postgresql11/Makefile.common |  4 ++--
 databases/postgresql11/distinfo        |  8 ++++----
 databases/postgresql12-docs/PLIST      |  3 ++-
 databases/postgresql12-server/PLIST    |  3 ++-
 databases/postgresql12/Makefile.common |  4 ++--
 databases/postgresql12/distinfo        |  8 ++++----
 databases/postgresql13-client/PLIST    |  3 ++-
 databases/postgresql13-docs/PLIST      |  3 ++-
 databases/postgresql13-server/PLIST    |  3 ++-
 databases/postgresql13/Makefile.common |  4 ++--
 databases/postgresql13/distinfo        |  8 ++++----
 databases/postgresql14-client/PLIST    |  4 +++-
 databases/postgresql14-docs/PLIST      |  3 ++-
 databases/postgresql14-plperl/PLIST    |  3 ++-
 databases/postgresql14-server/PLIST    |  3 ++-
 databases/postgresql14/Makefile.common |  4 ++--
 databases/postgresql14/distinfo        |  8 ++++----
 databases/postgresql96-docs/PLIST      |  3 ++-
 databases/postgresql96-server/PLIST    |  3 ++-
 databases/postgresql96/Makefile.common |  4 ++--
 databases/postgresql96/distinfo        |  8 ++++----
 27 files changed, 67 insertions(+), 51 deletions(-)

diffs (truncated from 468 to 300 lines):

diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql10-docs/PLIST
--- a/databases/postgresql10-docs/PLIST Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql10-docs/PLIST Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.19 2021/08/13 11:54:44 adam Exp $
+@comment $NetBSD: PLIST,v 1.20 2021/11/16 10:14:36 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -927,6 +927,7 @@
 share/doc/postgresql/html/release-10-16.html
 share/doc/postgresql/html/release-10-17.html
 share/doc/postgresql/html/release-10-18.html
+share/doc/postgresql/html/release-10-19.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
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql10-server/PLIST
--- a/databases/postgresql10-server/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql10-server/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2020/05/15 20:45:36 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2021/11/16 10:14:37 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -617,6 +617,7 @@
 share/postgresql/timezone/Pacific/Guam
 share/postgresql/timezone/Pacific/Honolulu
 share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kanton
 share/postgresql/timezone/Pacific/Kiritimati
 share/postgresql/timezone/Pacific/Kosrae
 share/postgresql/timezone/Pacific/Kwajalein
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql10/Makefile.common
--- a/databases/postgresql10/Makefile.common    Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql10/Makefile.common    Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.30 2021/08/13 11:54:43 adam Exp $
+# $NetBSD: Makefile.common,v 1.31 2021/11/16 10:14:36 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.18
+DISTNAME=      postgresql-10.19
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql10/distinfo
--- a/databases/postgresql10/distinfo   Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql10/distinfo   Tue Nov 16 10:14:36 2021 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.24 2021/10/26 10:09:47 nia Exp $
+$NetBSD: distinfo,v 1.25 2021/11/16 10:14:36 adam Exp $
 
-BLAKE2s (postgresql-10.18.tar.bz2) = 9088e58fc0bf10b544914b52f02d50928c930ec86bc593dc42517feb824914ff
-SHA512 (postgresql-10.18.tar.bz2) = 8a564256b0a5f6375a817cc5db14e56f7f7ee831881a2dc78759e7f2cf708d95fb61ad75a01f13fb05517ab165c991794d837bbb93f60d54f4fb33ca0ac45729
-Size (postgresql-10.18.tar.bz2) = 19197042 bytes
+BLAKE2s (postgresql-10.19.tar.bz2) = fc851119bc8796bb1d7a27313bbd685583c6667634d073795e1f3a06d336c0b6
+SHA512 (postgresql-10.19.tar.bz2) = 41b0f5026be7d563e41b54e9ea7199dd466a132d355be0b71a91d41f533d97fbf550eccf2a2ece3d60c5dab5921ebeea3ac4780c18c54b924df52d7423305a22
+Size (postgresql-10.19.tar.bz2) = 19261478 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql11-docs/PLIST
--- a/databases/postgresql11-docs/PLIST Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql11-docs/PLIST Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.14 2021/08/13 11:54:45 adam Exp $
+@comment $NetBSD: PLIST,v 1.15 2021/11/16 10:14:37 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -958,6 +958,7 @@
 share/doc/postgresql/html/release-11-11.html
 share/doc/postgresql/html/release-11-12.html
 share/doc/postgresql/html/release-11-13.html
+share/doc/postgresql/html/release-11-14.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
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql11-server/PLIST
--- a/databases/postgresql11-server/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql11-server/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2020/05/15 20:31:41 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2021/11/16 10:14:37 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -1271,6 +1271,7 @@
 share/postgresql/timezone/Pacific/Guam
 share/postgresql/timezone/Pacific/Honolulu
 share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kanton
 share/postgresql/timezone/Pacific/Kiritimati
 share/postgresql/timezone/Pacific/Kosrae
 share/postgresql/timezone/Pacific/Kwajalein
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql11/Makefile.common
--- a/databases/postgresql11/Makefile.common    Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql11/Makefile.common    Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.23 2021/08/13 11:54:44 adam Exp $
+# $NetBSD: Makefile.common,v 1.24 2021/11/16 10:14:37 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.13
+DISTNAME=      postgresql-11.14
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql11/distinfo
--- a/databases/postgresql11/distinfo   Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql11/distinfo   Tue Nov 16 10:14:36 2021 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.19 2021/10/26 10:09:47 nia Exp $
+$NetBSD: distinfo,v 1.20 2021/11/16 10:14:37 adam Exp $
 
-BLAKE2s (postgresql-11.13.tar.bz2) = 255c94b9c1e51cc16f6c6fe4439aebc13cef0bd7d899d9b0059b9cb49b07ca3b
-SHA512 (postgresql-11.13.tar.bz2) = 1b2061d505a7460e0aaae53818e77fc99fa7b73eea119033a98a3d7dd3d70d00403998654990b03bbf6eb2df383e2f44791137c8922ea4015715f8bf49c5837f
-Size (postgresql-11.13.tar.bz2) = 20123787 bytes
+BLAKE2s (postgresql-11.14.tar.bz2) = 54eff3d77ba619e5c132e4617d16f9a3e2016306e5b8083e017deec1a26f7820
+SHA512 (postgresql-11.14.tar.bz2) = ab71461ee6fb4cdc5b4240f7ecd8af2497ce6780283fde2abf5951ffdb616bd0c8ed22b26fdfca402a346e663ff77c4d17f3284c9d700e6fd6795b2aec97c9be
+Size (postgresql-11.14.tar.bz2) = 20172910 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql12-docs/PLIST
--- a/databases/postgresql12-docs/PLIST Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql12-docs/PLIST Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2021/08/13 11:54:46 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2021/11/16 10:14:37 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -969,6 +969,7 @@
 share/doc/postgresql/html/release-12-6.html
 share/doc/postgresql/html/release-12-7.html
 share/doc/postgresql/html/release-12-8.html
+share/doc/postgresql/html/release-12-9.html
 share/doc/postgresql/html/release-12.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql12-server/PLIST
--- a/databases/postgresql12-server/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql12-server/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2020/08/14 06:56:24 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2021/11/16 10:14:37 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -1287,6 +1287,7 @@
 share/postgresql/timezone/Pacific/Guam
 share/postgresql/timezone/Pacific/Honolulu
 share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kanton
 share/postgresql/timezone/Pacific/Kiritimati
 share/postgresql/timezone/Pacific/Kosrae
 share/postgresql/timezone/Pacific/Kwajalein
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql12/Makefile.common
--- a/databases/postgresql12/Makefile.common    Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql12/Makefile.common    Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.16 2021/08/13 11:54:45 adam Exp $
+# $NetBSD: Makefile.common,v 1.17 2021/11/16 10:14:37 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.8
+DISTNAME=      postgresql-12.9
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql12/distinfo
--- a/databases/postgresql12/distinfo   Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql12/distinfo   Tue Nov 16 10:14:36 2021 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.13 2021/10/26 10:09:47 nia Exp $
+$NetBSD: distinfo,v 1.14 2021/11/16 10:14:37 adam Exp $
 
-BLAKE2s (postgresql-12.8.tar.bz2) = febcd6677e7e0b91ba288c1477fdb25e083bb62fdd8be63509df1ae9416fa5fd
-SHA512 (postgresql-12.8.tar.bz2) = 970fe1041e427ac1c8a786c93e2079b0a9c8b3fcaf9d38877894eb02e8a9afc7cd73d7ac28078c455845a922a1b7d9c1e22cb7990d8d523dd6496af9442fba01
-Size (postgresql-12.8.tar.bz2) = 20849478 bytes
+BLAKE2s (postgresql-12.9.tar.bz2) = 49e63f4232284b7e3571ca903d0545be889342c15fec3729c4ab4adc16d53ba8
+SHA512 (postgresql-12.9.tar.bz2) = 11697d8283f5df5a9c74c2406e94d1b6da6df8358ad48f3b773825aab98e8395f9fd4e3fc8b1e6ebad3743c3dadbda8b795d4fe84a447d7913223e136cf2b88f
+Size (postgresql-12.9.tar.bz2) = 20904260 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = b0a758023b3b263ff51b154d0da32cf02520c6cd
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql13-client/PLIST
--- a/databases/postgresql13-client/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql13-client/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.4 2021/05/18 11:56:19 adam Exp $
+@comment $NetBSD: PLIST,v 1.5 2021/11/16 10:14:38 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -128,6 +128,7 @@
 include/postgresql/server/access/twophase_rmgr.h
 include/postgresql/server/access/valid.h
 include/postgresql/server/access/visibilitymap.h
+include/postgresql/server/access/visibilitymapdefs.h
 include/postgresql/server/access/xact.h
 include/postgresql/server/access/xlog.h
 include/postgresql/server/access/xlog_internal.h
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql13-docs/PLIST
--- a/databases/postgresql13-docs/PLIST Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql13-docs/PLIST Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.5 2021/08/13 11:54:47 adam Exp $
+@comment $NetBSD: PLIST,v 1.6 2021/11/16 10:14:38 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createuser.1
@@ -973,6 +973,7 @@
 share/doc/postgresql/html/release-13-2.html
 share/doc/postgresql/html/release-13-3.html
 share/doc/postgresql/html/release-13-4.html
+share/doc/postgresql/html/release-13-5.html
 share/doc/postgresql/html/release-13.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql13-server/PLIST
--- a/databases/postgresql13-server/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql13-server/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2021/04/01 10:22:23 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2021/11/16 10:14:38 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -1288,6 +1288,7 @@
 share/postgresql/timezone/Pacific/Guam
 share/postgresql/timezone/Pacific/Honolulu
 share/postgresql/timezone/Pacific/Johnston
+share/postgresql/timezone/Pacific/Kanton
 share/postgresql/timezone/Pacific/Kiritimati
 share/postgresql/timezone/Pacific/Kosrae
 share/postgresql/timezone/Pacific/Kwajalein
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql13/Makefile.common
--- a/databases/postgresql13/Makefile.common    Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql13/Makefile.common    Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.9 2021/08/13 11:54:46 adam Exp $
+# $NetBSD: Makefile.common,v 1.10 2021/11/16 10:14:37 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.4
+DISTNAME=      postgresql-13.5
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql13/distinfo
--- a/databases/postgresql13/distinfo   Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql13/distinfo   Tue Nov 16 10:14:36 2021 +0000
@@ -1,8 +1,8 @@
-$NetBSD: distinfo,v 1.9 2021/10/26 10:09:47 nia Exp $
+$NetBSD: distinfo,v 1.10 2021/11/16 10:14:37 adam Exp $
 
-BLAKE2s (postgresql-13.4.tar.bz2) = 865fb6dd2d29848fd8ba2241af932e97c02ab20796846ada7c557fb4c4d19668
-SHA512 (postgresql-13.4.tar.bz2) = f1faf676ffdcee3e7f2c3b78f4badf44770d6be58090036d119d8fb0688e2b9f9159dd44fe850c179b8e23f256942c05edb8fcc385f0e852d16b37eace785b5a
-Size (postgresql-13.4.tar.bz2) = 21157443 bytes
+BLAKE2s (postgresql-13.5.tar.bz2) = d57be90445afc8f6680aa3b0c7a314352437adc08f0a3559751b5036c59bd2a6
+SHA512 (postgresql-13.5.tar.bz2) = c76effbca8ee63be48fa3aeb39c7038221848fe83ca2afc4e0904ba8c6a50b89aa2ad37080d4e3be75e9bdc2d6ca6dfefcda334ef55a5e1a8954bb955ce905e5
+Size (postgresql-13.5.tar.bz2) = 21186674 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = b3393d0f28e97f89ae20297d85553c508b3896bb
 SHA1 (patch-configure) = 142ba9dc85a2408802e4b9e4943b775312d577c9
diff -r 9f1d13dd93bd -r ea0f869e03fb databases/postgresql14-client/PLIST
--- a/databases/postgresql14-client/PLIST       Tue Nov 16 09:31:16 2021 +0000
+++ b/databases/postgresql14-client/PLIST       Tue Nov 16 10:14:36 2021 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2021/10/08 10:23:43 adam Exp $
+@comment $NetBSD: PLIST,v 1.2 2021/11/16 10:14:38 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createuser
@@ -1080,6 +1080,7 @@
 ${PLIST.nls}share/locale/sv/LC_MESSAGES/ecpglib6-14.mo