pgpool-II-36 Connection pool server for PostgreSQL

3.6.17_1 databases =1 3.6.17Version of this port present on the latest quarterly branch.

Maintainer: tz@FreeBSD.org

Port Added: 2017-05-16 10:57:57

Last Update: 2019-08-13 17:01:59

SVN Revision: 508835

License: MIT

Description:

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/

SVNWeb : Homepage

pkg-plist: as obtained via: make generate-plist

Expand this list (37 items)

1. /usr/local/share/licenses/pgpool-II36-3.6.17_1/catalog.mk
2. /usr/local/share/licenses/pgpool-II36-3.6.17_1/LICENSE
3. /usr/local/share/licenses/pgpool-II36-3.6.17_1/MIT
4. bin/pcp_attach_node
5. bin/pcp_detach_node
6. bin/pcp_node_count
7. bin/pcp_node_info
8. bin/pcp_pool_status
9. bin/pcp_proc_count
10. bin/pcp_proc_info
11. bin/pcp_promote_node
12. bin/pcp_recovery_node
13. bin/pcp_stop_pgpool
14. bin/pcp_watchdog_info
15. bin/pg_md5
16. bin/pgpool
17. bin/pgpool_setup
18. bin/watchdog_setup
19. @sample etc/pcp.conf.sample
20. @sample etc/pgpool.conf.sample
21. etc/pgpool.conf.sample-master-slave
22. etc/pgpool.conf.sample-replication
23. etc/pgpool.conf.sample-stream
24. @sample etc/pool_hba.conf.sample
25. include/libpcp_ext.h
26. include/pcp.h
27. include/pool_process_reporting.h
28. include/pool_type.h
29. lib/libpcp.a
30. lib/libpcp.so
31. lib/libpcp.so.1
32. lib/libpcp.so.1.0.0
33. share/pgpool-II/insert_lock.sql
34. share/pgpool-II/pgpool.pam
35. @dir /var/run/pgpool
36. @postexec /usr/sbin/service ldconfig restart > /dev/null
37. @postunexec /usr/sbin/service ldconfig restart > /dev/null

Collapse this list.

Dependency lines:

• pgpool-II36>0:databases/pgpool-II-36
• libpcp.so:databases/pgpool-II-36

Conflicts:

CONFLICTS:

• pgpool-II-[0-9]*

Conflicts Matches:

There are no Conflicts Matches for this port. This is usually an error.

To install the port: cd /usr/ports/databases/pgpool-II-36/ && make install clean

To add the package: pkg install pgpool-II36

PKGNAME: pgpool-II36

Flavors: there is no flavor information for this port.

distinfo:

TIMESTAMP = 1558014337 SHA256 (pgpool-II-3.6.17.tar.gz) = cbe239d193a1c3f7cb9839b0e1a2500e0d9ec5d8f763cd9dcc094770e845ef73 SIZE (pgpool-II-3.6.17.tar.gz) = 3315365

Dependencies

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:

1. gmake : devel/gmake

Library dependencies:

1. libpq.so.5 : databases/postgresql95-client

There are no ports dependent upon this port

Configuration Options

===> The following configuration options are available for pgpool-II36-3.6.17_1: DOCS=on: Build and/or install documentation SSL=on: SSL protocol support ===> Use 'make config' to modify these settings

USES:

gmake libtool pgsql:9.3+ ssl

pkg-message:

If installing:

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.

Master Sites:

1. http://www.pgpool.net/mediawiki/images/

Convert to UCL & cleanup pkg-message (categories d)

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-36: Upgrade from 3.6.16 to 3.6.17

Changelog:

  Enhancements

    - Doc: Improve Reference II, PCP commands document. (Tatsuo Ishii)
    - 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)
    - Doc: add restrictions entry. (Takuma Hoshiai)

  Bug fixes

    - Fix the wrong error message "ERROR: connection cache is full", when all
backend nodes are down. (bug 487) (Bo Peng)
    - Remove unused .sgml file. (Takuma Hoshiai)

databases/pgpool-II-36: Upgrade from 3.6.15 to 3.6.16

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, Yugo Nagata)

      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-6-16.html

MFH:		2019Q2

databases/pgpool-II-36: Update from 3.6.14 to 3.6.15

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)
- Doc: Mention that schema qualifications cannot be used in
white/black_function_list.
- Fix typo about wd_priority in watchdog_setup.
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection.
- Doc: fix typo in logdir description. (bug 453)
- 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)
- Doc: Fix Japanese document typo in pcp_common_options.

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-3-6-15.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

databases/pgpool-II-36: Upgrade from 3.6.13 to 3.6.14

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-14.html

databases/pgpool-II-* build fine with OpenSSL 1.1.1 too

http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-3.4.20.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II35-3.5.17.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II36-3.6.13.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II37-3.7.6.log

Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

Update to 3.6.13

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-13.html

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

security/openssl-devel was removed, but there is a security/openssl111 now.

databases/pgpool-II-36: Update from 3.6.11 to 3.6.12

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-16.html

databases/pgpool-II-36: Update from 3.6.10 to 3.6.11

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-11.html

databases/pgpool-II-36: Update from 3.6.9 to 3.6.10

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-10.html

databases/pgpool-II-36: allow configuration of stop_mode

PR: 221312

databases/pgpool-II-36: Update from 3.6.6 to 3.6.9

Changelogs:
- http://www.pgpool.net/docs/latest/en/html/release-3-6-7.html
- http://www.pgpool.net/docs/latest/en/html/release-3-6-8.html
- http://www.pgpool.net/docs/latest/en/html/release-3-6-9.html

BROKEN_SSL: Add REASON for breakage

Reported by:	matwq

security/openssl-devel: Mark broken databases cat

databases/pgpool-II-36: Update from 3.6.4 to 3.6.6

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-5.html
Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-6-6.html

Fix PKGBASE collision with databases/pgpool

New port: databases/pgpool-II-36

This is an repo-copy of databases/pgpool-II-35 updated to 3.6.4

PR: 206839

17 vulnerabilities affecting 112 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2019-08-20 23:22:39