[pgpool-hackers: 3926] Re: Allow pcp_node_ino to list all backend nodes information

Tatsuo Ishii ishii at sraoss.co.jp
Sun Jun 13 12:03:07 JST 2021


> I created a patch to allow pcp_node_info command to 
> list all backend nodes information.
> 
> Currently pcp_node_info command can only display the node information 
> which is specified using "-n" or "--node-id" option.
> 
>   $ pcp_node_info -w -p 11001 -n 0
>   /tmp 11002 1 0.500000 waiting up primary primary 0 none none 2021-06-12 01:00:21
> 
>   $ pcp_node_info -w -p 11001 -n 1
>   /tmp 11003 1 0.500000 waiting up standby standby 0 streaming async 2021-06-12 01:00:21
> 
> 
> This patch allows pcp_node_info command to list all backend nodes information 
> using "-a" or "--all" option.
> 
>   $ pcp_node_info -w -p 11001 -a 
>   /tmp 11002 1 0.500000 waiting up primary primary 0 none none 2021-06-12 01:00:21
>   /tmp 11003 1 0.500000 waiting up standby standby 0 streaming async 2021-06-12 01:00:21
> 
>   $ pcp_node_info -w -p 11001 -a -v
>   Hostname               : /tmp
>   Port                   : 11002
>   Status                 : 1
>   Weight                 : 0.500000
>   Status Name            : waiting
>   Backend Status Name    : up
>   Role                   : primary
>   Backend Role           : primary
>   Replication Delay      : 0
>   Replication State      : none
>   Replication Sync State : none
>   Last Status Change     : 2021-06-12 01:00:21
> 
>   Hostname               : /tmp
>   Port                   : 11003
>   Status                 : 1
>   Weight                 : 0.500000
>   Status Name            : waiting
>   Backend Status Name    : up
>   Role                   : standby
>   Backend Role           : standby
>   Replication Delay      : 0
>   Replication State      : streaming
>   Replication Sync State : async
>   Last Status Change     : 2021-06-12 01:00:21

The patch applied cleanly, compiled fine, and worked as
advertised. Also all regression tests passed. Thank you for the great
work!

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp


More information about the pgpool-hackers mailing list