<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<div>Hi everybody</div>
<div><br>
</div>
<div>I've deployed a cluster with 3 nodes, 1 Master and 2 standby in cascade streaming replication. Like this Master->Standby->Standby </div>
<div><br>
</div>
<div>I want configure pgpool in watchdog to a virtual IP and repmgr for failover manager. I've disabled the load balancing, health check, only configured the parameter for MASTER/SLAVE mode in the streaming replication.</div>
<div><br>
</div>
<div>When I start the pgpool wd and review nodes of the cluster, I see this:</div>
<div><br>
</div>
<div>
<div>postgres=# SHOW pool_nodes;</div>
<div> node_id | hostname | port | status | lb_weight | role </div>
<div>---------+----------+------+--------+-----------+---------</div>
<div> 0 | nodoa | 5432 | 2 | 0.333333 | standby</div>
<div> 1 | nodob | 5432 | 2 | 0.333333 | standby</div>
<div> 2 | nodoc | 5432 | 2 | 0.333333 | standby</div>
<div>(3 rows)</div>
<div><br>
</div>
</div>
<div><br>
</div>
<div>My Master node is nodoa, but pgpool recognized the node like standby. Why the pgpool not recognize the primary node? I worry that in the failover, pgpool send the sql to a slave node and not send it to new master node.</div>
<div><br>
</div>
<div>Best Regards! </div>
<div>Drako Rod</div>
</div>
</body>
</html>