View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000363 | Pgpool-II | General | public | 2017-11-08 17:51 | 2017-11-09 13:03 |
| Reporter | marcellus | Assigned To | pengbo | ||
| Priority | normal | Severity | tweak | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.6.6 | ||||
| Summary | 0000363: health check not detect node after down | ||||
| Description | Hi, i am newbie for pgpool app, i have an issue with the health check where when the node status is still down after i stop and start the service postgresql server. i must stop and start the pgpool so the pgpool will detect the node was down. my question is, how to pgpool detect the server from down state to up state without restart the pgpool app? i use this version : pgpool-II version 3.6.6 (subaruboshi), postgresql9.6 i attach my pgpool.conf and pgpool.log Thanks, | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
When the postgreSQL server is down, the Pgpool-II will detach the down PostgreSQL server. So you need to attach this PostgreSQL server again after restarting the PostgreSQL to let Pgpool-II know this node. Using "pcp_attach_node" to attach PostgreSQL node. http://www.pgpool.net/docs/latest/en/html/pcp-attach-node.html Example: # pcp_attach_node -u <username> -p <pcp_port> -n <node-id> |
|
|
Hi, Thanks for the info, it running well. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-11-08 17:51 | marcellus | New Issue | |
| 2017-11-08 17:51 | marcellus | File Added: pgpool.conf | |
| 2017-11-08 17:51 | marcellus | File Added: pgpool.log | |
| 2017-11-09 08:47 | pengbo | Note Added: 0001813 | |
| 2017-11-09 10:52 | marcellus | Note Added: 0001814 | |
| 2017-11-09 13:03 | pengbo | Assigned To | => pengbo |
| 2017-11-09 13:03 | pengbo | Status | new => closed |
