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

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/3ab56c55c3ef
branches:  trunk
changeset: 358376:3ab56c55c3ef
user:      adam <adam%pkgsrc.org@localhost>
date:      Sat Feb 11 10:18:51 2017 +0000

description:
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.2, 9.5.6, 9.4.11, 9.3.16, and 9.2.20. This release includes fixes that 
prevent data corruption issues in index builds and in certain write-ahead-log replay situations, which are detailed below. It also patches over 75 other bugs reported over the last three months.

diffstat:

 databases/postgresql92-docs/PLIST                                  |   4 ++-
 databases/postgresql92-server/PLIST                                |   5 +++-
 databases/postgresql92/Makefile.common                             |   4 +-
 databases/postgresql92/distinfo                                    |  10 ++++----
 databases/postgresql93-docs/PLIST                                  |   5 +++-
 databases/postgresql93-server/PLIST                                |   5 +++-
 databases/postgresql93/Makefile.common                             |   4 +-
 databases/postgresql93/distinfo                                    |  10 ++++----
 databases/postgresql94-docs/PLIST                                  |   6 ++++-
 databases/postgresql94-server/PLIST                                |   5 +++-
 databases/postgresql94/Makefile.common                             |   4 +-
 databases/postgresql94/distinfo                                    |  12 +++++-----
 databases/postgresql94/patches/patch-contrib_uuid-ossp_uuid-ossp.c |  12 +++++-----
 databases/postgresql95-contrib/Makefile                            |   3 +-
 databases/postgresql95-docs/PLIST                                  |   7 +++++-
 databases/postgresql95-server/PLIST                                |   5 +++-
 databases/postgresql95/Makefile.common                             |   4 +-
 databases/postgresql95/distinfo                                    |  10 ++++----
 databases/postgresql96-contrib/Makefile                            |   3 +-
 databases/postgresql96-docs/PLIST                                  |   8 +++++-
 databases/postgresql96-server/PLIST                                |   6 ++++-
 databases/postgresql96/Makefile.common                             |   4 +-
 databases/postgresql96/distinfo                                    |  10 ++++----
 23 files changed, 90 insertions(+), 56 deletions(-)

diffs (truncated from 611 to 300 lines):

diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql92-docs/PLIST
--- a/databases/postgresql92-docs/PLIST Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql92-docs/PLIST Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.19 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.20 2017/02/11 10:18:51 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -427,6 +427,7 @@
 share/doc/postgresql/html/diskusage.html
 share/doc/postgresql/html/dml-delete.html
 share/doc/postgresql/html/dml-insert.html
+share/doc/postgresql/html/dml-returning.html
 share/doc/postgresql/html/dml-update.html
 share/doc/postgresql/html/dml.html
 share/doc/postgresql/html/docguide-authoring.html
@@ -1077,6 +1078,7 @@
 share/doc/postgresql/html/release-9-2-18.html
 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-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql92-server/PLIST
--- a/databases/postgresql92-server/PLIST       Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql92-server/PLIST       Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2017/02/11 10:18:52 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -308,6 +308,7 @@
 share/postgresql/timezone/Asia/Aqtobe
 share/postgresql/timezone/Asia/Ashgabat
 share/postgresql/timezone/Asia/Ashkhabad
+share/postgresql/timezone/Asia/Atyrau
 share/postgresql/timezone/Asia/Baghdad
 share/postgresql/timezone/Asia/Bahrain
 share/postgresql/timezone/Asia/Baku
@@ -328,6 +329,7 @@
 share/postgresql/timezone/Asia/Dili
 share/postgresql/timezone/Asia/Dubai
 share/postgresql/timezone/Asia/Dushanbe
+share/postgresql/timezone/Asia/Famagusta
 share/postgresql/timezone/Asia/Gaza
 share/postgresql/timezone/Asia/Harbin
 share/postgresql/timezone/Asia/Hebron
@@ -533,6 +535,7 @@
 share/postgresql/timezone/Europe/Samara
 share/postgresql/timezone/Europe/San_Marino
 share/postgresql/timezone/Europe/Sarajevo
+share/postgresql/timezone/Europe/Saratov
 share/postgresql/timezone/Europe/Simferopol
 share/postgresql/timezone/Europe/Skopje
 share/postgresql/timezone/Europe/Sofia
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql92/Makefile.common
--- a/databases/postgresql92/Makefile.common    Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql92/Makefile.common    Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.26 2016/10/29 19:41:53 adam Exp $
+# $NetBSD: Makefile.common,v 1.27 2017/02/11 10:18: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/postgresql92-pltcl/Makefile
 # used by databases/postgresql92-server/Makefile
 
-DISTNAME=      postgresql-9.2.19
+DISTNAME=      postgresql-9.2.20
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql92/distinfo
--- a/databases/postgresql92/distinfo   Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql92/distinfo   Sat Feb 11 10:18:51 2017 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.21 2016/10/29 19:41:53 adam Exp $
+$NetBSD: distinfo,v 1.22 2017/02/11 10:18:51 adam Exp $
 
-SHA1 (postgresql-9.2.19.tar.bz2) = 0444ba612dde02031704838b21560139d996f7f0
-RMD160 (postgresql-9.2.19.tar.bz2) = 481cd06f5fe445f2bcc64a11f2e8da8b1b79a161
-SHA512 (postgresql-9.2.19.tar.bz2) = d3b4c5578bf6d6580028e775bff81a921258cb53b6b06567d96a352d14f3b63063adb480b2f5e2029baf8a034e14b5cd75eebc04f1ed7b16c849e1a5ec1f4867
-Size (postgresql-9.2.19.tar.bz2) = 16466698 bytes
+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 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
 SHA1 (patch-configure) = 21b27add570cff1a24c440201eb1ed49f8223747
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql93-docs/PLIST
--- a/databases/postgresql93-docs/PLIST Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql93-docs/PLIST Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.16 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.17 2017/02/11 10:18:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -440,6 +440,7 @@
 share/doc/postgresql/html/diskusage.html
 share/doc/postgresql/html/dml-delete.html
 share/doc/postgresql/html/dml-insert.html
+share/doc/postgresql/html/dml-returning.html
 share/doc/postgresql/html/dml-update.html
 share/doc/postgresql/html/dml.html
 share/doc/postgresql/html/docguide-authoring.html
@@ -1098,6 +1099,7 @@
 share/doc/postgresql/html/release-9-2-18.html
 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-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
@@ -1113,6 +1115,7 @@
 share/doc/postgresql/html/release-9-3-13.html
 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-2.html
 share/doc/postgresql/html/release-9-3-3.html
 share/doc/postgresql/html/release-9-3-4.html
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql93-server/PLIST
--- a/databases/postgresql93-server/PLIST       Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql93-server/PLIST       Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.9 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.10 2017/02/11 10:18:52 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -308,6 +308,7 @@
 share/postgresql/timezone/Asia/Aqtobe
 share/postgresql/timezone/Asia/Ashgabat
 share/postgresql/timezone/Asia/Ashkhabad
+share/postgresql/timezone/Asia/Atyrau
 share/postgresql/timezone/Asia/Baghdad
 share/postgresql/timezone/Asia/Bahrain
 share/postgresql/timezone/Asia/Baku
@@ -328,6 +329,7 @@
 share/postgresql/timezone/Asia/Dili
 share/postgresql/timezone/Asia/Dubai
 share/postgresql/timezone/Asia/Dushanbe
+share/postgresql/timezone/Asia/Famagusta
 share/postgresql/timezone/Asia/Gaza
 share/postgresql/timezone/Asia/Harbin
 share/postgresql/timezone/Asia/Hebron
@@ -533,6 +535,7 @@
 share/postgresql/timezone/Europe/Samara
 share/postgresql/timezone/Europe/San_Marino
 share/postgresql/timezone/Europe/Sarajevo
+share/postgresql/timezone/Europe/Saratov
 share/postgresql/timezone/Europe/Simferopol
 share/postgresql/timezone/Europe/Skopje
 share/postgresql/timezone/Europe/Sofia
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql93/Makefile.common
--- a/databases/postgresql93/Makefile.common    Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql93/Makefile.common    Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.22 2016/10/29 19:41:54 adam Exp $
+# $NetBSD: Makefile.common,v 1.23 2017/02/11 10:18: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/postgresql93-pltcl/Makefile
 # used by databases/postgresql93-server/Makefile
 
-DISTNAME=      postgresql-9.3.15
+DISTNAME=      postgresql-9.3.16
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql93/distinfo
--- a/databases/postgresql93/distinfo   Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql93/distinfo   Sat Feb 11 10:18:51 2017 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.21 2016/10/29 19:41:54 adam Exp $
+$NetBSD: distinfo,v 1.22 2017/02/11 10:18:52 adam Exp $
 
-SHA1 (postgresql-9.3.15.tar.bz2) = 8f04a3e71eded0e44086bae94be6205c246f2f89
-RMD160 (postgresql-9.3.15.tar.bz2) = b1c613167aa612ab0ea9fd1d17d0a7570662d6a8
-SHA512 (postgresql-9.3.15.tar.bz2) = 35c30cdb5599f99c94ab921f9f5e7671a8c0b7bca8fe3b616630ae13d6eda8d329e77e7e802da6a83cb09c3c9ca10fa8ce0de8a184e6fff471130e1cd68ce762
-Size (postgresql-9.3.15.tar.bz2) = 17059932 bytes
+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 (patch-config_missing) = c2d7d742922ba6861e7660c75b7b53f09e564813
 SHA1 (patch-config_perl.m4) = e035132b1c281a75752d570ac5e29a11176c25c5
 SHA1 (patch-configure) = 3de7635fe18532a05a619941fecad7bcda6c51b9
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql94-docs/PLIST
--- a/databases/postgresql94-docs/PLIST Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql94-docs/PLIST Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.11 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.12 2017/02/11 10:18:52 adam Exp $
 man/man1/clusterdb.1
 man/man1/createdb.1
 man/man1/createlang.1
@@ -445,6 +445,7 @@
 share/doc/postgresql/html/diskusage.html
 share/doc/postgresql/html/dml-delete.html
 share/doc/postgresql/html/dml-insert.html
+share/doc/postgresql/html/dml-returning.html
 share/doc/postgresql/html/dml-update.html
 share/doc/postgresql/html/dml.html
 share/doc/postgresql/html/docguide-authoring.html
@@ -1118,6 +1119,7 @@
 share/doc/postgresql/html/release-9-2-18.html
 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-3.html
 share/doc/postgresql/html/release-9-2-4.html
 share/doc/postgresql/html/release-9-2-5.html
@@ -1133,6 +1135,7 @@
 share/doc/postgresql/html/release-9-3-13.html
 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-2.html
 share/doc/postgresql/html/release-9-3-3.html
 share/doc/postgresql/html/release-9-3-4.html
@@ -1144,6 +1147,7 @@
 share/doc/postgresql/html/release-9-3.html
 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-2.html
 share/doc/postgresql/html/release-9-4-3.html
 share/doc/postgresql/html/release-9-4-4.html
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql94-server/PLIST
--- a/databases/postgresql94-server/PLIST       Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql94-server/PLIST       Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.6 2016/10/29 19:41:54 adam Exp $
+@comment $NetBSD: PLIST,v 1.7 2017/02/11 10:18:52 adam Exp $
 bin/postgres
 bin/postmaster
 include/postgresql/server/plpgsql.h
@@ -308,6 +308,7 @@
 share/postgresql/timezone/Asia/Aqtobe
 share/postgresql/timezone/Asia/Ashgabat
 share/postgresql/timezone/Asia/Ashkhabad
+share/postgresql/timezone/Asia/Atyrau
 share/postgresql/timezone/Asia/Baghdad
 share/postgresql/timezone/Asia/Bahrain
 share/postgresql/timezone/Asia/Baku
@@ -328,6 +329,7 @@
 share/postgresql/timezone/Asia/Dili
 share/postgresql/timezone/Asia/Dubai
 share/postgresql/timezone/Asia/Dushanbe
+share/postgresql/timezone/Asia/Famagusta
 share/postgresql/timezone/Asia/Gaza
 share/postgresql/timezone/Asia/Harbin
 share/postgresql/timezone/Asia/Hebron
@@ -533,6 +535,7 @@
 share/postgresql/timezone/Europe/Samara
 share/postgresql/timezone/Europe/San_Marino
 share/postgresql/timezone/Europe/Sarajevo
+share/postgresql/timezone/Europe/Saratov
 share/postgresql/timezone/Europe/Simferopol
 share/postgresql/timezone/Europe/Skopje
 share/postgresql/timezone/Europe/Sofia
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql94/Makefile.common
--- a/databases/postgresql94/Makefile.common    Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql94/Makefile.common    Sat Feb 11 10:18:51 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.14 2016/10/29 19:41:54 adam Exp $
+# $NetBSD: Makefile.common,v 1.15 2017/02/11 10:18: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.10
+DISTNAME=      postgresql-9.4.11
 CATEGORIES=    databases
 MASTER_SITES=  ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
 EXTRACT_SUFX=  .tar.bz2
diff -r 9a66c8f66e73 -r 3ab56c55c3ef databases/postgresql94/distinfo
--- a/databases/postgresql94/distinfo   Sat Feb 11 09:39:20 2017 +0000
+++ b/databases/postgresql94/distinfo   Sat Feb 11 10:18:51 2017 +0000
@@ -1,14 +1,14 @@
-$NetBSD: distinfo,v 1.13 2016/10/29 19:41:54 adam Exp $
+$NetBSD: distinfo,v 1.14 2017/02/11 10:18:52 adam Exp $
 
-SHA1 (postgresql-9.4.10.tar.bz2) = d1ebec7f076a6b9de29d7f726b0932ac542f2bd1
-RMD160 (postgresql-9.4.10.tar.bz2) = 40d7b38f3bce9e5404825c653e9bb2b851f84374
-SHA512 (postgresql-9.4.10.tar.bz2) = 2fcf47769b22c69bc82c9d6edc317e18dfcb4a96534e012bae4355e5088afa83da98b21e08a07766794f0a166888acbd16705a806464ea11711ed97c3b4012fb
-Size (postgresql-9.4.10.tar.bz2) = 17802812 bytes
+SHA1 (postgresql-9.4.11.tar.bz2) = 3ec451a9ecfb7cad107b76be3acd2279726c8df6