BSD Portsdatabases/pgpool-II-43 4.3.21 FreeBSD
Connection pool server for PostgreSQL (4.3.X branch)
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
f593eaa24d- License
- MIT
- Categories
- databases
- Package size
- 1417.4 KiB, 8825.2 KiB installed
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.
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/pgpool-II-43 | 4.3.21 |
| DragonFly | databases/pgpool-II-43 | 4.3.14 |
Install
Binary package:
pkg install pgpool-II-43From the ports tree:
cd /usr/ports/databases/pgpool-II-43/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pgpool-II-43>0:databases/pgpool-II-43
LIB_DEPENDS= libpcp.so:databases/pgpool-II-43Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 4.3.21 | 4.3.21 | 4.3.4 | 4.3.16 | 4.3.21 |
| FreeBSD:14:quarterly | 4.3.21 | 4.3.21 | n/a | 4.3.15 | 4.3.21 |
| FreeBSD:15:latest | 4.3.21 | 4.3.21 | n/a | 4.3.15 | 4.3.16 |
| FreeBSD:15:quarterly | 4.3.21 | 4.3.21 | n/a | n/a | n/a |
| FreeBSD:16:latest | 4.3.21 | 4.3.21 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
The Makefile names none itself; they come from USES and USE_*.
The full lists below include those, and their dependencies in turn.
Build dependencies 7
Run dependencies 6
No port depends on this one.
Configuration
Options name: databases_pgpool-II
| Option | Default | Description |
|---|---|---|
| DOCS | off | 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 |
- USES
- gmake libtool pgsql:11+
- Service scripts
pgpool- Conflicts with
- pgpool-II-[0-9][0-9] pgpool-II[0-9][0-9]
Message after installing
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.
Files
pkg-plist 41
- bin/pcp_attach_node
- bin/pcp_detach_node
- bin/pcp_health_check_stats
- bin/pcp_node_count
- bin/pcp_node_info
- bin/pcp_pool_status
- bin/pcp_proc_count
- bin/pcp_proc_info
- bin/pcp_promote_node
- bin/pcp_recovery_node
- bin/pcp_reload_config
- bin/pcp_stop_pgpool
- bin/pcp_watchdog_info
- bin/pg_enc
- bin/pg_md5
- bin/pgpool
- bin/pgpool_setup
- bin/pgproto
- bin/watchdog_setup
- bin/wd_cli
- @sample etc/escalation.sh.sample
- @sample etc/failover.sh.sample
- @sample etc/follow_primary.sh.sample
- @sample etc/pcp.conf.sample
- @sample etc/pgpool.conf.sample
- @sample etc/pgpool_remote_start.sample
- @sample etc/pool_hba.conf.sample
- @sample etc/replication_mode_recovery_1st_stage.sample
- @sample etc/replication_mode_recovery_2nd_stage.sample
- etc/recovery_1st_stage.sample
- include/libpcp_ext.h
- include/pcp.h
- include/pool_process_reporting.h
- include/pool_type.h
- lib/libpcp.a
- lib/libpcp.so
- lib/libpcp.so.2
- lib/libpcp.so.2.0.0
- share/pgpool-II-43/insert_lock.sql
- share/pgpool-II-43/pgpool.pam
- @dir /var/run/pgpool
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| pgpool-II-4.3.21.tar.gz | 5.133714e+06 | 71c885b8297abbb272bae8805cff752c0f920eda7eccd640c8668d5c1af6862c |
Master sites 1
- https://www.pgpool.net/source/