[pgpool-general: 8365] pool_nodes column descriptions

[Jon SCHEWE]

What is the difference between the "status" and "pg_status" columns?
What is "role" vs. "pg_role"?

See the output below.

What are status and pg_status telling me about psql-02 vs. psql-03?

What are role and pg_role telling me about psql-02 vs. psql-03?

postgres=> show pool_nodes;
 node_id |       hostname       | port | status | pg_status | lb_weight |  role   | pg_role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+----------------------+------+--------+-----------+-----------+---------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
 0       | psql-01.mgmt.bbn.com | 5432 | up     | up        | 0.333333  | primary | primary | 36296249   | true              | 0                 | streaming         | sync                   | 2022-09-01 17:09:56
 1       | psql-02.mgmt.bbn.com | 5432 | down   | up        | 0.333333  | standby | standby | 33251154   | false             | 0                 |                   |                        | 2022-09-01 17:09:56
 2       | psql-03.mgmt.bbn.com | 5432 | down   | down      | 0.333333  | standby | unknown | 23681056   | false             | 0                 | streaming         | potential              | 2022-09-01 17:09:56
(3 rows)




Jon Schewe

Principal Software Systems Technologist

C: +1 612.263.2718

O: +1 952.545.5720

jon.schewe at raytheon.com

Raytheon BBN

Raytheon Intelligence & Space

5775 Wayzata Blvd. Suite 630

St. Louis Park, MN 55416


RTX.com<https://www.rtx.com/> | LinkedIn<https://www.linkedin.com/company/raytheontechnologies> | Twitter<https://twitter.com/raytheontech> | Instagram<https://www.instagram.com/raytheontechnologies>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20220901/6ffe6214/attachment.htm>