BSD Portsdatabases/pgpool-II-47 4.7.3 FreeBSD
Connection pool server for PostgreSQL (4.7.X branch)
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
998953d5b7- License
- MIT
- Categories
- databases
- Package size
- 1498.6 KiB, 10187.9 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-47 | 4.7.3 |
| GhostBSD | databases/pgpool-II-47 | 4.7.2 |
Install
Binary package:
pkg install pgpool-II-47From the ports tree:
cd /usr/ports/databases/pgpool-II-47/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pgpool-II-47>0:databases/pgpool-II-47
LIB_DEPENDS= libpgpoolpcp.so:databases/pgpool-II-47Packages
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.7.3 | 4.7.3 | - | - | 4.7.3 |
| FreeBSD:14:quarterly | 4.7.3 | 4.7.3 | n/a | - | 4.7.3 |
| FreeBSD:15:latest | 4.7.3 | 4.7.3 | n/a | - | - |
| FreeBSD:15:quarterly | 4.7.3 | 4.7.3 | n/a | n/a | n/a |
| FreeBSD:16:latest | 4.7.3 | 4.7.3 | 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
- 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 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.
Files
pkg-plist 45
- bin/pcp_attach_node
- bin/pcp_detach_node
- bin/pcp_health_check_stats
- bin/pcp_invalidate_query_cache
- bin/pcp_log_rotate
- 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/libpgpoolpcp.a
- lib/libpgpoolpcp.so
- lib/libpgpoolpcp.so.3
- lib/libpgpoolpcp.so.3.0.0
- share/pgpool-II-47/insert_lock.sql
- share/pgpool-II-47/pgpool.pam
- @dir /var/run/pgpool
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| pgpool-II-4.7.3.tar.gz | 5.850112e+06 | 4bf9df3e13feb8e64bee486b4ea54c9076296c2d9406165b0b68d32086fce250 |
Master sites 1
- https://www.pgpool.net/source/