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

Newsfeed changes

The news feed page[s] were not laid out well. Two pages, disjointed information, hard to figure out how to use the optional parameters...

Thankfully, someone told me.

The new page is ready for your review. Please compare these two:

You may also be interested in the Github issue.
Port details
pgpool-II-46 Connection pool server for PostgreSQL (4.6.X branch)
4.6.0 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 Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: bofh@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2025-03-04 08:36:50
Last Update: 2025-03-04 08:33:14
Commit Hash: 7b361b1
People watching this port, also watch:: tmux, munin-node, memcached, gsasl, 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 (52 items)
Collapse this list.
  1. @ldconfig
  2. /usr/local/share/licenses/pgpool-II-46-4.6.0/catalog.mk
  3. /usr/local/share/licenses/pgpool-II-46-4.6.0/LICENSE
  4. /usr/local/share/licenses/pgpool-II-46-4.6.0/MIT
  5. bin/pcp_attach_node
  6. bin/pcp_detach_node
  7. bin/pcp_health_check_stats
  8. bin/pcp_invalidate_query_cache
  9. bin/pcp_log_rotate
  10. bin/pcp_node_count
  11. bin/pcp_node_info
  12. bin/pcp_pool_status
  13. bin/pcp_proc_count
  14. bin/pcp_proc_info
  15. bin/pcp_promote_node
  16. bin/pcp_recovery_node
  17. bin/pcp_reload_config
  18. bin/pcp_stop_pgpool
  19. bin/pcp_watchdog_info
  20. bin/pg_enc
  21. bin/pg_md5
  22. bin/pgpool
  23. bin/pgpool_setup
  24. bin/pgproto
  25. bin/watchdog_setup
  26. bin/wd_cli
  27. @sample etc/aws_eip_if_cmd.sh.sample
  28. @sample etc/aws_rtb_if_cmd.sh.sample
  29. @sample etc/escalation.sh.sample
  30. @sample etc/failover.sh.sample
  31. @sample etc/follow_primary.sh.sample
  32. @sample etc/pcp.conf.sample
  33. @sample etc/pgpool.conf.sample
  34. @sample etc/pgpool_remote_start.sample
  35. @sample etc/pool_hba.conf.sample
  36. @sample etc/replication_mode_recovery_1st_stage.sample
  37. @sample etc/replication_mode_recovery_2nd_stage.sample
  38. etc/recovery_1st_stage.sample
  39. include/libpcp_ext.h
  40. include/pcp.h
  41. include/pool_process_reporting.h
  42. include/pool_type.h
  43. lib/libpcp.a
  44. lib/libpcp.so
  45. lib/libpcp.so.2
  46. lib/libpcp.so.2.0.0
  47. share/pgpool-II/insert_lock.sql
  48. share/pgpool-II/pgpool.pam
  49. @dir /var/run/pgpool
  50. @owner
  51. @group
  52. @mode
Collapse this list.
Dependency lines:
  • pgpool-II-46>0:databases/pgpool-II-46
Conflicts:
CONFLICTS_INSTALL:
  • pgpool-II-[0-9][0-9]
  • pgpool-II[0-9][0-9]
To install the port:
cd /usr/ports/databases/pgpool-II-46/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/pgpool-II-46
  • pkg install pgpool-II-46
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
PKGNAME: pgpool-II-46
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1741071089 SHA256 (pgpool-II-4.6.0.tar.gz) = f68a6571442d7ea53b69f39d749ad457790b00180e19b019fc82e235bab07321 SIZE (pgpool-II-4.6.0.tar.gz) = 5396128

Packages (timestamps in pop-ups are UTC):
pgpool-II-46
ABIaarch64amd64armv6armv7i386powerpcpowerpc64powerpc64le
FreeBSD:13:latest4.6.04.6.0-4.6.04.6.0---
FreeBSD:13:quarterly--------
FreeBSD:14:latest4.6.04.6.0-4.6.04.6.0---
FreeBSD:14:quarterly--------
FreeBSD:15:latest4.6.04.6.0n/a4.6.0n/a---
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. gmake>=4.4.1 : devel/gmake
Library dependencies:
  1. libpq.so.5 : databases/postgresql16-client
There are no ports dependent upon this port

Configuration Options:
===> The following configuration options are available for pgpool-II-46-4.6.0: 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-46
USES:
gmake libtool pgsql ssl
pkg-message:
For install:
In order to start pgpool you need some more configuration: # sysrc pgpool_user="root" # service pgpool enable 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: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
4.6.0
04 Mar 2025 08:33:14
commit hash: 7b361b10fd6a780e1d89608cfbe1d930858c9afacommit hash: 7b361b10fd6a780e1d89608cfbe1d930858c9afacommit hash: 7b361b10fd6a780e1d89608cfbe1d930858c9afacommit hash: 7b361b10fd6a780e1d89608cfbe1d930858c9afa files touched by this commit
Muhammad Moinur Rahman (bofh) search for other commits by this committer
databases/pgpool-II-46: 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://www.pgpool.net
Release Note: https://www.pgpool.net/docs/latest/en/html/release-4-6-0.html

Number of commits found: 1