View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000639 | Pgpool-II | General | public | 2020-08-23 20:45 | 2020-10-08 17:50 |
| Reporter | pgdude | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | feedback | Resolution | open | ||
| Platform | Linux | OS | Ubuntu | OS Version | 20.04 LTS |
| Product Version | 4.1.2 | ||||
| Summary | 0000639: Confused by wd_escalation_command and failover_command | ||||
| Description | I have pgpool2 working fine with failover_command working properly. It does a pg_ctl promote to make a standby the new primary. But I don't understand how wd_escalation_command relates to anything? When would you have a valid wd_escalation_command while at the same time have a valid failover_command? | ||||
| Tags | No tags attached. | ||||
|
|
"wd_escalation_command" and "wd_de_escalation_command" are executed when the watchdog status changes. "wd_escalation_command" and "wd_de_escalation_command" are not related to "failover_command". For example, you can use "wd_escalation_command" and "wd_de_escalation_command" to bring up/down VIP when the watchdog status changes. |
|
|
Are these related in anymore to putting Watchdog in "maintenance mode", ie, i want to bring down a pg standby temporarily? |
|
|
typo correction: Are these (wd_escalate and wd_de_escalate) related in any way to putting Watchdog in "maintenance mode", ie, i want to bring down a pg standby temporarily? |
|
|
> typo correction: > Are these (wd_escalate and wd_de_escalate) related in any way to putting Watchdog in "maintenance mode", ie, i want to bring down a pg standby temporarily? No. |
|
|
Have you resolved this issue? May I close this one? |
|
|
Would you provide more details on the differences between the failover command and the wd_escalation/de_escalation commands? Or show me where in the documentation it explains the difference? Thanks in advance. |
|
|
Regarding the previous request, it might be easier to state under what conditions you would execute the wd commands or are they executed automatically by pgpool2. |
|
|
> Would you provide more details on the differences between the failover command and the wd_escalation/de_escalation commands? "wd_escalation/de_escalation" commands are executed when the status of pgpool (watchdog) master node changes. "failover command" is executed when the status of PostgreSQL backend node changes. "wd_escalation/de_escalation" commands are executed in any of the following conditions: (1) At startup, when the pgpool (watchdog) master node is elected. (2) when the master pgpool (watchdog) node goes down (3) the new pgpool (watchdog) node is elected "failover" commands are executed in any of the following conditions: (1) When the health check fails (2) When read or write fails on PostgreSQL backend node (3) By remote Pgpool-II node (Watchdog) > Or show me where in the documentation it explains the difference? Sorry, we don't have such documentation that explicitly explains the difference. > Regarding the previous request, it might be easier to state under what conditions you would execute the wd commands or are they executed automatically by pgpool2. Yes, you are right. We should add more documentation or example that explains how to use these commands. |
|
|
The previous question: > typo correction: > Are these (wd_escalate and wd_de_escalate) related in any way to putting Watchdog in "maintenance mode", ie, i want to bring down a pg standby temporarily? Do you intend to avoid failover? Below is the Pgpool-II 4.2 documentation. This is a way to put a PostgreSQL backend node in "maintenance mode" to avoid failover. https://www.pgpool.net/docs/42/en/html/server-temporarily-shutdown.html |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-08-23 20:45 | pgdude | New Issue | |
| 2020-08-24 10:45 | pengbo | Assigned To | => pengbo |
| 2020-08-24 10:45 | pengbo | Status | new => assigned |
| 2020-08-24 11:16 | pengbo | Note Added: 0003507 | |
| 2020-08-24 11:17 | pengbo | Status | assigned => feedback |
| 2020-08-24 20:11 | pgdude | Note Added: 0003509 | |
| 2020-08-24 20:11 | pgdude | Status | feedback => assigned |
| 2020-08-24 20:13 | pgdude | Note Added: 0003510 | |
| 2020-08-25 13:54 | pengbo | Note Added: 0003513 | |
| 2020-08-25 13:57 | pengbo | Status | assigned => feedback |
| 2020-10-07 11:49 | pengbo | Note Added: 0003579 | |
| 2020-10-07 22:27 | pgdude | Note Added: 0003581 | |
| 2020-10-07 22:27 | pgdude | Status | feedback => assigned |
| 2020-10-07 22:28 | pgdude | Note Added: 0003582 | |
| 2020-10-08 17:42 | pengbo | Note Added: 0003583 | |
| 2020-10-08 17:50 | pengbo | Note Added: 0003584 | |
| 2020-10-08 17:50 | pengbo | Status | assigned => feedback |
