Man page - wd_cli(1)

Packages contas this manual

Package: pgpool2
apt-get install pgpool2

Manuals in package:

Documentations in package:

pgpool2

Package: pgpool2
apt-get install pgpool2

Manuals in package:

Documentations in package:

pgpool2

Manual

WD_CLI(1)

pgpool-II 4.7.1 Documentation

WD_CLI(1)

NAME

wd_cli - Watchdog Command Line Interface (CLI) utility for the external health-check system integration.

SYNOPSIS

wd_cli [operation...] [node search option...] [option...]

DESCRIPTION

wd_cli Provides a convenient and easy to use interface to interact with watchdog and perform health check related node operations.

OPERATIONS

-i
--info

Get the node status for node(s) based on node search criteria

-I NEW_STATUS
--inform=NEW_STATUS

Update the watchdog node status. Allowed values are DEAD and ALIVE

NODE SEARCH OPTIONS

-a
--all

Select all nodes (only available with --info operation)

-n WATCHDOG_NODE_ID
--node-id=WATCHDOG_NODE_ID

Select watchdog node by node_id.

-N NODE_NAME
--node-name=NODE_NAME

Select watchdog node by name.

-H HOSTNAME
--node-host=HOSTNAME

Select watchdog node by hostname.

-P PORT_NO
--node-port=PORT_NO

Select watchdog node by port number.

OPTIONS

-k KEY
--auth-key=KEY

Watchdog auth key. Specifying auth-key over rides the pgpool.conf->wd_authkey value.

-f CONFIG_FILE
--config-file=CONFIG_FILE

Specifies the pgpool.conf file.

-s SOCKET_DIR
--socket-dir=SOCKET_DIR

Path to the watchdog IPC socket directory. Specifying socket-dir over rides the pgpool.conf->wd_ipc_socket_dir value.

-p PORT_NO
--ipc-port=PORT_NO

Port number of watchdog IPC socket. Specifying ipc-port over rides the pgpool.conf->wd_port value.

-m message_string
--message=message_string

Optional message string to be passed to Pgpool-II along with the node status.

-v
--verbose

Enable verbose messages.

-V
--version

Prints version information.

-d
--debug

Enable debug output.

-h
--help

Prints the help for wd_cli.

EXAMPLE

When some external health-check system is configured to monitor the health of Pgpool-II cluster and it detects a node failure. wd_cli utility can be used to pass this information to Pgpool-II cluster so that it can take the appropriate actions.



    #inform Pgpool-II about node named RN-110 failure


    wd_cli --inform DEAD -N 'RN-110' -p 9001 -m 'Pgpool node with name RN-110 is not reachable'



    #inform Pgpool-II about node-id 10 failure


    wd_cli --inform DEAD -n 10 -m 'Pgpool node with ID 10 is not responding'

Similarly to inform Pgpool-II about the node is alive again.



    #inform Pgpool-II about node-id 10 re-joining


    wd_cli --inform ALIVE -n 10 -m 'Pgpool node with ID 10 is reachable again'

wd_cli can also be used to get the current status of cluster nodes.



    wd_cli -f simple_conf/watchdog/pgpool_wd1.conf --info -v --all
	Total Watchdog nodes configured for lifecheck:  2
	*****************
	Node ID:           0
	Node Status code   4
	Node Status:       LEADER
	Node Name:         localhost:9991 Linux localhost.localdomain
	Node Host:         localhost
	Node WD Port:      9001
	Node Pgpool Port:  9991
	Node ID:           1
	Node Status code   7
	Node Status:       STANDBY
	Node Name:         localhost:9992 Linux localhost.localdomain
	Node Host:         localhost
	Node WD Port:      9002
	Node Pgpool Port:  9992

2023	pgpool-II 4.7.1