pgpool_adm_pcp_pool_status - a function to retrieves parameters in pgpool.conf.

pcp_server
           The foreign server name for pcp server.

       Otherarguments
           See pcp_common_options(1).

pcp_pool_status retrieves parameters in pgpool.conf.

       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)

pgpool-II 4.6.1                                       2023                         PGPOOL_ADM_PCP_POOL_STATUS(3)

       pgpool_adm_pcp_pool_status - a function to retrieves parameters in pgpool.conf.

pcp_pool_statusreturnssetofrecord(texthost,integerport,textusername,textpassword,outitemtext,outvaluetext,outdescriptiontext);pcp_pool_statusreturnssetofrecord(textpcp_server,outitemtext,outvaluetext,outdescriptiontext);