pgpool_adm
Administrative functions for pgPool
Overview
| Package | Version | Category | License | Language |
|---|---|---|---|---|
pgpool | 4.7.2 | ADMIN | PostgreSQL | C |
| ID | Extension | Bin | Lib | Load | Create | Trust | Reloc | Schema |
|---|---|---|---|---|---|---|---|---|
| 5900 | pgpool_adm | No | No | No | Yes | No | No | - |
| 5910 | pgpool_recovery | No | No | No | Yes | No | No | - |
| 5920 | pgpool_regclass | No | No | No | Yes | No | No | - |
| Related | pgautofailover pgbouncer_fdw repmgr pg_failover_slots bgw_replstatus pgnodemx pgmonitor pglogical pgactive |
|---|
Version
| Type | Repo | Version | PG Ver | Package | Deps |
|---|---|---|---|---|---|
| EXT | PGDG | 4.7.2 | 1817161514 | pgpool | - |
| RPM | PGDG | 4.7.2 | 1817161514 | pgpool-II-pg$v-extensions | - |
| DEB | PGDG | 4.7.2 | 1817161514 | postgresql-$v-pgpool2 | - |
Install
You can install pgpool directly. First, make sure the PGDG repository is added and enabled:
Install the extension using pig or apt/yum/dnf:
Install
pig
dnf
apt
Create Extension:
Usage
The pgpool_adm extension provides SQL-callable wrapper functions for Pgpool-II PCP (Pgpool Control Protocol) commands, enabling administration of Pgpool-II from within PostgreSQL.
Available Functions
| Function | Description |
|---|---|
pgpool_adm_pcp_node_info | Display information on a given backend node |
pgpool_adm_pcp_health_check_stats | Display health check statistics for a node |
pgpool_adm_pcp_pool_status | Retrieve parameters from pgpool.conf |
pgpool_adm_pcp_node_count | Get the number of backend nodes |
pgpool_adm_pcp_attach_node | Attach a backend node |
pgpool_adm_pcp_detach_node | Detach a backend node |
pgpool_adm_pcp_proc_info | Display Pgpool-II child process information |
Call Methods
Functions support two calling conventions:
Direct parameters (hostname, port, username, password, plus function-specific args):
Foreign server reference (uses port 9898 and credentials from ~/.pcppass):
Node Management
The default PCP communication port is 9898. Credentials can be managed via the .pcppass file in the user’s home directory.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)