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-41 Connection pool server for PostgreSQL
4.1.17 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 View this port on Repology. pkg-fallout 4.1.17Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: Upstream EOL reaches on 2024-10-31
Expiration Date EXPIRATION DATE: 2024-12-31
Maintainer: tz@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2020-03-29 21:55:55
Last Update: 2023-10-26 20:34:04
Commit Hash: fb0a93b
People watching this port, also watch:: zrep
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

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
Expand this list (47 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II41-4.1.17/catalog.mk
  3. /usr/local/share/licenses/pgpool-II41-4.1.17/LICENSE
  4. /usr/local/share/licenses/pgpool-II41-4.1.17/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/failover.sh.sample
  23. @sample etc/follow_master.sh.sample
  24. @sample etc/pcp.conf.sample
  25. @sample etc/pgpool.conf.sample
  26. etc/pgpool.conf.sample-logical
  27. etc/pgpool.conf.sample-master-slave
  28. etc/pgpool.conf.sample-replication
  29. etc/pgpool.conf.sample-stream
  30. @sample etc/pgpool_remote_start.sample
  31. @sample etc/pool_hba.conf.sample
  32. etc/recovery_1st_stage.sample
  33. etc/recovery_2nd_stage.sample
  34. include/libpcp_ext.h
  35. include/pcp.h
  36. include/pool_process_reporting.h
  37. include/pool_type.h
  38. lib/libpcp.a
  39. lib/libpcp.so
  40. lib/libpcp.so.1
  41. lib/libpcp.so.1.0.0
  42. share/pgpool-II/insert_lock.sql
  43. share/pgpool-II/pgpool.pam
  44. @dir /var/run/pgpool
  45. @owner
  46. @group
  47. @mode
Collapse this list.
Dependency lines:
  • pgpool-II41>0:databases/pgpool-II-41
Conflicts:
CONFLICTS_INSTALL:
  • pgpool-II-[0-9][0-9]
  • pgpool-II[0-9][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-41/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgpool-II-41
  • pkg install pgpool-II41
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pgpool-II41
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1692247761 SHA256 (pgpool-II-4.1.17.tar.gz) = 9380669855e99f6db5bc2b9ec35884ad79458b5b8612e402559a6d810fde12fd SIZE (pgpool-II-4.1.17.tar.gz) = 4521098

Packages (timestamps in pop-ups are UTC):
pgpool-II41
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.1.174.1.174.1.24.1.174.1.17-4.1.2-
FreeBSD:13:quarterly4.1.174.1.174.1.154.1.174.1.174.1.174.1.174.1.17
FreeBSD:14:latest4.1.174.1.174.1.144.1.174.1.174.1.15-4.1.15
FreeBSD:14:quarterly4.1.174.1.17-4.1.174.1.174.1.174.1.174.1.17
FreeBSD:15:latest4.1.174.1.17n/a4.1.17n/a4.1.174.1.174.1.17
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/postgresql15-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pgpool-II41-4.1.17: DOCS=on: Build and/or install documentation MEMCACHED=off: Use memcached for in memory query cache PAM=off: Build with PAM support SSL=on: Build with OpenSSL support ===> Use 'make config' to modify these settings
Options name:
databases_pgpool-II-41
USES:
gmake libtool pgsql:11+ 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.

Number of commits found: 19

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.1.17
26 Oct 2023 20:34:04
commit hash: fb0a93b99bb7491af0ee804f0362f8b76acb3ef0commit hash: fb0a93b99bb7491af0ee804f0362f8b76acb3ef0commit hash: fb0a93b99bb7491af0ee804f0362f8b76acb3ef0commit hash: fb0a93b99bb7491af0ee804f0362f8b76acb3ef0 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Extend EXPIRATION_DATE

The EOL for the branch has been extended so extend the DEPRECATION and
EXPIRATION_DATE accordingly.

See:
https://www.pgpool.net/mediawiki/index.php/EOL_information

Approved by:	portmgr (blanket)
4.1.17
17 Aug 2023 18:34:19
commit hash: 4c377a43d34c8f8224e584a670102231547454d2commit hash: 4c377a43d34c8f8224e584a670102231547454d2commit hash: 4c377a43d34c8f8224e584a670102231547454d2commit hash: 4c377a43d34c8f8224e584a670102231547454d2 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.15=>4.1.17

- Mark DEPRECATED as upstream EOL reaches on 2023-12-31
- Set EXPIRATION_DATE 2023-12-31

Changelog:
https://www.pgpool.net/docs/latest/en/html/release-4-1-17.html

Approved by:	tz (private mail)
Approved by:	portmgr (blanket)
4.1.15
17 May 2023 16:30:15
commit hash: 9b178ffd7e2fd77fecb8c80d22f7c80bc9e93977commit hash: 9b178ffd7e2fd77fecb8c80d22f7c80bc9e93977commit hash: 9b178ffd7e2fd77fecb8c80d22f7c80bc9e93977commit hash: 9b178ffd7e2fd77fecb8c80d22f7c80bc9e93977 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
*/*: llvm15 build fixes

llvm15 was also merged into 13.2-STABLE effective from OSVERSION
1302505. Fix the ports that failed to build with llvm15.

Approved by:	portmgr (blanket)
4.1.15
15 Apr 2023 13:14:58
commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9commit hash: a40c0e7d8311e72078684f0a7ee388966a6adaf9 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
*/*: Remove pointers to EOLed pgsql versions

- Remove dotted pgsql versions

Approved by:	portmgr
4.1.15
20 Feb 2023 15:46:44
commit hash: 30a4a055da9b15b8eb567b78cdbf0fddd079e8cdcommit hash: 30a4a055da9b15b8eb567b78cdbf0fddd079e8cdcommit hash: 30a4a055da9b15b8eb567b78cdbf0fddd079e8cdcommit hash: 30a4a055da9b15b8eb567b78cdbf0fddd079e8cd files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.14=>4.1.15

Changelog:
https://www.pgpool.net/docs/latest/en/html/release-4-1-15.html

Approved by:	tz (mail)
Sponsored by:	Bounce Experts
4.1.14
31 Dec 2022 21:58:52
commit hash: ed9edf8d52c4a9eadbf16a09ea3be601c348773fcommit hash: ed9edf8d52c4a9eadbf16a09ea3be601c348773fcommit hash: ed9edf8d52c4a9eadbf16a09ea3be601c348773fcommit hash: ed9edf8d52c4a9eadbf16a09ea3be601c348773f files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.13=>4.1.14

Approved by:	tx (by private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-14.html
Sponsored by:	Bounce Experts
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)
4.1.13
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)
4.1.13
04 Sep 2022 19:03:52
commit hash: 8ca91c3e62bb315fcd97e37f51120f4e31b4cfa7commit hash: 8ca91c3e62bb315fcd97e37f51120f4e31b4cfa7commit hash: 8ca91c3e62bb315fcd97e37f51120f4e31b4cfa7commit hash: 8ca91c3e62bb315fcd97e37f51120f4e31b4cfa7 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.12=>4.1.13

Approved by:	tz (By private mail)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-13.html
Sponsored by:	Bounce Experts
4.1.12
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)
4.1.12
27 Jun 2022 03:11:28
commit hash: f18bcd860bda38b19aa0d770d4d129a698dbf1accommit hash: f18bcd860bda38b19aa0d770d4d129a698dbf1accommit hash: f18bcd860bda38b19aa0d770d4d129a698dbf1accommit hash: f18bcd860bda38b19aa0d770d4d129a698dbf1ac files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.10=>4.1.12

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-12.html
Sponsored by:	Bounce Experts
4.1.10
26 Dec 2021 19:05:19
commit hash: 3a30223f742b67369dd7aa0867a57e0ef7b9ffdfcommit hash: 3a30223f742b67369dd7aa0867a57e0ef7b9ffdfcommit hash: 3a30223f742b67369dd7aa0867a57e0ef7b9ffdfcommit hash: 3a30223f742b67369dd7aa0867a57e0ef7b9ffdf files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.6=>4.1.10

Approved by:	tz (private email)
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-10.html
Sponsored by:	Bounce Experts
4.1.6
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)
4.1.6
11 May 2021 16:42:32
commit hash: 45438e74330c2c62867565587c569d893fbff3e3commit hash: 45438e74330c2c62867565587c569d893fbff3e3commit hash: 45438e74330c2c62867565587c569d893fbff3e3commit hash: 45438e74330c2c62867565587c569d893fbff3e3 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-41: Update version 4.1.2=>4.1.6

- Pet portlint
- Fix pkg-plist. Except the default pgpool.conf.sample other
  pgpool.conf.sample* represents different configurations for different
  scenario. Only the pgpool.conf.sample should create a corresponding
  pgpool.conf file. Hence removing the @sample directive for the other
  pgpool.conf.sample*

Approved by:	tz
Relnotes: https://www.pgpool.net/docs/latest/en/html/release-4-1-6.html
Sponsored by:	Bounce Experts
Differential Revision:	https://reviews.freebsd.org/D30177
4.1.2
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
4.1.2
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.
4.1.2
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.
4.1.2
15 Jul 2020 18:14:38
Revision:542279Original commit files touched by this commit
tz search for other commits by this committer
databases/pgpool-II-41: Upgrade from 4.1.1 to 4.1.2

Changelog: Bug fixes

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

    Doc: Add note about if_up_cmd and if_down_cmd command. (Bo Peng)

    Fix pgpool ssl front end accept all ciphers. (bug 608) (Muhammad Usama)

    Downgrade too verbose authentication logs. (Tatsuo Ishii)

    Fix unnecessary checks. (Tatsuo Ishii)

    Doc: Fix typo. (Tatsuo Ishii)
(Only the first 15 lines of the commit message are shown above View all of this commit message)
4.1.1
29 Mar 2020 21:48:13
Revision:529842Original commit files touched by this commit
tz search for other commits by this committer
New port: databases/pgpool-II-41

Repocopy databases/pgpool-II-40 and modify it to introduce
new pgpool version 4.1.x.

Major enhancements in Pgpool-II 4.1 include:

    * Statement level load balancing.
    * Auto failback.
    * Enhance performance in number of areas.
        * Shared relation cache allows to reuse relation cache among sessions to
reduce internal queries against PostgreSQL system catalogs.
        * Have separate SQL parser for DML statements to eliminate unnecessary
parsing effort.
        * Load balancing control for specific queries.
    * Reduce Internal Queries against System Catalogs.
    * Import PostgreSQL 12 SQL parser.

PR:		244646
Submitted by:	Franko Ricci <franco.ricc@gmail.com>

Number of commits found: 19