<div dir="ltr"><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">Hello everyone,
<br></span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">I have 2 streaming replication servers on which I've installed pgpool-II. Postgresql in running on port 5433 and pgpool on port 5432.</span></div><div><pre class="gmail-tw-data-text gmail-tw-ta gmail-tw-text-small" id="gmail-tw-target-text" dir="ltr" style="unicode-bidi:isolate;border:none;padding:0px 0.14em 0px 0px;margin-top:0px;margin-bottom:0px;font-family:inherit;overflow:hidden;width:276px;white-space:pre-wrap;word-wrap:break-word;color:rgb(33,33,33);height:72px;font-size:16px;line-height:24px"><span lang="en">Servers are connected by a cross cable to the eno2 interface, but eno1 is a public interface.</span></pre></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">
The configuration is as follows:
<br></span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">Server1:
eno1: x.y.z.11
eno2: 192.168.0.11
Server2:
eno1: </span><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.</span><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">12
eno2: 192.168.0.12
Virtual IP: </span><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.</span><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">10</span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap"><br></span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">(x.y.z. is just for example)
<br></span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">I'm sending my pgpool.conf in attachment.</span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap"><br></span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">pgpool does not start and in pgpool.log I can see the following output:</span></div><div><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap"><br></span></div><div><font color="#212121"><span style="font-size:16px;white-space:pre-wrap">2017-09-22 17:44:02: pid 3512: LOG: waiting for watchdog to initialize
2017-09-22 17:44:02: pid 3513: LOG: setting the local watchdog node name to "x.y.z.12:5432 Linux produzione2"
2017-09-22 17:44:02: pid 3513: LOG: watchdog cluster is configured with 1 remote nodes
2017-09-22 17:44:02: pid 3513: LOG: watchdog remote node:0 on x.y.z.11:9000
2017-09-22 17:44:02: pid 3513: LOG: interface monitoring is disabled in watchdog
2017-09-22 17:44:02: pid 3513: LOG: watchdog node state changed from [DEAD] to [LOADING]
2017-09-22 17:44:07: pid 3513: LOG: watchdog node state changed from [LOADING] to [JOINING]
2017-09-22 17:44:11: pid 3513: LOG: watchdog node state changed from [JOINING] to [INITIALIZING]
2017-09-22 17:44:12: pid 3513: LOG: I am the only alive node in the watchdog cluster
2017-09-22 17:44:12: pid 3513: HINT: skiping stand for coordinator state
2017-09-22 17:44:12: pid 3513: LOG: watchdog node state changed from [INITIALIZING] to [MASTER]
2017-09-22 17:44:12: pid 3513: LOG: I am announcing my self as master/coordinator watchdog node
2017-09-22 17:44:16: pid 3513: LOG: I am the cluster leader node
2017-09-22 17:44:16: pid 3513: DETAIL: our declare coordinator message is accepted by all nodes
2017-09-22 17:44:16: pid 3513: LOG: setting the local node "x.y.z.12:5432 Linux produzione2" as watchdog cluster master
2017-09-22 17:44:16: pid 3513: LOG: I am the cluster leader node. Starting escalation process
2017-09-22 17:44:16: pid 3512: LOG: watchdog process is initialized
2017-09-22 17:44:16: pid 3513: LOG: escalation process started with PID:3522
2017-09-22 17:44:16: pid 3513: LOG: new IPC connection received
2017-09-22 17:44:16: pid 3522: LOG: watchdog: escalation started
2017-09-22 17:44:16: pid 3513: LOG: new IPC connection received
2017-09-22 17:44:16: pid 3523: LOG: 2 watchdog nodes are configured for lifecheck
2017-09-22 17:44:16: pid 3523: LOG: watchdog nodes ID:0 Name:"</span></font><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.12</span><font color="#212121"><span style="font-size:16px;white-space:pre-wrap">:5432 Linux produzione2"
2017-09-22 17:44:16: pid 3523: DETAIL: Host:"</span></font><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.12</span><font color="#212121"><span style="font-size:16px;white-space:pre-wrap">" WD Port:9000 pgpool-II port:5432
2017-09-22 17:44:16: pid 3523: LOG: watchdog nodes ID:1 Name:"Not_Set"
2017-09-22 17:44:16: pid 3523: DETAIL: Host:"</span></font><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.11</span><span style="font-size:16px;white-space:pre-wrap"><font color="#212121">" WD Port:9000 pgpool-II port:5432
2017-09-22 17:44:16: pid 3523: LOG: watchdog lifecheck trusted server "8.8.8.8" added for the availability check
2017-09-22 17:44:16: pid 3523: LOG: watchdog lifecheck trusted server "8.8.4.4" added for the availability check
</font><font color="#ff0000"><b style="background-color:rgb(255,255,0)">2017-09-22 17:44:16: pid 3512: FATAL: failed to create INET domain socket
2017-09-22 17:44:16: pid 3512: DETAIL: getaddrinfo() failed: Name or service not known</b></font><font color="#212121">
2017-09-22 17:44:16: pid 3513: LOG: Watchdog is shutting down
2017-09-22 17:44:16: pid 3513: LOG: waiting for escalation process to exit before starting de-escalation
2017-09-22 17:44:17: pid 3513: LOG: waiting for escalation process to exit before starting de-escalation
2017-09-22 17:44:18: pid 3513: LOG: waiting for escalation process to exit before starting de-escalation
2017-09-22 17:44:19: pid 3513: LOG: waiting for escalation process to exit before starting de-escalation
2017-09-22 17:44:20: pid 3513: LOG: waiting for escalation process to exit before starting de-escalation
2017-09-22 17:44:20: pid 3522: LOG: successfully acquired the delegate IP:"</font></span><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.10</span><font color="#212121"><span style="font-size:16px;white-space:pre-wrap">"
2017-09-22 17:44:20: pid 3522: DETAIL: 'if_up_cmd' returned with success
2017-09-22 17:44:20: pid 3513: LOG: escalation process does not exited in time
2017-09-22 17:44:20: pid 3513: DETAIL: starting the de-escalation anyway
2017-09-22 17:44:20: pid 3529: LOG: watchdog: de-escalation started
2017-09-22 17:44:20: pid 3529: LOG: successfully released the delegate IP:"</span></font><span style="color:rgb(33,33,33);font-size:16px;white-space:pre-wrap">x.y.z.10</span><font color="#212121"><span style="font-size:16px;white-space:pre-wrap">"
2017-09-22 17:44:20: pid 3529: DETAIL: 'if_down_cmd' returned with success</span></font>
<br></div><div><br></div><div>Can you help me???</div></div>