|
|
> I have pgpool in version 4.1.2 and when node to lose ping or I disable network card and then when ping is back other nodes don't see node which been invisible. I noticed that on node not has proces from pgpool. > > This situation is normal or I have wrong configuration? Yes. It is the normal behaviour. If the network is disconnected, pgpool will detach the PostgreSQL node. Pgpool can not detect the detached node even if the network is restored. However, from Pgpool 4.1.0, you can use auto_failback to attach a healthy detached node. By default, this paramater is off. https://www.pgpool.net/docs/latest/en/html/runtime-config-failover.html#GUC-AUTO-FAILBACK |
|
|
I understand your answer but I have mean pgpool process. I will describe my problem. When on the one standby server is lost ping or is disable network card, i received status lost in pcp_watchdog_info and when ping is back I see lost status all time. I have to restart server or execute command "sudo pgpool" that status change on standby What i have to change that watchdog status change itself? Best regards |
|
|
Do you mean the watchdog status? Could you show the result of "pcp_watchdog_info" before and after disabling network card. |
|
|
after_ps.png (2,798 bytes) |
|
|
ofcourse picture before_status_watchdog_info.png - screen show status before disabling network card picture before_ps.png - screen show processes pgpool on node which will has disabling network card next I disabling network card picture after_status_Watchdog_info.png - screen show status after disabling network card next I enabling network card picture after_ps.png - screen show only one process other processes such as (pgpool: watchdog or pgpool: wait for conneciton request) is unappear after_status_Watchdog_info.png (3,719 bytes) before_ps.png (51,199 bytes) before_status_watchdog_info.png (3,552 bytes) |
|
|
After you disable the network card, pgpool on (postmetahive2) goes down because no pgpool processes exist. How did you start pgpool? Could you show the log after disabling network card? BTW, below is en example of setting pgpool with watchdog: https://www.pgpool.net/docs/latest/en/html/example-cluster.html |
|
|
I configurated my pgpool with examples from page site I do start pgpool by command "sudo systemctl start pgpool" In attachment pgpool log, posts in log is with situation disabling network card and enabling network card, additionally in attachement is status with systemctl status pgpool All work fine but I have still time problem with automatic start watchdog status_Service.png (29,683 bytes) log_pgpool.txt (16,312 bytes) |
|
|
I noticed that if I disable network card that pgpool service got status failed and service is down but when I blocked network traffic by firewall/iptables that pgpool service is active and when I returned network traffic, all works additional disabled server automatic connect to replication. This issue is closed too. Best regards |
|
|
> I noticed that if I disable network card that pgpool service got status failed and service is down but when I blocked network traffic by firewall/iptables that > pgpool service is active and when I returned network traffic, all works additional disabled server automatic connect to replication. The reason seems that when disabling network card, watchdog child process exits and doesn't restart. I am asking another developer who knows the implementation of watchdog very well, if it is correct behaviour. Anyway. I am going to close this issue. |
- Anonymous
