notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Port details
pgpool-II-40 Connection pool server for PostgreSQL
4.0.6 databases on this many watch lists=1 search for ports that depend on this port Find issues related to this port Report an issue related to this port 4.0.6Version of this port present on the latest quarterly branch.
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2018-11-15 21:06:40
Last Update: 2019-08-31 22:30:18
SVN Revision: 510422
License: MIT
Description:
SVNWeb : Homepage
pkg-plist: as obtained via: make generate-plist
Expand this list (39 items)
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II40-4.0.6/catalog.mk
  3. /usr/local/share/licenses/pgpool-II40-4.0.6/LICENSE
  4. /usr/local/share/licenses/pgpool-II40-4.0.6/MIT
  5. bin/pcp_attach_node
  6. bin/pcp_detach_node
  7. bin/pcp_node_count
  8. bin/pcp_node_info
  9. bin/pcp_pool_status
  10. bin/pcp_proc_count
  11. bin/pcp_proc_info
  12. bin/pcp_promote_node
  13. bin/pcp_recovery_node
  14. bin/pcp_stop_pgpool
  15. bin/pcp_watchdog_info
  16. bin/pg_enc
  17. bin/pg_md5
  18. bin/pgpool
  19. bin/pgpool_setup
  20. bin/pgproto
  21. bin/watchdog_setup
  22. @sample etc/pcp.conf.sample
  23. @sample etc/pgpool.conf.sample
  24. etc/pgpool.conf.sample-logical
  25. etc/pgpool.conf.sample-master-slave
  26. etc/pgpool.conf.sample-replication
  27. etc/pgpool.conf.sample-stream
  28. @sample etc/pool_hba.conf.sample
  29. include/libpcp_ext.h
  30. include/pcp.h
  31. include/pool_process_reporting.h
  32. include/pool_type.h
  33. lib/libpcp.a
  34. lib/libpcp.so
  35. lib/libpcp.so.1
  36. lib/libpcp.so.1.0.0
  37. share/pgpool-II/insert_lock.sql
  38. share/pgpool-II/pgpool.pam
  39. @dir /var/run/pgpool
Collapse this list.
Dependency lines:
  • pgpool-II40>0:databases/pgpool-II-40
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-40/ && make install clean
To add the package: pkg install pgpool-II40
PKGNAME: pgpool-II40
Flavors: there is no flavor information for this port.
distinfo:

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/postgresql11-client
There are no ports dependent upon this port

Configuration Options

USES:

pkg-message:
If installing:
Master Sites:
  1. http://www.pgpool.net/mediawiki/images/

Number of commits found: 14

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
31 Aug 2019 21:30:18
Original commit files touched by this commit  4.0.6
Revision:510422
tz search for other commits by this committer
databases/pgpool-II-40: Upgrade from 4.0.5 to 4.0.6

Changelog:

    Enhancements:
    - Doc: Update "Pgpool-II + Watchdog Setup Example" to support PostgreSQL 12.
(Bo Peng)
    - 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.
    - Doc: add description to pg_md5 man page how to show pool_passwd hashed
string. (Tatsuo Ishii)
    - Doc: add general description about failover. (Tatsuo Ishii)
    - Deal pgpool_adm extension with PostgreSQL 12. (Tatsuo Ishii)
(Only the first 15 lines of the commit message are shown above View all of this commit message)
13 Aug 2019 16:01:59
Original commit files touched by this commit  4.0.5_1
Revision:508835  Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
26 Jul 2019 20:46:57
Original commit files touched by this commit  4.0.5_1
Revision:507372
gerald search for other commits by this committer
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
17 May 2019 08:44:16
Original commit files touched by this commit  4.0.5
Revision:501845
tz search for other commits by this committer
databases/pgpool-II-40: Upgrade from 4.0.4 to 4.0.5

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)
(Only the first 15 lines of the commit message are shown above View all of this commit message)
08 Apr 2019 07:15:00
Original commit files touched by this commit  4.0.4
Revision:498353
tz search for other commits by this committer
databases/pgpool-II-40: Upgrade from 4.0.3 to 4.0.4

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.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
08 Mar 2019 15:58:23
Original commit files touched by this commit  4.0.3
Revision:495052
tz search for other commits by this committer
databases/pgpool-II-40: Update from 4.0.2 to 4.0.3

Changelog:

- Skip over "host=" when getting info from conninfo string. (Bo Peng)
- Test: Fix old JDBC functions and typos in regression test 068.memqcache_bug.
(Takuma Hoshiai)
- Doc: Fix configuration change timing regarding memory_cache_enabled. (Tatsuo
Ishii)
- Fix online recovery failed due to client_idle_limit_in_recovery in certain
cases. (bug 431) (Tatsuo Ishii)
- Reduce memory usage when large data set is returned from backend. (bug 462)
(Tatsuo Ishii)
- Test: Fix syntax error in extended query test script. (Tatsuo Ishii)
- Fix corner case bug when strip_quote() handle a empty query string. (bug 458)
(Tatsuo Ishii)
- Doc: Mention that schema qualifications cannot be used in
white/black_function_list. (Tatsuo Ishii)
- Fix typo about wd_priority in watchdog_setup. (Takuma Hoshiai)
- Fixed segfault when wd_lifecheck_method = 'query'. (bug 455) (Muhammad Usama)
- The fix was proposed by Muhammad Usama and some adjustments to the patch and
testing is done by Yugo Nagata.
- Fix Pgpool child segfault if failover occurs when trying to establish a
connection. (Tatsuo Ishii)
- Doc: fix typo in logdir description. (bug 453) (Tatsuo Ishii)
- Fix PAM authentication failed. (Takuma Hoshiai)
- Fix Pgpool-II hang if a client sends a extended query message such as close
after sync message but before next simple query. (Tatsuo Ishii)
- Fix Pgpool-II hang when idle_in_transaction_session_timeout = on. (bug 448)
(Tatsuo Ishii)

Changelog taken from:
http://www.pgpool.net/docs/latest/en/html/release-4-0-3.html

MFH:		2019Q1
28 Jan 2019 09:27:18
Original commit files touched by this commit  4.0.2_3
Revision:491466
tz search for other commits by this committer
databases/pgpool-II-40: add new configuration files to rc-script

pgpool 4.0 adds the configuration files "pool_hba.conf" and "pcp.conf", but
they weren't used until now. Also its possible to change there location
via rc.conf

PR:		235059
Submitted by:	 Franco Ricci <franco.ricc@gmail.com>
17 Jan 2019 11:15:44
Original commit files touched by this commit  4.0.2_2
Revision:490545
tobik search for other commits by this committer
databases/pgpool-II-40: Actually unbreak PAM option after r490475

Do not pass --without-pam to configure as it does not appear to
work correctly.  It also defines USE_PAM in config.h even when it
should not be defined and the build breaks.

auth/pool_hba.c:157:24: error: variable has incomplete type 'struct pam_conv'
static struct pam_conv pam_passw_conv = {
                       ^

http://beefy3.nyi.freebsd.org/data/112amd64-quarterly/490502/logs/errors/pgpool-II40-4.0.2_2.log

Pointy hat:	tobik
Approved by:	tz (maintainer)
16 Jan 2019 12:03:14
Original commit files touched by this commit  4.0.2_2
Revision:490475
tobik search for other commits by this committer
databases/pgpool-II-40: Unbreak PAM option

The PAM option is tangled up with the SSL option in a weird way.
SSL_CONFIGURE_WITH is set once before bsd.port.options.mk for
enabling SSL support and overwritten again after including
bsd.port.options.mk but only when PAM=on.

Setting options helper after this point is not really supported,
but --with-pam actually makes it to CONFIGURE_ARGS.  When options
helpers are processed the results are only realized later by make(1).
SSL_CONFIGURE_WITH has been defined before including bsd.port.options.mk,
so this sort of "works".

This, however, is presumably an implementation detail and enabling
the PAM option breaks SSL support since SSL_CONFIGURE_WITH is
overwritten with a new value: CONFIGURE_ARGS only has --with-pam
left and is missing --with-openssl.

PAM support does not depend on SSL support.  Just switch everything
to options helpers to fix this.

PR:		234817
Submitted by:	tobik
Approved by:	tz (maintainer)
12 Dec 2018 01:35:36
Original commit files touched by this commit  4.0.2_1
Revision:487272
gerald search for other commits by this committer
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
27 Nov 2018 09:36:59
Original commit files touched by this commit  4.0.2
Revision:485998
tz search for other commits by this committer
databases/pgpool-II-40: Upgrade from 4.0.1 to 4.0.2

Changelog: http://www.pgpool.net/docs/latest/en/html/release-4-0-2.html
22 Nov 2018 09:18:32
Original commit files touched by this commit  4.0.1
Revision:485584
tobik search for other commits by this committer
databases/pgpool-II-40: Drop incorrect BROKEN_SSL

openssl-devel was removed a while ago in favor of openssl111, but
pgpool-II-40 builds fine with OpenSSL 1.1.1, so BROKEN_SSL is not
needed in the first place.

http://beefy5.nyi.freebsd.org/data/120i386-default/485373/logs/pgpool-II40-4.0.1.log
http://beefy6.nyi.freebsd.org/data/120amd64-default/485373/logs/pgpool-II40-4.0.1.log

Pointy hat:	joneum
15 Nov 2018 22:09:04
Original commit files touched by this commit  4.0.1
Revision:485055
joneum search for other commits by this committer
Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
15 Nov 2018 21:06:27
Original commit files touched by this commit  4.0.1
Revision:485048
joneum search for other commits by this committer
New Port: databases/pgpool-II-40

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: http://pgpool.net/

PR:		232957
Reported by:	Franco Ricci <franco.ricc@gmail.com>
Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH

Number of commits found: 14

Login
User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
Issues
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
py-pillowOct 15
mod_perl2Oct 09
xpdfOct 06
xpdf3Oct 06
xpdf4Oct 06
unboundOct 03
cactiOct 02
gitlab-ceOct 02
gitlab-ceOct 02
ruby24Oct 02
ruby25Oct 02
mongodb34Sep 30
mongodb34Sep 30
mongodb36Sep 30
mongodb36Sep 30

8 vulnerabilities affecting 24 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2019-10-15 15:43:31


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 37997
Broken 396
Deprecated 425
Ignore 662
Forbidden 3
Restricted 160
No CDROM 74
Vulnerable 30
Expired 6
Set to expire 396
Interactive 0
new 24 hours 7
new 48 hours9
new 7 days28
new fortnight61
new month235

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2019 Dan Langille. All rights reserved.