---
name: "pgpool_adm_pcp_pool_status"
section: "3"
platform: "linux"
package: "pgpool2"
version: "4.6.1-2"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/pgpool_adm_pcp_pool_status"
---

# pgpool\_adm\_pcp\_pool\_status(3)

a function to retrieves parameters in pgpool.conf.

## NAME

pgpool\_adm\_pcp\_pool\_status - a function to retrieves parameters in pgpool.conf.

## SYNOPSIS

**pcp\_pool\_status returns setof record(text** *host***, integer** *port***, text** *username***, text** *password***, out** *item text***, out** *value text***, out** *description text***);**

**pcp\_pool\_status returns setof record(text** *pcp\_server***, out** *item text***, out** *value text***, out** *description text***);**

## DESCRIPTION

**pcp\_pool\_status** retrieves parameters in pgpool.conf.

## ARGUMENTS

*pcp\_server*

The foreign server name for pcp server.

**Other arguments**

See [**pcp\_common\_options**(1)](/pcp_common_options/1.md).

## EXAMPLE

Here is an example output:

```
    test=# SELECT * FROM pcp_pool_status(host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii') WHERE item ~ 'backend.*0';
    item           |                     value                      |          description
    -------------------------+------------------------------------------------+-------------------------------
    backend_hostname0       | /tmp                                           | backend #0 hostname
    backend_port0           | 11002                                          | backend #0 port number
    backend_weight0         | 0.500000                                       | weight of backend #0
    backend_data_directory0 | /home/t-ishii/work/pgpool-II/current/aaa/data0 | data directory for backend #0
    backend_status0         | 2                                              | status of backend #0
    backend_flag0           | ALLOW_TO_FAILOVER                              | backend #0 flag
    (6 rows)
```