BSD Portsdatabases/pgpool-II-46 4.6.8 FreeBSD
Connection pool server for PostgreSQL (4.6.X branch)
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- Last update
- Commit
0673bd0876- License
- MIT
- Categories
- databases
- Package size
- 1484.1 KiB, 10027.8 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-46From the ports tree:
cd /usr/ports/databases/pgpool-II-46/ && make install cleanTo depend on this port in another port's Makefile:
RUN_DEPENDS= pgpool-II-46>0:databases/pgpool-II-46
LIB_DEPENDS= libpcp.so:databases/pgpool-II-46Packages
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.6.8 | 4.6.8 | - | 4.6.3 | 4.6.8 |
| FreeBSD:14:quarterly | 4.6.8 | 4.6.8 | n/a | 4.6.2 | 4.6.8 |
| FreeBSD:15:latest | 4.6.8 | 4.6.8 | n/a | 4.6.2 | 4.6.3 |
| FreeBSD:15:quarterly | 4.6.8 | 4.6.8 | n/a | n/a | n/a |
| FreeBSD:16:latest | 4.6.8 | 4.6.8 | 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/libpcp.a
- lib/libpcp.so
- lib/libpcp.so.2
- lib/libpcp.so.2.0.0
- share/pgpool-II-46/insert_lock.sql
- share/pgpool-II-46/pgpool.pam
- @dir /var/run/pgpool
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| pgpool-II-4.6.8.tar.gz | 5.853743e+06 | eaf153a4fc9b546d5b5846f2677c12ec06e7aea71b60861b96976dd4d20919c9 |
Master sites 1
- https://www.pgpool.net/source/