View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000247 | Pgpool-II | General | public | 2016-09-16 15:57 | 2016-09-21 16:35 |
| Reporter | ravinx | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.5.0 | ||||
| Summary | 0000247: Automatic recovery of the failed node without any manual intervention. | ||||
| Description | I had configured the pgpool cluster with two pgpool nodes and two database nodes. The failover is working, but for recovering the failed node I have to run the "pcp_recovery_node" command manually on the active pgpool node. I want automation of the online recovery without running any manual command. I have used "repmgr" for replication control between the two database nodes. How can I get the replication done without repmgr, and also want to know the pros and cons of doing without repmgr. As of now my setup consist of pgpool with master-slave mode. And the streaming replication is used. | ||||
| Additional Information | The setup consist of 3 nodes and verison of Application and OS is as mentioned below: OS version => CentOS 6.8 (On all the 3 nodes) Please find the setup details: Pgpool node => 192.168.0.4 Postgresql Nodes: node1 (Master in read-write mode) => 192.168.0.6 node2 (Standby node in read only mode) => 192.168.0.7 Pgpool II version => pgpool-II version 3.5.0 (ekieboshi). Postgresql Version => PostgreSQL 9.4.8 Repmgr Version => repmgr 3.1.3 (PostgreSQL 9.4.8) I have configured the Pgpool in Master-Slave mode using Streaming replication. Please let me know if any additional information required. | ||||
| Tags | master slave, pcp commands, streaming replication | ||||
|
|
|
|
|
When the standby node is shutdown, the pgpool child processes are restarted during failover as I can see in the pgpool log file. This will disconnect the client connection and they need to make new connection. Please corrrect me if I am wrong. Why the pgpool child processes are restarted when the standby node has failed? Please find the pgpool log filein the attachment. |
|
|
This is a forum for bug reporting. If you have questions, please use mailing list. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-09-16 15:57 | ravinx | New Issue | |
| 2016-09-16 15:57 | ravinx | Tag Attached: master slave | |
| 2016-09-16 15:57 | ravinx | Tag Attached: pcp commands | |
| 2016-09-16 15:57 | ravinx | Tag Attached: streaming replication | |
| 2016-09-16 19:46 | ravinx | File Added: pgpool-II-94.log | |
| 2016-09-16 19:49 | ravinx | Note Added: 0001070 | |
| 2016-09-21 16:35 | t-ishii | Note Added: 0001077 | |
| 2016-09-21 16:35 | t-ishii | Status | new => closed |
