PGPOOL_AD...NODE_INFO(3)

🌸 NAME 🌸

okay so bestie, welcome to the manual page for pgpool_adm_pcp_node_info — that's PGPOOL_AD...NODE_INFO(3) if you're keeping score — straight from the pgpool-II 4.7.2 Documentation. It's literally a function to display the information on the given node ID. no cap. ✨

---

💅 SYNOPSIS 💅

       pcp_node_info returns record(integer node_id, text host, integer port,
                                    text username, text password,
                                    out status text, out pg_status text,
                                    out weight float4, out role text,
                                    out pg_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 pg_status text,
                                    out weight float4, out role text,
                                    out pg_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. that's the whole vibe, bestie. 👑

---

🎀 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(node_id => 1, host => '', port => 11001, username => 't-ishii', password => 't-ishii');
            host | port  |      status       | pg_status | weight |  role   | pg_role | replication_delay | replication_state | replication_sync_state | last_status_change
           ------+-------+-------------------+-----------+--------+---------+---------+-------------------+-------------------+------------------------+---------------------
            /tmp | 11003 | Connection in use | up        |    0.5 | Standby | standby |                 0 | streaming         | async                  | 2021-02-27 15:10:19
           (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;

Note 🦋 pg_status, pg_role out parameters are new from Pgpool-II 4.3. If you have already installed pre-4.2 pgpool_adm extension, you can upgrade to the new one by using ALTER EXTENSION SQL command.

                    ALTER EXTENSION pgpool_adm UPDATE;

---

and that's the tea, bestie 🍓 — this whole thing lives under pgpool-II 4.7.2, the date on it is 2023, and PGPOOL_AD...NODE_INFO(3) is the manual name doing its little icon thing at the bottom. mwah 💅💖