notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details
pgpool-II-35 Connection pool server for PostgreSQL
3.5.25 databases Deleted on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 3.5.25Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: EOL since January 2021, please use one of the other pgpool-II-* ports
Expired This port expired on: 2021-06-30
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2017-05-16 10:19:16
Last Update: 2021-07-01 14:35:43
Commit Hash: d6db6bd
License: MIT
WWW:
https://pgpool.net/
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/
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
pkg-plist: as obtained via: make generate-plist
Expand this list (38 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II35-3.5.25/catalog.mk
  3. /usr/local/share/licenses/pgpool-II35-3.5.25/LICENSE
  4. /usr/local/share/licenses/pgpool-II35-3.5.25/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_md5
  17. bin/pgpool
  18. @sample etc/pcp.conf.sample
  19. @sample etc/pgpool.conf.sample
  20. etc/pgpool.conf.sample-master-slave
  21. etc/pgpool.conf.sample-replication
  22. etc/pgpool.conf.sample-stream
  23. @sample etc/pool_hba.conf.sample
  24. include/libpcp_ext.h
  25. include/pcp.h
  26. include/pool_process_reporting.h
  27. include/pool_type.h
  28. lib/libpcp.a
  29. lib/libpcp.so
  30. lib/libpcp.so.1
  31. lib/libpcp.so.1.0.0
  32. man/man8/pgpool.8.gz
  33. share/pgpool-II/insert_lock.sql
  34. share/pgpool-II/pgpool.pam
  35. @dir /var/run/pgpool
  36. @owner
  37. @group
  38. @mode
Collapse this list.
Dependency lines:
  • pgpool-II35>0:databases/pgpool-II-35
Conflicts:
CONFLICTS:
  • pgpool-II-[0-9]*
Conflicts Matches:
There are no Conflicts Matches for this port. This is usually an error.
No installation instructions:
This port has been deleted.
PKGNAME: pgpool-II35
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1594799196 SHA256 (pgpool-II-3.5.25.tar.gz) = dddea93e0fdf3bef03abcdc127696b8e2efcf7b3d2819561a926514ab2f71aff SIZE (pgpool-II-3.5.25.tar.gz) = 2287943

Packages (timestamps in pop-ups are UTC):
pgpool-II35
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.5.25---3.5.25-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--n/a-n/a---
FreeBSD:15:quarterly--n/a-n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.3 : devel/gmake
Library dependencies:
  1. libpq.so.5 : databases/postgresql12-client
There are no ports dependent upon this port

Configuration Options:
===> 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
Options name:
databases_pgpool-II-35
USES:
gmake libtool pgsql:9.3+ ssl
pkg-message:
For install:
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:
Expand this list (1 items)
Collapse this list.
  1. http://www.pgpool.net/mediawiki/images/
Collapse this list.
Port Moves
  • port deleted on 2021-07-01
    REASON: Has expired: EOL since January 2021, please use one of the other pgpool-II-* ports

Number of commits found: 26

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.5.25
01 Jul 2021 14:35:43
commit hash: d6db6bd18b42829b9bf5cb7a638051a7ff53ab5bcommit hash: d6db6bd18b42829b9bf5cb7a638051a7ff53ab5bcommit hash: d6db6bd18b42829b9bf5cb7a638051a7ff53ab5bcommit hash: d6db6bd18b42829b9bf5cb7a638051a7ff53ab5b files touched by this commit
Rene Ladan (rene) search for other commits by this committer
*/*: Remove expired ports:

2021-06-30 databases/pgpool-II-35: EOL since January 2021, please use one of the
other pgpool-II-* ports
3.5.25
18 May 2021 22:26:03
commit hash: 765fb8c7812bd1bcfd7a52f9614b11d769690346commit hash: 765fb8c7812bd1bcfd7a52f9614b11d769690346commit hash: 765fb8c7812bd1bcfd7a52f9614b11d769690346commit hash: 765fb8c7812bd1bcfd7a52f9614b11d769690346 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
databases/pgpool-II-35: set DEPRECATED and EXPIRATION_DATE

The port reached EOL in January 2021. You can get EOL information here:
https://www.pgpool.net/mediawiki/index.php/EOL_information

Sponsored by:	Bounce Experts
3.5.25
06 Apr 2021 14:31:13
commit hash: 135fdeebb99c3569e42d8162b265e15d29bd937dcommit hash: 135fdeebb99c3569e42d8162b265e15d29bd937dcommit hash: 135fdeebb99c3569e42d8162b265e15d29bd937dcommit hash: 135fdeebb99c3569e42d8162b265e15d29bd937d files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
all: Remove all other $FreeBSD keywords.
3.5.25
06 Apr 2021 14:31:07
commit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344ebcommit hash: 305f148f482daf30dcf728039d03d019f88344eb files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
Remove # $FreeBSD$ from Makefiles.
3.5.25
15 Jul 2020 18:03:58
Revision:542275Original commit files touched by this commit
tz search for other commits by this committer
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
3.5.24
15 Mar 2020 21:14:00
Revision:528502Original commit files touched by this commit
tz search for other commits by this committer
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 View all of this commit message)
3.5.22
31 Aug 2019 21:16:33
Revision:510419Original commit files touched by this commit
tz search for other commits by this committer
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 View all of this commit message)
3.5.21_1
13 Aug 2019 16:01:59
Revision:508835Original commit files touched by this commit Sanity Test Failure
mat search for other commits by this committer
Convert to UCL & cleanup pkg-message (categories d)
3.5.21_1
26 Jul 2019 20:46:57
Revision:507372Original commit files touched by this commit
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
3.5.21
17 May 2019 08:33:16
Revision:501842Original commit files touched by this commit
tz search for other commits by this committer
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
3.5.20
08 Apr 2019 07:08:09
Revision:498350Original commit files touched by this commit
tz search for other commits by this committer
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
3.5.19
08 Mar 2019 15:53:04
Revision:495049Original commit files touched by this commit
tz search for other commits by this committer
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
3.5.18_1
12 Dec 2018 01:35:36
Revision:487272Original commit files touched by this commit
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
3.5.18
27 Nov 2018 09:34:40
Revision:485995Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-35: Upgrade from 3.5.17 to 3.5.18

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-18.html
3.5.17
22 Nov 2018 09:32:45
Revision:485587Original commit files touched by this commit
tobik search for other commits by this committer
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
3.5.17
15 Nov 2018 22:09:04
Revision:485055Original commit files touched by this commit
joneum search for other commits by this committer
Fix WWW

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
3.5.17
15 Nov 2018 21:49:10
Revision:485052Original commit files touched by this commit
joneum search for other commits by this committer
Update to 3.5.17

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

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
3.5.16
10 Nov 2018 10:09:49
Revision:484599Original commit files touched by this commit
mat search for other commits by this committer
security/openssl-devel was removed, but there is a security/openssl111 now.
3.5.16
31 Jul 2018 08:14:48
Revision:475976Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-35: Update from 3.5.15 to 3.5.16

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-16.html
3.5.15
27 Jun 2018 11:02:14
Revision:473430Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-35: Update from 3.5.14 to 3.5.15

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-15.html
3.5.14
18 Apr 2018 12:25:47
Revision:467707Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-35: Update from 3.5.13 to 3.5.14

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-5-14.html
3.5.13
21 Feb 2018 11:05:57
Revision:462490Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-35: Update from 3.5.8 to 3.5.13

Changelogs:
- http://www.pgpool.net/docs/latest/en/html/release-3-5-9.html
- http://www.pgpool.net/docs/latest/en/html/release-3-5-10.html
- http://www.pgpool.net/docs/latest/en/html/release-3-5-11.html
- http://www.pgpool.net/docs/latest/en/html/release-3-5-12.html
- http://www.pgpool.net/docs/latest/en/html/release-3-5-13.html
3.5.8
16 Feb 2018 17:52:50
Revision:462050Original commit files touched by this commit
brnrd search for other commits by this committer
BROKEN_SSL: Add REASON for breakage

Reported by:	matwq
3.5.8
16 Feb 2018 14:03:22
Revision:462016Original commit files touched by this commit
brnrd search for other commits by this committer
security/openssl-devel: Mark broken databases cat
3.5.8
16 May 2017 20:01:43
Revision:441053Original commit files touched by this commit
antoine search for other commits by this committer
Fix PKGBASE collision with databases/pgpool
3.5.8
16 May 2017 10:19:06
Revision:440994Original commit files touched by this commit
tz search for other commits by this committer
New port: databases/pgpool-II-35

This is an repo-copy of databases/pgpool updated to 3.5.8

PR: 206839

Number of commits found: 26