pgpool is a connection pool server for PostgreSQL. pgpool runs between
PostgreSQL's clients(front ends) and servers(back ends). A PostgreSQL client can
connect to pgpool as if it were a standard PostgreSQL server.
pgpool caches the connection to PostgreSQL server to reduce the overhead to
establish the connection to it.
WWW: https://pgpool.net/
===> The following configuration options are available for pgpool-II35-3.5.25:
DOCS=on: Build and/or install documentation
SSL=on: SSL protocol support
===> Use 'make config' to modify these settings
In order to start pgpool you need some more configuration:
# sysrc -f /etc/rc.conf pgpool_enable="YES"
# sysrc -f /etc/rc.conf pgpool_user="root"
Please consider the usage of another user. The user is
required to have read/write access to /var/run/pgpool.
Using the root user is - as always - an security issue.
databases/pgpool-II-35: Update from 3.5.24 to 3.5.25
Changelog:
Bug fixes
Fix build error on some system (Fedora 32). (Tatsuo Ishii)
Fix unnecessary checks. (Tatsuo Ishii)
Fix watchdog ping probes fail with long hostnames due to small buffer. (bug
516) (Bo Peng)
Sponsored by: Bounce Experts
databases/pgpool-II-35: Update from 3.5.22 to 3.5.24
Changelog for 3.5.23:
Bug fixes
Fix incorrect query rewrite in replication mode. (Bo Peng)
Fix assorted ancient v2 protocol bugs. (Tatsuo Ishii)
Fix problem that syslog_facility doesn't change by reload. (bug 548) (Takuma
Hoshiai)
Fix Pgpool-II shutdown failed in certain case. (Tatsuo Ishii)
Fix segfault when executing an erroneous query after DEALLOCATE a named
statement. (bug 546) (Tatsuo Ishii)
(Only the first 15 lines of the commit message are shown above )
databases/pgpool-II-35: Update from 3.5.21 to 3.5.22
Changelog:
Enhancements:
- Import some of memory manager debug facilities from PostgreSQL. (Tatsuo
Ishii)
- Use pg_get_expr() instead of pg_attrdef.adsrc to support for PostgreSQL
12. (Bo Peng)
- Enhance shutdown script of pgpool_setup. (Tatsuo Ishii)
- Make shutdownall to wait for completion of shutdown of Pgpool-II.
- If environment variable CHECK_TIME_WAIT is set to true, use netstat
command to confirm usage of the TCP/IP port while executing shutdown script.
- Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii)
Bug fixes:
- Fix "unable to bind. cannot get parse message" error. (bug 531) (Tatsuo
Ishii)
- Fix online-recovery is blocked after a child process exits abnormally with
replication mode and watchdog. (bug 483) (Muhammad Usama)
(Only the first 15 lines of the commit message are shown above )
Bump PORTREVISION for ports depending on the canonical version of GCC
as defined in Mk/bsd.default-versions.mk which has moved from GCC 8.3
to GCC 9.1 under most circumstances now after revision 507371.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, everything INDEX-11 shows with a dependency on lang/gcc9 now.
PR: 238330
databases/pgpool-II-35: Upgrade from 3.5.20 to 3.5.21
Changelog:
Enhancements
- Speed up failover when all of backends are down. (Tatsuo Ishii)
- pgpool-recovery extension and pgpool_setup is now ready for the next major
release PostgreSQL 12. (Tatsuo Ishii)
Bug fixes
- Fix the wrong error message "ERROR: connection cache is full", when all
backend nodes are down. (bug 487) (Bo Peng)
- Avoid exit/fork storm of pool_worker_child process. (Tatsuo Ishii)
- Fix black_function_list's broken default value. (Tatsuo Ishii)
- Fix "not enough space in buffer" error. (bug 499) (Tatsuo Ishii)
- Fix DROP DATABASE failure. (Tatsuo Ishii)
- Fix wrong variable in read_status_file() function. (bug 493) (Takuma
Hoshiai)
- Abort session if failover/failback is ongoing to prevent potential
segfault. (bug 481, bug 482) (Tatsuo Ishii)
- Fix compiler warnings. (Tatsuo Ishii)
- Fix memory leak in "batch" mode in extended query. (bug 468) (Tatsuo
Ishii)
Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-5-21.html
MFH: 2019Q2
databases/pgpool: Upgrade from 3.5.19 to 3.5.20
Changelog:
Enhancements
* Add new configuration option ssl_prefer_server_ciphers. (Muhammad Usama)
Add the new setting ssl_prefer_server_ciphers to let users configure if
they want client's or server's cipher order to take preference.
The default for this parameter is off, which prioritize the client's
cipher order as usual. However this is just for keeping backward compatibility,
and it is possible that a malicious client uses weak ciphers. For this reason we
recommend to set this parameter to on at all times.
* Allow to set a client cipher list. (Tatsuo Ishii)
For this purpose new parameter ssl_ciphers, which specifies the cipher
list to be accepted by Pgpool-II, is added. This is already implemented in
PostgreSQL and useful to enhance security when SSL is enabled.
Bug fixes
* Fix unnecessary fsync() to pgpool_status file. (Tatsuo Ishii)
Whenever new connections are created to PostgreSQL backend, fsync() was
issued to pgpool_status file, which could generate excessive I/O in certain
conditions. So reduce the chance of issuing fsync() so that it is issued only
when backend status is changed.
Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-5-20.html
MFH: 2019Q2
databases/pgpool-II-35: Update from 3.5.18 to 3.5.19
Changelog:
- Test: Fix old JDBC functions and typos in regression test 068.memqcache_bug.
- Doc: Fix configuration change timing regarding memory_cache_enabled.
- Fix online recovery failed due to client_idle_limit_in_recovery in certain
cases. (bug 431)
- Fix corner case bug when strip_quote() handle a empty query string. (bug 458)
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection.
- Fix Pgpool-II hang if a client sends a extended query message such as close
after sync message but before next simple query.
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on. (bug 448)
Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-5-19.html
MFH: 2019Q1
Bump PORTREVISION for ports depending on the canonical version of GCC
defined via Mk/bsd.default-versions.mk which has moved from GCC 7.4 t
GCC 8.2 under most circumstances.
This includes ports
- with USE_GCC=yes or USE_GCC=any,
- with USES=fortran,
- using Mk/bsd.octave.mk which in turn features USES=fortran, and
- with USES=compiler specifying openmp, nestedfct, c11, c++0x, c++11-lang,
c++11-lib, c++14-lang, c++17-lang, or gcc-c++11-lib
plus, as a double check, everything INDEX-11 showed depending on lang/gcc7.
PR: 231590
