[pkgsrc/trunk]: pkgsrc/databases The PostgreSQL Global Development Group has ...

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/92b5aa73addc
branches:  trunk
changeset: 362368:92b5aa73addc
user:      adam <adam%pkgsrc.org@localhost>
date:      Fri May 12 19:37:54 2017 +0000

description:
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.3, 9.5.7, 9.4.12, 9.3.17, and 9.2.21. This release fixes three security 
issues. It also patches a number of other bugs reported over the last three months. Users who use the PGREQUIRESSL environment variable to control connections, and users who rely on security 
isolation between database users when using foreign servers, should update as soon as possible. Other users should plan to update at the next convenient downtime.

diffstat:

 databases/postgresql92-docs/PLIST      |   4 +++-
 databases/postgresql92-server/PLIST    |   3 ++-
 databases/postgresql92/Makefile.common |   4 ++--
 databases/postgresql92/distinfo        |  10 +++++-----
 databases/postgresql93-docs/PLIST      |   5 ++++-
 databases/postgresql93-server/PLIST    |   3 ++-
 databases/postgresql93/Makefile.common |   4 ++--
 databases/postgresql93/distinfo        |  10 +++++-----
 databases/postgresql94-client/PLIST    |   3 ++-
 databases/postgresql94-docs/PLIST      |   6 +++++-
 databases/postgresql94-server/PLIST    |   3 ++-
 databases/postgresql94/Makefile.common |   4 ++--
 databases/postgresql94/distinfo        |  10 +++++-----
 databases/postgresql95-client/PLIST    |   3 ++-
 databases/postgresql95-docs/PLIST      |   7 ++++++-
 databases/postgresql95-server/PLIST    |   3 ++-
 databases/postgresql95/Makefile.common |   4 ++--
 databases/postgresql95/distinfo        |  10 +++++-----
 databases/postgresql96-client/PLIST    |   3 ++-
 databases/postgresql96-docs/PLIST      |   8 +++++++-
 databases/postgresql96-server/PLIST    |   3 ++-
 databases/postgresql96/Makefile.common |   4 ++--
 databases/postgresql96/distinfo        |  10 +++++-----
 23 files changed, 76 insertions(+), 48 deletions(-)

diffs (truncated from 517 to 300 lines):

diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql92-docs/PLIST
--- a/databases/postgresql92-docs/PLIST Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql92-docs/PLIST Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.20 2017/02/11 10:18:51 adam Exp $
+@comment $NetBSD: PLIST,v 1.21 2017/05/12 19:37:54 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -726,6 +726,7 @@
 share/doc/postgresql/html/pgupgrade.html
 share/doc/postgresql/html/planner-optimizer.html
 share/doc/postgresql/html/planner-stats-details.html
+share/doc/postgresql/html/planner-stats-security.html
 share/doc/postgresql/html/planner-stats.html
 share/doc/postgresql/html/plhandler.html
 share/doc/postgresql/html/plperl-builtins.html
@@ -1079,6 +1080,7 @@
 share/doc/postgresql/html/release-9-2-19.html
 share/doc/postgresql/html/release-9-2-2.html
 share/doc/postgresql/html/release-9-2-20.html
+share/doc/postgresql/html/release-9-2-21.html
 share/doc/postgresql/html/release-9-2-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql92-server/PLIST
--- a/databases/postgresql92-server/PLIST       Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql92-server/PLIST       Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.13 2017/05/12 19:37:54 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -253,6 +253,7 @@
 share/postgresql/timezone/America/Porto_Acre
 share/postgresql/timezone/America/Porto_Velho
 share/postgresql/timezone/America/Puerto_Rico
+share/postgresql/timezone/America/Punta_Arenas
 share/postgresql/timezone/America/Rainy_River
 share/postgresql/timezone/America/Rankin_Inlet
 share/postgresql/timezone/America/Recife
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql92/Makefile.common
--- a/databases/postgresql92/Makefile.common    Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql92/Makefile.common    Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.27 2017/02/11 10:18:51 adam Exp $
+# $NetBSD: Makefile.common,v 1.28 2017/05/12 19:37:54 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/postgresql92-pltcl/Makefile
 # used by databases/postgresql92-server/Makefile
 
-DISTNAME=      postgresql-9.2.20
+DISTNAME=      postgresql-9.2.21
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql92/distinfo
--- a/databases/postgresql92/distinfo   Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql92/distinfo   Fri May 12 19:37:54 2017 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.22 2017/02/11 10:18:51 adam Exp $
+$NetBSD: distinfo,v 1.23 2017/05/12 19:37:54 adam Exp $
 
-SHA1 (postgresql-9.2.20.tar.bz2) = 3388c43fea446b223b8e6b0c843a7a2a7f1726a7
-RMD160 (postgresql-9.2.20.tar.bz2) = 9362f8b7dfe7173585e75bd53b5e6d6391e6f5df
-SHA512 (postgresql-9.2.20.tar.bz2) = 16f7861e0372481dbc5c69ac977bab46f592045f32951a245f3677121261640fcc169a75e730d592e36c15c9a120e7d06755550bdabf121ad89d76a17535d0f9
-Size (postgresql-9.2.20.tar.bz2) = 16480653 bytes
+SHA1 (postgresql-9.2.21.tar.bz2) = 150f9dda7c03379933cc4f804f6e37d7c8518114
+RMD160 (postgresql-9.2.21.tar.bz2) = a861209168732ec5bef45f675fa3a7a535d8e210
+SHA512 (postgresql-9.2.21.tar.bz2) = c548cd1ba34ad71dd3f1acde5775ba2e71121f004324fac44dbe123a91d599ced0f1b8be675ed07b77712e8c23f376ff6221349385c19a88c4edbbb186f17861
+Size (postgresql-9.2.21.tar.bz2) = 16508040 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = 21b27add570cff1a24c440201eb1ed49f8223747
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql93-docs/PLIST
--- a/databases/postgresql93-docs/PLIST Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql93-docs/PLIST Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.18 2017/05/12 19:37:54 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -746,6 +746,7 @@
 share/doc/postgresql/html/pgxlogdump.html
 share/doc/postgresql/html/planner-optimizer.html
 share/doc/postgresql/html/planner-stats-details.html
+share/doc/postgresql/html/planner-stats-security.html
 share/doc/postgresql/html/planner-stats.html
 share/doc/postgresql/html/plhandler.html
 share/doc/postgresql/html/plperl-builtins.html
@@ -1100,6 +1101,7 @@
 share/doc/postgresql/html/release-9-2-19.html
 share/doc/postgresql/html/release-9-2-2.html
 share/doc/postgresql/html/release-9-2-20.html
+share/doc/postgresql/html/release-9-2-21.html
 share/doc/postgresql/html/release-9-2-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
@@ -1116,6 +1118,7 @@
 share/doc/postgresql/html/release-9-3-14.html
 share/doc/postgresql/html/release-9-3-15.html
 share/doc/postgresql/html/release-9-3-16.html
+share/doc/postgresql/html/release-9-3-17.html
 share/doc/postgresql/html/release-9-3-2.html
 share/doc/postgresql/html/release-9-3-3.html
 share/doc/postgresql/html/release-9-3-4.html
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql93-server/PLIST
--- a/databases/postgresql93-server/PLIST       Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql93-server/PLIST       Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.10 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.11 2017/05/12 19:37:54 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -253,6 +253,7 @@
 share/postgresql/timezone/America/Porto_Acre
 share/postgresql/timezone/America/Porto_Velho
 share/postgresql/timezone/America/Puerto_Rico
+share/postgresql/timezone/America/Punta_Arenas
 share/postgresql/timezone/America/Rainy_River
 share/postgresql/timezone/America/Rankin_Inlet
 share/postgresql/timezone/America/Recife
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql93/Makefile.common
--- a/databases/postgresql93/Makefile.common    Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql93/Makefile.common    Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.23 2017/02/11 10:18:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.24 2017/05/12 19:37:54 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/postgresql93-pltcl/Makefile
 # used by databases/postgresql93-server/Makefile
 
-DISTNAME=      postgresql-9.3.16
+DISTNAME=      postgresql-9.3.17
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql93/distinfo
--- a/databases/postgresql93/distinfo   Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql93/distinfo   Fri May 12 19:37:54 2017 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.22 2017/02/11 10:18:52 adam Exp $
+$NetBSD: distinfo,v 1.23 2017/05/12 19:37:54 adam Exp $
 
-SHA1 (postgresql-9.3.16.tar.bz2) = 6b2078f456fa18011fd4ba4c9b6dcf66c1e144e5
-RMD160 (postgresql-9.3.16.tar.bz2) = 46ed5c3532ca7c62d9b12b54e2431c4e9d4e3359
-SHA512 (postgresql-9.3.16.tar.bz2) = 2e379aca5db79ab5795e6f1e4ff8b21b1aa284cfb0d34655430d8b959cebac7982ee6eda66833a1fb208a36a51251c946565982cd5dff619ab334603ded530e7
-Size (postgresql-9.3.16.tar.bz2) = 17108969 bytes
+SHA1 (postgresql-9.3.17.tar.bz2) = 72440056d39023002a154ce959aa124f6ac468c7
+RMD160 (postgresql-9.3.17.tar.bz2) = 4e3fff3eebedf34c68930877fb2943fb0c4029bc
+SHA512 (postgresql-9.3.17.tar.bz2) = 4b6fc079c2bb728b13b72eb2f7d92183ffb1a9b32110d99dfce674032ac499963b75a021265ba08dc95c34ae35a7edac65ef1e658e66ee2da41c1ce646a702dc
+Size (postgresql-9.3.17.tar.bz2) = 17158802 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = e035132b1c281a75752d570ac5e29a11176c25c5
 SHA1 (patch-configure) = 3de7635fe18532a05a619941fecad7bcda6c51b9
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql94-client/PLIST
--- a/databases/postgresql94-client/PLIST       Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql94-client/PLIST       Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.2 2015/02/12 09:34:28 adam Exp $
+@comment $NetBSD: PLIST,v 1.3 2017/05/12 19:37:54 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -201,6 +201,7 @@
 include/postgresql/server/commands/variable.h
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/int128.h
 include/postgresql/server/common/relpath.h
 include/postgresql/server/common/string.h
 include/postgresql/server/common/username.h
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql94-docs/PLIST
--- a/databases/postgresql94-docs/PLIST Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql94-docs/PLIST Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.12 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.13 2017/05/12 19:37:54 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -763,6 +763,7 @@
 share/doc/postgresql/html/pgxlogdump.html
 share/doc/postgresql/html/planner-optimizer.html
 share/doc/postgresql/html/planner-stats-details.html
+share/doc/postgresql/html/planner-stats-security.html
 share/doc/postgresql/html/planner-stats.html
 share/doc/postgresql/html/plhandler.html
 share/doc/postgresql/html/plperl-builtins.html
@@ -1120,6 +1121,7 @@
 share/doc/postgresql/html/release-9-2-19.html
 share/doc/postgresql/html/release-9-2-2.html
 share/doc/postgresql/html/release-9-2-20.html
+share/doc/postgresql/html/release-9-2-21.html
 share/doc/postgresql/html/release-9-2-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
@@ -1136,6 +1138,7 @@
 share/doc/postgresql/html/release-9-3-14.html
 share/doc/postgresql/html/release-9-3-15.html
 share/doc/postgresql/html/release-9-3-16.html
+share/doc/postgresql/html/release-9-3-17.html
 share/doc/postgresql/html/release-9-3-2.html
 share/doc/postgresql/html/release-9-3-3.html
 share/doc/postgresql/html/release-9-3-4.html
@@ -1148,6 +1151,7 @@
 share/doc/postgresql/html/release-9-4-1.html
 share/doc/postgresql/html/release-9-4-10.html
 share/doc/postgresql/html/release-9-4-11.html
+share/doc/postgresql/html/release-9-4-12.html
 share/doc/postgresql/html/release-9-4-2.html
 share/doc/postgresql/html/release-9-4-3.html
 share/doc/postgresql/html/release-9-4-4.html
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql94-server/PLIST
--- a/databases/postgresql94-server/PLIST       Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql94-server/PLIST       Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.7 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.8 2017/05/12 19:37:54 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -253,6 +253,7 @@
 share/postgresql/timezone/America/Porto_Acre
 share/postgresql/timezone/America/Porto_Velho
 share/postgresql/timezone/America/Puerto_Rico
+share/postgresql/timezone/America/Punta_Arenas
 share/postgresql/timezone/America/Rainy_River
 share/postgresql/timezone/America/Rankin_Inlet
 share/postgresql/timezone/America/Recife
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql94/Makefile.common
--- a/databases/postgresql94/Makefile.common    Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql94/Makefile.common    Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.15 2017/02/11 10:18:52 adam Exp $
+# $NetBSD: Makefile.common,v 1.16 2017/05/12 19:37:54 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.11
+DISTNAME=      postgresql-9.4.12
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql94/distinfo
--- a/databases/postgresql94/distinfo   Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql94/distinfo   Fri May 12 19:37:54 2017 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.14 2017/02/11 10:18:52 adam Exp $
+$NetBSD: distinfo,v 1.15 2017/05/12 19:37:54 adam Exp $
 
-SHA1 (postgresql-9.4.11.tar.bz2) = 3ec451a9ecfb7cad107b76be3acd2279726c8df6
-RMD160 (postgresql-9.4.11.tar.bz2) = 28bc7a27c07d97f83787c2cb273cb2f139670c27
-SHA512 (postgresql-9.4.11.tar.bz2) = a3ed866d82ab4b90c2a7ec2abec0308015845947f42b76e420cce8f268e1c374806a9fab00ba0563d742a53014a30fa0eaa90804a09fd162b76fcbfbeff6b70f
-Size (postgresql-9.4.11.tar.bz2) = 17832915 bytes
+SHA1 (postgresql-9.4.12.tar.bz2) = 88be8d77b653a652dbf9aca513c3b6a8bfa63259
+RMD160 (postgresql-9.4.12.tar.bz2) = 03c436eee4323dfb7629ee9d746715f30ce0da81
+SHA512 (postgresql-9.4.12.tar.bz2) = 69951f9e66069aad1049a0ea9fdcd7bf2f84b42e7c6e0f761d78ab22131a39cf56448ef0ddc28170b66970bf53edf2d2355530fcfc0a2dca92b66d69686b7ecb
+Size (postgresql-9.4.12.tar.bz2) = 17833119 bytes
 SHA1 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = e035132b1c281a75752d570ac5e29a11176c25c5
 SHA1 (patch-configure) = 59fe9a768caf8a5d308acac60c28bc6bb2c40632
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql95-client/PLIST
--- a/databases/postgresql95-client/PLIST       Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql95-client/PLIST       Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.3 2016/05/23 14:27:35 adam Exp $
+@comment $NetBSD: PLIST,v 1.4 2017/05/12 19:37:55 adam Exp $
 bin/clusterdb
 bin/createdb
 bin/createlang
@@ -228,6 +228,7 @@
 include/postgresql/server/commands/variable.h
 include/postgresql/server/commands/view.h
 include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/int128.h
 include/postgresql/server/common/pg_lzcompress.h
 include/postgresql/server/common/relpath.h
 include/postgresql/server/common/restricted_token.h
diff -r 27c14a681235 -r 92b5aa73addc databases/postgresql95-docs/PLIST
--- a/databases/postgresql95-docs/PLIST Fri May 12 18:10:56 2017 +0000
+++ b/databases/postgresql95-docs/PLIST Fri May 12 19:37:54 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2017/02/11 10:18:52 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2017/05/12 19:37:55 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1