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-42 Connection pool server for PostgreSQL
4.2.12 databases 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 4.2.12Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: Upstream EOL reaches on 2025-11-30
Expiration Date EXPIRATION DATE: 2025-12-31
Maintainer: mike.jakubik@swiftsmsgateway.com search for ports maintained by this maintainer
Port Added: 2021-06-04 21:21:14
Last Update: 2023-10-26 20:34:04
Commit Hash: ed9c7c4
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 (53 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II42-4.2.12/catalog.mk
  3. /usr/local/share/licenses/pgpool-II42-4.2.12/LICENSE
  4. /usr/local/share/licenses/pgpool-II42-4.2.12/MIT
  5. bin/pcp_attach_node
  6. bin/pcp_detach_node
  7. bin/pcp_health_check_stats
  8. bin/pcp_node_count
  9. bin/pcp_node_info
  10. bin/pcp_pool_status
  11. bin/pcp_proc_count
  12. bin/pcp_proc_info
  13. bin/pcp_promote_node
  14. bin/pcp_recovery_node
  15. bin/pcp_reload_config
  16. bin/pcp_stop_pgpool
  17. bin/pcp_watchdog_info
  18. bin/pg_enc
  19. bin/pg_md5
  20. bin/pgpool
  21. bin/pgpool_setup
  22. bin/pgproto
  23. bin/watchdog_setup
  24. bin/wd_cli
  25. @sample etc/escalation.sh.sample
  26. @sample etc/failover.sh.sample
  27. @sample etc/follow_primary.sh.sample
  28. @sample etc/pcp.conf.sample
  29. @sample etc/pgpool.conf.sample
  30. @sample etc/pgpool_remote_start.sample
  31. @sample etc/pool_hba.conf.sample
  32. etc/pgpool.conf.sample-logical
  33. etc/pgpool.conf.sample-raw
  34. etc/pgpool.conf.sample-replication
  35. etc/pgpool.conf.sample-stream
  36. etc/pgpool.conf.sample-slony
  37. etc/pgpool.conf.sample-snapshot
  38. etc/recovery_1st_stage.sample
  39. etc/recovery_2nd_stage.sample
  40. include/libpcp_ext.h
  41. include/pcp.h
  42. include/pool_process_reporting.h
  43. include/pool_type.h
  44. lib/libpcp.a
  45. lib/libpcp.so
  46. lib/libpcp.so.2
  47. lib/libpcp.so.2.0.0
  48. share/pgpool-II/insert_lock.sql
  49. share/pgpool-II/pgpool.pam
  50. @dir /var/run/pgpool
  51. @owner
  52. @group
  53. @mode
Collapse this list.
Dependency lines:
  • pgpool-II42>0:databases/pgpool-II-42
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-42/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgpool-II-42
  • pkg install pgpool-II42
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pgpool-II42
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1682873414 SHA256 (pgpool-II-4.2.12.tar.gz) = 9f4a770aba2a60b047996bd5fd9ec6bf974560e73d483aff68d7a9455e93c5d0 SIZE (pgpool-II-4.2.12.tar.gz) = 4758162

Packages (timestamps in pop-ups are UTC):
pgpool-II42
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.2.124.2.12-4.2.124.2.12---
FreeBSD:13:quarterly4.2.124.2.124.2.124.2.124.2.124.2.124.2.124.2.12
FreeBSD:14:latest4.2.124.2.124.2.34.2.124.2.124.2.12-4.2.12
FreeBSD:14:quarterly4.2.124.2.12-4.2.124.2.124.2.124.2.124.2.12
FreeBSD:15:latest4.2.124.2.12n/a4.2.12n/a4.2.124.2.124.2.12
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-II42-4.2.12: 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-42
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: 10

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.2.12
26 Oct 2023 20:34:04
commit hash: ed9c7c4aefda89b6118eff5aef76bc94ffa33ed2commit hash: ed9c7c4aefda89b6118eff5aef76bc94ffa33ed2commit hash: ed9c7c4aefda89b6118eff5aef76bc94ffa33ed2commit hash: ed9c7c4aefda89b6118eff5aef76bc94ffa33ed2 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-42: 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.2.12
17 Aug 2023 18:34:19
commit hash: 7edbf61bbe6e8a0863afcb6bf91b8d5be91ccd9fcommit hash: 7edbf61bbe6e8a0863afcb6bf91b8d5be91ccd9fcommit hash: 7edbf61bbe6e8a0863afcb6bf91b8d5be91ccd9fcommit hash: 7edbf61bbe6e8a0863afcb6bf91b8d5be91ccd9f files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-42: Mark DEPRECATED

- Upstream EOL reaches on 2023-12-31
- Set EXPIRATION_DATE 2023-12-31

Approved by:	portmgr (blanket)
4.2.12
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.2.12
30 Apr 2023 18:33:29
commit hash: 7677a7924175f3b004adf1ebdec0a8fcfedb2248commit hash: 7677a7924175f3b004adf1ebdec0a8fcfedb2248commit hash: 7677a7924175f3b004adf1ebdec0a8fcfedb2248commit hash: 7677a7924175f3b004adf1ebdec0a8fcfedb2248 files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-42: Update version 4.2.3=>4.2.12

- Unbreak on HEAD

Changelog:
https://www.pgpool.net/docs/latest/en/html/release-4-2-11.html

Approved by:	portmgr (blanket)
4.2.3
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
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.2.3
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.2.3
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.2.3
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.2.3
04 Jun 2021 21:19:06
commit hash: c167b0329e65dd5bd69f4ae4e46eab05160b0661commit hash: c167b0329e65dd5bd69f4ae4e46eab05160b0661commit hash: c167b0329e65dd5bd69f4ae4e46eab05160b0661commit hash: c167b0329e65dd5bd69f4ae4e46eab05160b0661 files touched by this commit
Torsten Zuehlsdorff (tz) search for other commits by this committer
databases/pgpool-II-42: New port

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/

PR:		256128
Submitted by:	Mike Jakubik <mike.jakubik@swiftsmsgateway.com>

Number of commits found: 10