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
Port details
pgpool-II-37 Connection pool server for PostgreSQL
3.7.25 databases Deleted 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 View this port on Repology. pkg-fallout 3.7.25Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: Upstream EOL reaches on 2022-11 use pgpool-II-43
Expired This port expired on: 2022-12-30
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2018-04-18 10:33:08
Last Update: 2022-12-30 12:46:06
Commit Hash: 6b7bb92
People watching this port, also watch:: tmux, cyrus-sasl-sql, ip2location, mailutils, monit
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.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (40 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II37-3.7.25/catalog.mk
  3. /usr/local/share/licenses/pgpool-II37-3.7.25/LICENSE
  4. /usr/local/share/licenses/pgpool-II37-3.7.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. bin/pgpool_setup
  19. bin/watchdog_setup
  20. @sample etc/pcp.conf.sample
  21. @sample etc/pgpool.conf.sample
  22. etc/pgpool.conf.sample-logical
  23. etc/pgpool.conf.sample-master-slave
  24. etc/pgpool.conf.sample-replication
  25. etc/pgpool.conf.sample-stream
  26. @sample etc/pool_hba.conf.sample
  27. include/libpcp_ext.h
  28. include/pcp.h
  29. include/pool_process_reporting.h
  30. include/pool_type.h
  31. lib/libpcp.a
  32. lib/libpcp.so
  33. lib/libpcp.so.1
  34. lib/libpcp.so.1.0.0
  35. share/pgpool-II/insert_lock.sql
  36. share/pgpool-II/pgpool.pam
  37. @dir /var/run/pgpool
  38. @owner
  39. @group
  40. @mode
Collapse this list.
Dependency lines:
  • pgpool-II37>0:databases/pgpool-II-37
Conflicts:
CONFLICTS_INSTALL:
  • pgpool-II-[0-9][0-9]
  • pgpool-II[0-9][0-9]
No installation instructions:
This port has been deleted.
PKGNAME: pgpool-II37
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1662311300 SHA256 (pgpool-II-3.7.25.tar.gz) = 5d369c159cf35bfc621ac3c4a9fc474fc3e725a4c9de854eb2a12253c88b00dc SIZE (pgpool-II-3.7.25.tar.gz) = 3491406

Packages (timestamps in pop-ups are UTC):
pgpool-II37
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest--3.7.14---3.7.14-
FreeBSD:13:quarterly--------
FreeBSD:14:latest--------
FreeBSD:14:quarterly--------
FreeBSD:15:latest--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/postgresql13-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pgpool-II37-3.7.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-37
USES:
gmake libtool pgsql:9.6+ 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 moved to databases/pgpool-II-43 on 2022-12-30
    REASON: Has expired: Upstream EOL reaches on 2022-11 use pgpool-II-43

Number of commits found: 29

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
3.7.25
30 Dec 2022 12:46:06
commit hash: 6b7bb92761048799bdaaf0aabcc1d02771880c98commit hash: 6b7bb92761048799bdaaf0aabcc1d02771880c98commit hash: 6b7bb92761048799bdaaf0aabcc1d02771880c98commit hash: 6b7bb92761048799bdaaf0aabcc1d02771880c98 files touched by this commit
Rene Ladan (rene) search for other commits by this committer
cleanup: Remove expired ports:

2022-12-30 databases/pgpool-II-37: Upstream EOL reaches on 2022-11 use
pgpool-II-43
07 Sep 2022 21:58:51
commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4commit hash: fb16dfecae4a6efac9f3a78e0b759fb7a3c53de4 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Remove WWW entries moved into port Makefiles

Commit b7f05445c00f has added WWW entries to port Makefiles based on
WWW: lines in pkg-descr files.

This commit removes the WWW: lines of moved-over URLs from these
pkg-descr files.

Approved by:		portmgr (tcberner)
3.7.25
07 Sep 2022 21:10:59
commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52commit hash: b7f05445c00f2625aa19b4154ebcbce5ed2daa52 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Add WWW entries to port Makefiles

It has been common practice to have one or more URLs at the end of the
ports' pkg-descr files, one per line and prefixed with "WWW:". These
URLs should point at a project website or other relevant resources.

Access to these URLs required processing of the pkg-descr files, and
they have often become stale over time. If more than one such URL was
present in a pkg-descr file, only the first one was tarnsfered into
the port INDEX, but for many ports only the last line did contain the
port specific URL to further information.

There have been several proposals to make a project URL available as
a macro in the ports' Makefiles, over time.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
3.7.25
04 Sep 2022 19:03:51
commit hash: 9927d1c8889f1cce8a59be09e2719f7f94ff929ecommit hash: 9927d1c8889f1cce8a59be09e2719f7f94ff929ecommit hash: 9927d1c8889f1cce8a59be09e2719f7f94ff929ecommit hash: 9927d1c8889f1cce8a59be09e2719f7f94ff929e files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-37: Update version 3.7.24=>3.7.25

Approved by:	tz (By private mail)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-3-7-25.html
Sponsored by:	Bounce Experts
3.7.24
29 Jun 2022 15:57:40
commit hash: da00957fbe1f79c12851e0958ee7e4c8276a5527commit hash: da00957fbe1f79c12851e0958ee7e4c8276a5527commit hash: da00957fbe1f79c12851e0958ee7e4c8276a5527commit hash: da00957fbe1f79c12851e0958ee7e4c8276a5527 files touched by this commit
Stefan Eßer (se) search for other commits by this committer
Fix CONFLICTS_INSTALL in the databases category

Approved by:	portmgr (implicit)
3.7.24
27 Jun 2022 03:11:27
commit hash: 36cafd6c4c5c66c629c59d8e5a58cf513d1b9700commit hash: 36cafd6c4c5c66c629c59d8e5a58cf513d1b9700commit hash: 36cafd6c4c5c66c629c59d8e5a58cf513d1b9700commit hash: 36cafd6c4c5c66c629c59d8e5a58cf513d1b9700 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-37: Update version 3.7.23=>3.7.24

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-3-7-24.html
Sponsored by:	Bounce Experts
3.7.23
23 Mar 2022 14:25:48
commit hash: 9beeaa327d9180ebf9028c486371f07698664a17commit hash: 9beeaa327d9180ebf9028c486371f07698664a17commit hash: 9beeaa327d9180ebf9028c486371f07698664a17commit hash: 9beeaa327d9180ebf9028c486371f07698664a17 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-37: Update version 3.7.22=>3.7.23

- Add pgpool_flags rcvar for rc script
- Mark DEPRECATED as upstream EOL reaches on 2022-11
- Set EXPIRATION_DATE to 2022-12-30

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-3-7-23.html
Sponsored by:	Bounce Experts
3.7.22
26 Dec 2021 19:05:15
commit hash: 6bc34dba9385afd2c2e7e260da7b993e9d01f376commit hash: 6bc34dba9385afd2c2e7e260da7b993e9d01f376commit hash: 6bc34dba9385afd2c2e7e260da7b993e9d01f376commit hash: 6bc34dba9385afd2c2e7e260da7b993e9d01f376 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-37: Update version 3.7.14=>3.7.22

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-3-7-22.html
Sponsored by:	Bounce Experts
3.7.14
29 Oct 2021 09:50:18
commit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08acommit hash: 819f25b36d45b8ac5593ec8e6f470d9ad454b08a files touched by this commit
Stefan Eßer (se) search for other commits by this committer
*/*: Remove redundant '-[0-9]*' from CONFLICTS

The conflict checks compare the patterns first against the package
names without version (as reported by "pkg query "%n"), then - if
there was no match - agsinst the full package names including the
version (as reported by "pkg query "%n-%v").

Many CONFLICTS definitions used patterns like "bash-[0-9]*" to filter
for the bash package in any version. But that pattern is functionally
identical with just "bash".

Approved by:	portmgr (blanket)
3.7.14
07 Apr 2021 08:09:01
commit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455ccommit hash: cf118ccf875508b9a1c570044c93cfcc82bd455c files touched by this commit
Mathieu Arnold (mat) search for other commits by this committer
One more small cleanup, forgotten yesterday.
Reported by:	lwhsu
3.7.14
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.7.14
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.7.14
15 Jul 2020 18:09:41
Revision:542277Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.13 to 3.7.14

Changelog:

Bug fixes

    Fix build error on some system (Fedora 32). (Tatsuo Ishii)

    Fix unnecessary checks. (Tatsuo Ishii)

    Doc: Fix typo. (Tatsuo Ishii)

    Fix for segmentation fault in PCP process. (bug 598) (Muhammad Usama)

    Doc: Fix typo. (Tatsuo Ishii, Bo Peng)

    Fix Pgpool-II hangs when an Execute message is issued right after Sync
message and query cache hits. (Tatsuo Ishii)

    Fix problems in watchdog source code processing json data. (bug 596) (Tatsuo
Ishii)

    Fix possible data inconsistency in native replication mode. (Tatsuo Ishii)

    Fix watchdog ping probes fail with long hostnames due to small buffer. (bug
516) (Bo Peng)

Sponsored by:	Bounce Experts
3.7.13
15 Mar 2020 21:17:58
Revision:528504Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.11 to 3.7.13

Changelog for 3.7.12:

Bug fixes

    Fix incorrect query rewrite in replication mode. (Bo Peng)

    Fix that health check timeout does work in certain case. (Tatsuo Ishii)

    Discussion: [pgpool-hackers: 3458], [pgpool-hackers: 3459]

    Doc: add failover_command description when all standby nodes are down.
(Takuma Hoshiai)

    Doc: add note not to assign PostgreSQL servers to trusted_servers. (Tatsuo
Ishii)
(Only the first 15 lines of the commit message are shown above View all of this commit message)
3.7.11
31 Aug 2019 21:26:27
Revision:510421Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.10 to 3.7.11

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.
    - 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)

    Bug fixes:
(Only the first 15 lines of the commit message are shown above View all of this commit message)
3.7.10_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.7.10_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.7.10
17 May 2019 08:40:58
Revision:501844Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.9 to 3.7.10

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)
3.7.9
08 Apr 2019 07:12:39
Revision:498352Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.8 to 3.7.9

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-7-9.html

MFH:		2019Q2
3.7.8
08 Mar 2019 15:56:26
Revision:495051Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Update from 3.7.7 to 3.7.8

Changelog:

- 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)
- 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 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)
- Doc: Fix Japanese document typo in pcp_common_options. (Bo Peng)

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

MFH:		2019Q1
3.7.7_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.7.7
27 Nov 2018 09:36:19
Revision:485997Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Upgrade from 3.7.6 to 3.7.7

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-7-7.html
3.7.6
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.7.6
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.7.6
15 Nov 2018 21:53:44
Revision:485054Original commit files touched by this commit
joneum search for other commits by this committer
Update to 3.7.6

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

Approved by:	tz (implicit)
Sponsored by:	Netzkommune GmbH
3.7.5
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.7.5
31 Jul 2018 08:17:34
Revision:475978Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Update from 3.7.4 to 3.7.5

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-7-5.html
3.7.4
27 Jun 2018 11:03:24
Revision:473432Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-37: Update from 3.7.3 to 3.7.4

Changelog: http://www.pgpool.net/docs/latest/en/html/release-3-7-4.html
3.7.3
18 Apr 2018 10:32:53
Revision:467700Original commit files touched by this commit
tz search for other commits by this committer
New port: databases/pgpool-II-37

Repo-copy of databases/pgpool-II-36

PR:           227481
Submitted by: Franco Ricci <franco.ricc@gmail.com>

Number of commits found: 29