Hi, i upgraded pgpool to 3.2.12 on one of my machines, diff below.
I'm running in with this config: # grep mode /etc/pgpool.conf replication_mode = on load_balance_mode = on master_slave_mode = off master_slave_sub_mode = 'slony' parallel_mode = off This diff is against -current and i build it there and did a quick test, however i really use it on 5.7. Changelog: http://www.pgpool.net/docs/pgpool-II-3.2.12/NEWS.txt /Benno Index: databases/pgpool//Makefile =================================================================== RCS file: /cvs/ports/databases/pgpool/Makefile,v retrieving revision 1.5 diff -u -p -r1.5 Makefile --- databases/pgpool//Makefile 22 Apr 2013 15:53:37 -0000 1.5 +++ databases/pgpool//Makefile 19 Sep 2015 16:28:47 -0000 @@ -2,7 +2,7 @@ COMMENT= connection pool server for PostgreSQL -DISTNAME= pgpool-II-3.2.3 +DISTNAME= pgpool-II-3.2.12 CATEGORIES= databases Index: databases/pgpool//distinfo =================================================================== RCS file: /cvs/ports/databases/pgpool/distinfo,v retrieving revision 1.4 diff -u -p -r1.4 distinfo --- databases/pgpool//distinfo 22 Apr 2013 15:53:37 -0000 1.4 +++ databases/pgpool//distinfo 19 Sep 2015 16:28:47 -0000 @@ -1,2 +1,2 @@ -SHA256 (pgpool-II-3.2.3.tar.gz) = yztilXr+UG5LQgvcC5Wfgp1ixwj9zhoX2ZqFIcWGpeU= -SIZE (pgpool-II-3.2.3.tar.gz) = 1563129 +SHA256 (pgpool-II-3.2.12.tar.gz) = 2ynh2OUX9qoDTehobSpAqPtCtWJOEXrKV3DIBWysbog= +SIZE (pgpool-II-3.2.12.tar.gz) = 1626485 Index: databases/pgpool//patches/patch-watchdog_wd_lifecheck_c =================================================================== RCS file: /cvs/ports/databases/pgpool/patches/patch-watchdog_wd_lifecheck_c,v retrieving revision 1.1 diff -u -p -r1.1 patch-watchdog_wd_lifecheck_c --- databases/pgpool//patches/patch-watchdog_wd_lifecheck_c 24 Sep 2012 19:39:59 -0000 1.1 +++ databases/pgpool//patches/patch-watchdog_wd_lifecheck_c 19 Sep 2015 16:28:47 -0000 @@ -1,8 +1,8 @@ $OpenBSD: patch-watchdog_wd_lifecheck_c,v 1.1 2012/09/24 19:39:59 pea Exp $ ---- watchdog/wd_lifecheck.c.orig Sun Sep 16 12:23:44 2012 -+++ watchdog/wd_lifecheck.c Sun Sep 16 12:23:52 2012 -@@ -30,6 +30,7 @@ - #include <signal.h> +--- watchdog/wd_lifecheck.c.orig Wed Apr 8 09:59:48 2015 ++++ watchdog/wd_lifecheck.c Sun Jul 5 17:23:53 2015 +@@ -29,6 +29,7 @@ + #include <stdlib.h> #include <unistd.h> #include <netdb.h> +#include <stdint.h> Index: databases/pgpool//patches/patch-watchdog_wd_packet_c =================================================================== RCS file: /cvs/ports/databases/pgpool/patches/patch-watchdog_wd_packet_c,v retrieving revision 1.1 diff -u -p -r1.1 patch-watchdog_wd_packet_c --- databases/pgpool//patches/patch-watchdog_wd_packet_c 24 Sep 2012 19:39:59 -0000 1.1 +++ databases/pgpool//patches/patch-watchdog_wd_packet_c 19 Sep 2015 16:28:47 -0000 @@ -1,16 +1,11 @@ $OpenBSD: patch-watchdog_wd_packet_c,v 1.1 2012/09/24 19:39:59 pea Exp $ ---- watchdog/wd_packet.c.orig Sun Sep 16 12:24:07 2012 -+++ watchdog/wd_packet.c Sun Sep 16 12:24:23 2012 -@@ -34,10 +34,12 @@ - #include <sys/types.h> - #include <sys/socket.h> - #include <netinet/tcp.h> -+#include <netinet/in.h> - #include <netdb.h> +--- watchdog/wd_packet.c.orig Wed Apr 8 09:59:48 2015 ++++ watchdog/wd_packet.c Sun Jul 5 17:29:19 2015 +@@ -39,6 +39,7 @@ #include <arpa/inet.h> #include <unistd.h> #include <fcntl.h> +#include <stdint.h> + #include <sys/wait.h> #include "pool.h" - #include "pool_config.h" Index: databases/pgpool//patches/patch-watchdog_wd_ping_c =================================================================== RCS file: /cvs/ports/databases/pgpool/patches/patch-watchdog_wd_ping_c,v retrieving revision 1.1 diff -u -p -r1.1 patch-watchdog_wd_ping_c --- databases/pgpool//patches/patch-watchdog_wd_ping_c 24 Sep 2012 19:39:59 -0000 1.1 +++ databases/pgpool//patches/patch-watchdog_wd_ping_c 19 Sep 2015 16:28:47 -0000 @@ -1,11 +1,11 @@ $OpenBSD: patch-watchdog_wd_ping_c,v 1.1 2012/09/24 19:39:59 pea Exp $ ---- watchdog/wd_ping.c.orig Sun Sep 16 12:24:32 2012 -+++ watchdog/wd_ping.c Sun Sep 16 12:24:44 2012 -@@ -31,6 +31,7 @@ - #include <sys/wait.h> - #include <sys/stat.h> +--- watchdog/wd_ping.c.orig Wed Apr 8 09:59:48 2015 ++++ watchdog/wd_ping.c Sun Jul 5 17:27:43 2015 +@@ -24,6 +24,7 @@ + #include <pthread.h> + #include <stdio.h> #include <errno.h> +#include <stdint.h> - #include "pool.h" - #include "pool_config.h" - #include "watchdog.h" + #include <string.h> + #include <stdlib.h> + #include <unistd.h>
