WD_CLI

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