focal (3) pgpool_adm_pcp_node_info.3.gz

NAME

       pgpool_adm_pcp_node_info - a function to display the information on the given node ID

SYNOPSIS

       pcp_node_info returns record(integer node_id, text host, integer port, text username, text password,
                                    out status text, out weight float4, out role text,
                                    out replication_delay bigint, out replication_state text,
                                    out replication_sync_state text, out last_status_change timestamp);

       pcp_node_info returns record(integer node_id, text pcp_server, out status text, out weight float4,
                                    out role text, out replication_delay bigint, out replication_state text,
                                    out replication_sync_state text, out last_status_change timestamp);

DESCRIPTION

       pcp_node_info displays the information on the given node ID.

ARGUMENTS

       node_id
           The index of backend node to get information of.

       pcp_server
           The foreign server name for pcp server.

       Other arguments
           See pcp_common_options(1).

EXAMPLE

       Here is an example output:

               test=# SELECT * FROM pcp_node_info(1,'',11001,'t-ishii','t-ishii');
               host | port  |      status       | weight |  role   | replication_delay | replication_state | replication_sync_state | last_status_change
               ------+-------+-------------------+--------+---------+-------------------+-------------------+------------------------+---------------------
               /tmp | 11003 | Connection in use |      0 | Standby |                 0 | streaming         | async                  | 2019-04-23 15:02:46
               (1 row)

           Note
           role, replication_delay, last_status_change out parameters are new from Pgpool-II 4.0. If you have
           already installed pre-4.0 pgpool_adm extension, you can upgrade to the new one by using ALTER
           EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;

           Note
           replication_state and replication_sync_state out parameters are new from Pgpool-II 4.1. If you have
           already installed pre-4.1 pgpool_adm extension, you can upgrade to the new one by using ALTER
           EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;