BSD Portsdatabases/pgpool-II-44 4.4.18 FreeBSD
Connection pool server for PostgreSQL (4.4.X branch)
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
1fcc8332f6- License
- MIT
- Categories
- databases
- Package size
- 1444.6 KiB, 9279.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.
Install
Binary package:
pkg install pgpool-II-44From the ports tree:
cd /usr/ports/databases/pgpool-II-44/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pgpool-II-44>0:databases/pgpool-II-44
LIB_DEPENDS= libpcp.so:databases/pgpool-II-44Packages
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.4.18 | 4.4.18 | - | 4.4.13 | 4.4.18 |
| FreeBSD:14:quarterly | 4.4.18 | 4.4.18 | n/a | 4.4.12 | 4.4.18 |
| FreeBSD:15:latest | 4.4.18 | 4.4.18 | n/a | 4.4.12 | 4.4.13 |
| FreeBSD:15:quarterly | 4.4.18 | 4.4.18 | n/a | n/a | n/a |
| FreeBSD:16:latest | 4.4.18 | 4.4.18 | 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 43
- 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/aws_eip_if_cmd.sh.sample
- @sample etc/aws_rtb_if_cmd.sh.sample
- @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-44/insert_lock.sql
- share/pgpool-II-44/pgpool.pam
- @dir /var/run/pgpool
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| pgpool-II-4.4.18.tar.gz | 5.316198e+06 | a09394fd16edbfcb5b0b9fab2c5b5a49ce3b5122f30481361693a28c13a4686a |
Master sites 1
- https://www.pgpool.net/source/