[pkgsrc/trunk]: pkgsrc/databases/pgpool2 Update databases/pgpool2 to 3.6.0.

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

details:   https://anonhg.NetBSD.org/pkgsrc/rev/a9f41b53ee33
branches:  trunk
changeset: 355175:a9f41b53ee33
user:      fhajny <fhajny%pkgsrc.org@localhost>
date:      Thu Nov 24 12:52:47 2016 +0000

description:
Update databases/pgpool2 to 3.6.0.

3.6.0

Notable new features

- Improve the behavior of fail-over.
- New PGPOOL SET command has been introduced.
- Watchdog is significantly enhanced.
- Handling of extended query protocol (e.g. used by Java applications)
  in streaming replication mode speeds up if many rows are returned
  in a result set.
- Import parser of PostgreSQL 9.6.
- In some cases pg_terminate_backend() now does not trigger a fail-over.
- Change documentation format from raw HTML to SGML.

3.5.4

Bug fixes

- Fix buffer over run problem in "show pool_nodes".
- Fix usage of wait(2) in pgpool main process.
- Save and restore errno in each signal handler.
- Fix handling of pcp_listen_addresses config parameter.
- Fix "kind mismatch" error message in pgpool.
- Replace "MAJOR" macro to prevent occasional failure.
- Fixing a coding mistake in watchdog code.
- doc : Fixing a typo in english doc
- Fix for bun 215 that pgpool doesn't escalate ip in case of another node
  inavailability.
- Fix for bug of inconsistent status of Postgresql nodes in Pgpool instances
  after restart.
- SIGUSR1 signal handler should be installed before watchdog initialization.
- Fix for bug 228 that pgpool doesn't de-escalate IP in case network
  restored.
- Fix hang when portal suspend received.
- test : Add regression test for bug 230.
- Fixing a typo in the log message.
- Fixing the error messages when the socket operation fails.
- Tighten up health check timer expired condition in pool_check_fd().
- doc : Add comment to the document about connection_cache.
- Fix Handling of pcp_socket_dir was missing from pool_get_config().
- doc : Fix Japanese document typo.
- Fix "out of memory" by using "pg_md5 -m".
- Fix for 237 that Pgpool-II fails to start if listen_addresses is empty
  string.

3.5.3

New features

- Allow to access to pgpool while doing health checking

Bug fixes

- Fix is_set_transaction_serializable() when
  SET default_transaction_isolation TO 'serializable'.
- Fix Chinese documetation bug about raw mode
- Fix confusing comments in pgpool.conf
- Fix extended protocol handling in raw mode
- Permit pgpool to support multiple SSL cipher protocols
- If statement timeout is enabled on backend and do_query() sends a
  query to primary node, and all of following user queries are sent to
  standby, it is possible that the next command, for example END, could
  cause a statement timeout error on the primary, and a kind mismatch
  error on pgpool-II is raised.
- Deal with the case when the primary is not node 0 in streaming replication
  mode.
- Fix a posible hang during health checking
- change the Makefile under this directory src/sql/,that is proposed by
- fix for 0000197: pgpool hangs connections to database..
- Fix bug with load balance node id info on shmem
- Fixing coverity scan reported issues.

3.5.2

Bugfixes

- Fix for segfault during trusted_servers check
- Removing the limit on the maximum number of items in the
  black_function_list and white_function_list lists
- Fix check "PCP Directory" in "Parameter Setting" in install
- Fix extended protocol hang with empty query
- Redirect all user queries to primary server
- Change the PID length of pcp_proc_count command result to 6 characters
  long

3.5.1

Bugfixes

- Add some warning messages for wd_authkey hash calculation failure
- test: Fix regression test to check timeout of each test
- test: Allow timeout value to be specified by the command option
- Fix compile issue on FreeBSD
- test: Fix test/regression/clean.sh to remove binary files of
  010.rewrite_timestamp test
- Fix memorry leak reported by Coverity (CID 1350095)
- Fixing pgpool-recovery module compilation issue with PostgreSQL 9.6
- Fix to properly process an empty query that has only comments
- Fix a reset query stuck problem
- Fix a reset query stuck problem
- Fix query stuck problems in streaming replication mode with extended
  protocol queries
- Fix pgpool hung after receiving error state from backend
- Fix bug that child processes exit and are not re-spawned
- Fix typo in configure
- doc: Change description of backend_flag
- doc: Fix installation procedure.
- test: Fix pgpool_setup to not confuse log output
- Fix to validate the PCP packet length

diffstat:

 databases/pgpool2/Makefile                |   9 +++++----
 databases/pgpool2/PLIST                   |   5 +++--
 databases/pgpool2/distinfo                |  12 ++++++------
 databases/pgpool2/patches/patch-configure |   4 ++--
 4 files changed, 16 insertions(+), 14 deletions(-)

diffs (96 lines):

diff -r db249b8e9e16 -r a9f41b53ee33 databases/pgpool2/Makefile
--- a/databases/pgpool2/Makefile        Thu Nov 24 12:09:29 2016 +0000
+++ b/databases/pgpool2/Makefile        Thu Nov 24 12:52:47 2016 +0000
@@ -1,9 +1,8 @@
-# $NetBSD: Makefile,v 1.2 2016/10/09 21:41:57 wiz Exp $
+# $NetBSD: Makefile,v 1.3 2016/11/24 12:52:47 fhajny Exp $
 #
 
-DISTNAME=      pgpool-II-3.5.0
+DISTNAME=      pgpool-II-3.6.0
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/}
-PKGREVISION=   1
 CATEGORIES=    databases
 MASTER_SITES=  http://www.pgpool.net/mediawiki/images/
 
@@ -16,7 +15,7 @@
 
 GNU_CONFIGURE= yes
 USE_LIBTOOL=   yes
-USE_TOOLS+=    gmake
+USE_TOOLS+=    bash:run gmake
 
 .include "options.mk"
 .include "../../mk/bsd.prefs.mk"
@@ -49,6 +48,8 @@
 SUBST_FILES.path=      src/sample/pgpool.conf.sample src/include/pool.h
 SUBST_VARS.path=       PGPOOL_LOGDIR PGPOOL_PIDDIR
 
+REPLACE_BASH+=         src/tools/pgpool_setup src/tools/watchdog_setup
+
 CONFIGURE_ARGS+=       --sysconfdir=${PKG_SYSCONFDIR}
 
 BUILD_DIRS=            . src/sql
diff -r db249b8e9e16 -r a9f41b53ee33 databases/pgpool2/PLIST
--- a/databases/pgpool2/PLIST   Thu Nov 24 12:09:29 2016 +0000
+++ b/databases/pgpool2/PLIST   Thu Nov 24 12:52:47 2016 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.1 2016/03/11 21:30:55 fhajny Exp $
+@comment $NetBSD: PLIST,v 1.2 2016/11/24 12:52:47 fhajny Exp $
 bin/pcp_attach_node
 bin/pcp_detach_node
 bin/pcp_node_count
@@ -12,6 +12,8 @@
 bin/pcp_watchdog_info
 bin/pg_md5
 bin/pgpool
+bin/pgpool_setup
+bin/watchdog_setup
 include/libpcp_ext.h
 include/pcp.h
 include/pool_process_reporting.h
@@ -20,7 +22,6 @@
 lib/postgresql/pgpool-recovery.so
 lib/postgresql/pgpool-regclass.so
 lib/postgresql/pgpool_adm.so
-man/man8/pgpool.8
 share/examples/pgpool2/pcp.conf.sample
 share/examples/pgpool2/pgpool.conf.sample
 share/examples/pgpool2/pgpool.conf.sample-master-slave
diff -r db249b8e9e16 -r a9f41b53ee33 databases/pgpool2/distinfo
--- a/databases/pgpool2/distinfo        Thu Nov 24 12:09:29 2016 +0000
+++ b/databases/pgpool2/distinfo        Thu Nov 24 12:52:47 2016 +0000
@@ -1,10 +1,10 @@
-$NetBSD: distinfo,v 1.1 2016/03/11 21:30:55 fhajny Exp $
+$NetBSD: distinfo,v 1.2 2016/11/24 12:52:47 fhajny Exp $
 
-SHA1 (pgpool-II-3.5.0.tar.gz) = f5041afe078bc8c414e4db8ab0119c4e76aaaaab
-RMD160 (pgpool-II-3.5.0.tar.gz) = 0ed82d605da0fc0ed7ff3f9c45e7731307f53299
-SHA512 (pgpool-II-3.5.0.tar.gz) = da11dd552fdad3d13676681b562972050a71f0cd0240456b76e99b860f94dc733b05f1c12bb3de3bf1d1f3f3762ef8f5533416c8c311639b97ed716e0818a172
-Size (pgpool-II-3.5.0.tar.gz) = 2205490 bytes
-SHA1 (patch-configure) = a220d49eecd5408f576f22226089daa298b27d4c
+SHA1 (pgpool-II-3.6.0.tar.gz) = 50606dda740846b814ffa3571a243b619e2515ab
+RMD160 (pgpool-II-3.6.0.tar.gz) = 7576b2a212c9d0ff5f9ad0534b2a697f111cca45
+SHA512 (pgpool-II-3.6.0.tar.gz) = 2d44331c509e6672ae86ed51b1d32ba6b367c03bbc5cf28776d6a0c2a80cae5ce3c1f0a323b391e163e5753eb97acae56aa0c1ebb964aa26f94b388d0d84acb1
+Size (pgpool-II-3.6.0.tar.gz) = 2511790 bytes
+SHA1 (patch-configure) = 8fb3a30fade036b82171ee9a57e02c915f27909d
 SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2
 SHA1 (patch-src_sample_pgpool.conf.sample) = db3f6e280d3b02dd6c5abab9aba087ce30acbaa5
 SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25
diff -r db249b8e9e16 -r a9f41b53ee33 databases/pgpool2/patches/patch-configure
--- a/databases/pgpool2/patches/patch-configure Thu Nov 24 12:09:29 2016 +0000
+++ b/databases/pgpool2/patches/patch-configure Thu Nov 24 12:52:47 2016 +0000
@@ -1,4 +1,4 @@
-$NetBSD: patch-configure,v 1.1 2016/03/11 21:30:55 fhajny Exp $
+$NetBSD: patch-configure,v 1.2 2016/11/24 12:52:47 fhajny Exp $
 
 Pick a better name for the package.
 
@@ -10,6 +10,6 @@
  # Define the identity of the package.
 - PACKAGE='pgpool-II'
 + PACKAGE='pgpool2'
-  VERSION='3.5.0'
+  VERSION='3.6.0'