View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000743 | Pgpool-II | General | public | 2022-01-20 01:37 | 2022-06-28 10:58 |
| Reporter | henri | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.3.0 | ||||
| Summary | 0000743: Enabling pgpool service to start automatically as documentation with Health Check set cause issues when rebooting | ||||
| Description | I was unsure where to reflect my observations. Following the documentation https://www.pgpool.net/docs/latest/en/html/example-cluster.html - it outlined “We set pgpool-II to start automatically on all servers" , "systemctl enable pgpool.service" What I’ve observed is that when the nodes within cluster are rebooted (e.g. patching cycle activity) , pgpool failover is triggered and I’ve observed inconsistent results causing an unusable cluster. I’ve read a few articles that strongly suggest not to start pgpool automatically. So why my question, what is best practices around this subject? | ||||
| Tags | No tags attached. | ||||
|
|
If you set the auto-start of Pgpool-II, you need to change the "search_primary_node_timeout" to an appropriate value that you can start the PostgreSQL after the server has been started. Pgpool-II will fail and trigger failover, if it can't connect to the PostgreSQL on the backend during the "search_primary_node_timeout". If you don't want to set "search_primary_node_timeout" to a bigger value, I recommend that you disable auto starting for Pgpool-II. |
|
|
Have you resolved this issue? May I close this issue? |
|
|
No response over two weeks. Close issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2022-01-20 01:37 | henri | New Issue | |
| 2022-01-20 10:36 | pengbo | Note Added: 0003984 | |
| 2022-01-20 10:36 | pengbo | Assigned To | => pengbo |
| 2022-01-20 10:36 | pengbo | Status | new => feedback |
| 2022-06-02 13:53 | administrator | Note Added: 0004055 | |
| 2022-06-28 10:58 | pengbo | Note Added: 0004068 | |
| 2022-06-28 10:58 | pengbo | Status | feedback => closed |
