Update databases/pgpool2 to 3.6.5, based on patches by Mustafa Dogan. Fixes pkg/52488. Release 3.6.5 - Fix for [pgpool-hackers: 2400] Garbage output - Importing the latest changes in the MemoryManager API from PostgreSQL code. - Fixing 0000306: Pgpool steals back MASTER status. - Fixing [pgpool-hackers: 2390]Problems with the relative paths in daemon mode - Adjust function name change in PostgreSQL 10 dev head. - Fix a posible hang with streaming replication and extended protocol. - Fix Pgpool-II hang when used by erlang applications. - Fix bug with sending bind message to wrong target node. - Fix query cache hang when used by node.js. - Deal with PostgreSQL 10 in streaming replication delay checking. - Fix query cache memory leak. - Fix extended query hang in certain case. - Fix for [pgpool-hackers: 2354] segfault with pg_md5. - Fix descriptions of white/black_memcache_table_list. - Fix corner case bug in Pgpool-II starting up. Release 3.6.4 - Fixing a few corner cases in the failover request handling of the watchdog. - Tightening up the watchdog cluster membership criteria. - Enhance document for load balancing. - Add node 0 failover test. - Fix Pgpool-II child process segfault reported in [pgpool-hackers: 2312]. Release 3.6.3 - Fix "show pool_cache" segfault when memcached is used. - Fix for some more code warnings. - Fixing some annoying compiler warnings. - Removing the function defined but not used warnings from pool_config_vatiable.c - Removing the references of obsolete debug_level configuration parameter. - Fixing a mistake in the watchdog code. - Fix for 0000299: Errors on the reloading of configuration. - Add pgpool_adm English and Japanese docs. - Fix document indentation. - Fix for 0000289: Inconsistent backend state. - Enhancing the handling of split-brain scenario by the watchdog. - Enhancing the watchdog internal command mechanism to handle multiple concurrent commands. - Fix compiler warnings. - Comment out unsupported Java method in new JDBC drivers to prevent regression failure. - Downgrade parse before bind log message to debug1. - Fix coverity warnings. - Fix for [pgpool-general: 5396] pam ldap failure. - Mention that SQL type commands cannot be used in extended query mode. - Consider SHOW command as kind of a read query. - Fix memory leak problem caused by commit adcb636. - Mega patch to fix "kind mismatch" (or derived) errors in streaming replication mode. - Fix for 0000296: PGPool v3.6.2 terminated by systemd because the service Type has been set to 'forking'. Release 3.6.2 - Add "Wants=network.target" to pgpool.service file. - Fix pcp_promote_node bug that fails promoting node 0. - Fix document error. - Pgpool-IIshould not perform ping test after bringing down the VIP. - Fix to release shared memory segments when Pgpool-IIexits. - Fix for [pgpool-general: 5315] pg_terminate_backend - Adding the missing ExecStop and ExecReload commands to the systemd service configuration file. - Fix for 281: "segmentation fault" when execute pcp_attach_node. - Fix load balancing bug in streaming replication mode. - Fix yet another kind mismatch error in streaming replication mode. - Fix do_query()hangs after close message. - Fixing stack smashing detected. - Fixing the issue with the watchdog process restart. - Fix query cache bug reported in pgpool-general-jp:1441. - Remove elog/ereport calls from signal handlers. - Fix bug failed to create INET domain socket in FreeBSD if listen_addresses = '*'. - Fix for 0000249: watchdog sometimes fails de-escalation. - Fix connection_life_time broken by authentication_timeout. - Fix authentication timeout that can occur right after client connecttions. Release 3.6.1 - Tightening up the watchdog security. - Add pgpool_adm extension in Pgpool-II RPM. - Fix occasional segfault when query cache is enabled. - Fix packet kind does not match error in extended protocol. - Fix a race condition in a signal handler. - Fix wrong minimum configuration value for client_idle_limit_in_recovery. - Allow to execute "make xslthtml" under doc.ja.diff -r1.3 -r1.4 pkgsrc/databases/pgpool2/Makefile
(fhajny)
@@ -1,17 +1,17 @@ | @@ -1,17 +1,17 @@ | |||
1 | # $NetBSD: Makefile,v 1.3 2016/11/24 12:52:47 fhajny Exp $ | 1 | # $NetBSD: Makefile,v 1.4 2017/08/17 07:46:05 fhajny Exp $ | |
2 | # | 2 | # | |
3 | 3 | |||
4 | DISTNAME= pgpool-II-3.6.0 | 4 | DISTNAME= pgpool-II-3.6.5 | |
5 | PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/} | 5 | PKGNAME= postgresql${PGSQL_VERSION}-${DISTNAME:S/pgpool-II/pgpool2/} | |
6 | CATEGORIES= databases | 6 | CATEGORIES= databases | |
7 | MASTER_SITES= http://www.pgpool.net/mediawiki/images/ | 7 | MASTER_SITES= http://www.pgpool.net/mediawiki/images/ | |
8 | 8 | |||
9 | MAINTAINER= filip@joyent.com | 9 | MAINTAINER= filip@joyent.com | |
10 | HOMEPAGE= http://www.pgpool.net/mediawiki/ | 10 | HOMEPAGE= http://www.pgpool.net/mediawiki/ | |
11 | COMMENT= Middleware between PostgreSQL servers and a PostgreSQL database client | 11 | COMMENT= Middleware between PostgreSQL servers and a PostgreSQL database client | |
12 | LICENSE= modified-bsd | 12 | LICENSE= modified-bsd | |
13 | 13 | |||
14 | DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server | 14 | DEPENDS+= postgresql${PGSQL_VERSION}-server>=0:../../databases/postgresql${PGSQL_VERSION}-server | |
15 | 15 | |||
16 | GNU_CONFIGURE= yes | 16 | GNU_CONFIGURE= yes | |
17 | USE_LIBTOOL= yes | 17 | USE_LIBTOOL= yes |
@@ -1,10 +1,10 @@ | @@ -1,10 +1,10 @@ | |||
1 | $NetBSD: distinfo,v 1.2 2016/11/24 12:52:47 fhajny Exp $ | 1 | $NetBSD: distinfo,v 1.3 2017/08/17 07:46:05 fhajny Exp $ | |
2 | 2 | |||
3 | SHA1 (pgpool-II-3.6.0.tar.gz) = 50606dda740846b814ffa3571a243b619e2515ab | 3 | SHA1 (pgpool-II-3.6.5.tar.gz) = 573e5f80691330632ed23648a24c502221175a31 | |
4 | RMD160 (pgpool-II-3.6.0.tar.gz) = 7576b2a212c9d0ff5f9ad0534b2a697f111cca45 | 4 | RMD160 (pgpool-II-3.6.5.tar.gz) = 83b2e8f86bcb7b3fceb57ed6ef485181b43325f9 | |
5 | SHA512 (pgpool-II-3.6.0.tar.gz) = 2d44331c509e6672ae86ed51b1d32ba6b367c03bbc5cf28776d6a0c2a80cae5ce3c1f0a323b391e163e5753eb97acae56aa0c1ebb964aa26f94b388d0d84acb1 | 5 | SHA512 (pgpool-II-3.6.5.tar.gz) = 12247730f202859c76b0a11ccc485de786e53df7b8e08ffd76d7653c25633d79387f027e7c9d804bf19cd89b9db047b7ca0cf1cf5e914ee74c6efc0b6660eb1d | |
6 | Size (pgpool-II-3.6.0.tar.gz) = 2511790 bytes | 6 | Size (pgpool-II-3.6.5.tar.gz) = 2651330 bytes | |
7 | SHA1 (patch-configure) = 8fb3a30fade036b82171ee9a57e02c915f27909d | 7 | SHA1 (patch-configure) = ed04280cf2c02f5491aa20d3478f026a92885f19 | |
8 | SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2 | 8 | SHA1 (patch-src_include_pool.h) = 74409384d735695d44466468833088959753d9d2 | |
9 | SHA1 (patch-src_sample_pgpool.conf.sample) = db3f6e280d3b02dd6c5abab9aba087ce30acbaa5 | 9 | SHA1 (patch-src_sample_pgpool.conf.sample) = 43f9e481ba3630984c165c609d2aac3d4bbf7c18 | |
10 | SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25 | 10 | SHA1 (patch-src_watchdog_wd__escalation.c) = 63ac5ea3f8853eb953707e79f351ae1eea3a8b25 |
@@ -1,15 +1,15 @@ | @@ -1,15 +1,15 @@ | |||
1 | $NetBSD: patch-configure,v 1.2 2016/11/24 12:52:47 fhajny Exp $ | 1 | $NetBSD: patch-configure,v 1.3 2017/08/17 07:46:05 fhajny Exp $ | |
2 | 2 | |||
3 | Pick a better name for the package. | 3 | Pick a better name for the package. | |
4 | 4 | |||
5 | --- configure.orig 2016-02-10 08:53:31.000000000 +0000 | 5 | --- configure.orig 2017-07-10 08:56:18.000000000 +0000 | |
6 | +++ configure | 6 | +++ configure | |
7 | @@ -3979,7 +3979,7 @@ fi | 7 | @@ -3999,7 +3999,7 @@ fi | |
8 | 8 | |||
9 | 9 | |||
10 | # Define the identity of the package. | 10 | # Define the identity of the package. | |
11 | - PACKAGE='pgpool-II' | 11 | - PACKAGE='pgpool-II' | |
12 | + PACKAGE='pgpool2' | 12 | + PACKAGE='pgpool2' | |
13 | VERSION='3.6.0' | 13 | VERSION='3.6.5' | |
14 | 14 | |||
15 | 15 |
@@ -1,28 +1,31 @@ | @@ -1,28 +1,31 @@ | |||
1 | $NetBSD: patch-src_sample_pgpool.conf.sample,v 1.1 2016/03/11 21:30:55 fhajny Exp $ | 1 | $NetBSD: patch-src_sample_pgpool.conf.sample,v 1.2 2017/08/17 07:46:05 fhajny Exp $ | |
2 | 2 | |||
3 | Default pid file location. | 3 | Default pid file location. | |
4 | 4 | |||
5 | --- src/sample/pgpool.conf.sample.orig 2015-04-08 07:58:44.000000000 +0000 | 5 | --- src/sample/pgpool.conf.sample.orig 2017-07-10 08:56:18.000000000 +0000 | |
6 | +++ src/sample/pgpool.conf.sample | 6 | +++ src/sample/pgpool.conf.sample | |
7 | @@ -211,10 +211,10 @@ debug_level = 0 | 7 | @@ -210,13 +210,13 @@ syslog_ident = 'pgpool' | |
8 | # FILE LOCATIONS | 8 | # FILE LOCATIONS | |
9 | #------------------------------------------------------------------------------ | 9 | #------------------------------------------------------------------------------ | |
10 | 10 | |||
11 | -pid_file_name = '/var/run/pgpool/pgpool.pid' | 11 | -pid_file_name = '/var/run/pgpool/pgpool.pid' | |
12 | +pid_file_name = '@PGPOOL_PIDDIR@/pgpool.pid' | 12 | +pid_file_name = '@PGPOOL_PIDDIR@/pgpool.pid' | |
13 | # PID file name | 13 | # PID file name | |
14 | # Can be specified as relative to the" | |||
15 | # location of pgpool.conf file or | |||
16 | # as an absolute path | |||
14 | # (change requires restart) | 17 | # (change requires restart) | |
15 | -logdir = '/var/log/pgpool' | 18 | -logdir = '/var/log/pgpool' | |
16 | +logdir = '@PGPOOL_LOGDIR@' | 19 | +logdir = '@PGPOOL_LOGDIR@' | |
17 | # Directory of pgPool status file | 20 | # Directory of pgPool status file | |
18 | # (change requires restart) | 21 | # (change requires restart) | |
19 | 22 | |||
20 | @@ -682,7 +682,7 @@ memqcache_cache_block_size = 1048576 | 23 | @@ -709,7 +709,7 @@ memqcache_cache_block_size = 1048576 | |
21 | # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'. | 24 | # Cache block size in bytes. Mandatory if memqcache_method = 'shmem'. | |
22 | # Defaults to 1MB. | 25 | # Defaults to 1MB. | |
23 | # (change requires restart) | 26 | # (change requires restart) | |
24 | -memqcache_oiddir = '/var/log/pgpool/oiddir' | 27 | -memqcache_oiddir = '/var/log/pgpool/oiddir' | |
25 | +memqcache_oiddir = '@PGPOOL_LOGDIR@/oiddir' | 28 | +memqcache_oiddir = '@PGPOOL_LOGDIR@/oiddir' | |
26 | # Temporary work directory to record table oids | 29 | # Temporary work directory to record table oids | |
27 | # (change requires restart) | 30 | # (change requires restart) | |
28 | white_memqcache_table_list = '' | 31 | white_memqcache_table_list = '' |