PCP_WATCHDOG_INFO(1)

📦
version 4.7.2 · 7 versions
, in ubuntu stonking

💖 PCP_WATCHDOG_INFO(1) 💖

okay bestie so this is pcp_watchdog_info from the pgpool-II 4.7.2 Documentation era, and it's literally the glow-up spotlight for your watchdog cluster 🔥 she's a PCP command, so she shows up in your terminal wearing her full PCP_WATCHDOG_INFO(1) name tag.

✨ NAME ✨

pcp_watchdog_info — shows off the watchdog status of the Pgpool-II, no cap

🌸 SYNOPSIS 🌸

pcp_watchdog_info [options...] [watchdog_id]

🦋 DESCRIPTION 🦋

pcp_watchdog_info pulls up the tea ☕ on whichever node ID you hand it. That's the whole vibe: give her a node, she gives you the info.

👑 OPTIONS 👑

  • -n watchdog_id / --node-id=watchdog_id — the index of the other Pgpool-II you want the info for, bestie.
Index 0 gets your own watchdog info — it's giving self-reflection 💅

If you just... don't pass it? Then she gets you info for all the watchdog nodes. Everyone gets a turn in the group chat.

Other options

🎀 EXAMPLE 🎀

Here's what the output is giving:

$ pcp_watchdog_info -h localhost -p 9898 -U postgres
Password:
3 3 YES server1:9999 Linux server1.localdomain server1

server1:9999 Linux server1.localdomain server1 9999 9000 4 LEADER 0 MEMBER
server2:9999 Linux server2.localdomain server2 9999 9000 7 STANDBY 0 MEMBER
server3:9999 Linux server3.localdomain server3 9999 9000 7 STANDBY 0 MEMBER

And the result is in this order, so you can actually read the vibe correctly:

The very first output line spills the watchdog cluster info:

  1. total watchdog nodes in the cluster
  2. total watchdog nodes in the cluster with active membership
  3. the local node's escalation status
  4. the leader node name
  5. the leader node host

Then it's the list of watchdog nodes, one per line:

  1. node name
  2. hostname
  3. pgpool port
  4. watchdog port
  5. current node state
  6. current node state name
  7. current cluster membership status
  8. current cluster membership status name

The --verbose option is lowkey the translator here — she helps the output actually make sense. For example:

$ pcp_watchdog_info -h localhost -p 9898 -U pgpool -v
Password:
Watchdog Cluster Information
Total Nodes              : 3
Remote Nodes             : 2
Member Remote Nodes      : 2
Alive Remote Nodes       : 2
Nodes required for quorum: 2
Quorum state             : QUORUM EXIST
Local node escalation    : YES
Leader Node Name         : server1:9999 Linux server1.localdomain
Leader Host Name         : server1

Watchdog Node Information
Node Name         : server1:9999 Linux server1.localdomain
Host Name         : server1
Delegate IP       : 192.168.56.150
Pgpool port       : 9999
Watchdog port     : 9000
Node priority     : 1
Status            : 4
Status Name       : LEADER
Membership Status : MEMBER

Node Name         : server2:9999 Linux server2.localdomain
Host Name         : server2
Delegate IP       : 192.168.56.150
Pgpool port       : 9999
Watchdog port     : 9000
Node priority     : 1
Status            : 7
Status Name       : STANDBY
Membership Status : MEMBER

Node Name         : server3:9999 Linux server3.localdomain
Host Name         : server3
Delegate IP       : 192.168.56.150
Pgpool port       : 9999
Watchdog port     : 9000
Node priority     : 1
Status            : 7
Status Name       : STANDBY
Membership Status : MEMBER

peak readability, honestly 🔥

okay that's the whole page bestie, go forth and vibe check your watchdog 🐕✨

mwah 💋 this was pgpool-II 4.7.2, dated 2023, signing off as your one and only PCP_WATCHDOG_INFO(1) — ily, stay quorum 🫶👑

📦 where this page comes from