<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:18px"><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">Hi,</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">I am little new to pgpool. I configured pgpool on the same server as the database PostgreSQL 9.2.</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">1) Master Node1(with pgpool)</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">2) slave node 2(with pgpool)</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">3) slave node3.(with pgpool): node3 is cascaded from node2.</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">I configured pgpool all the three node with correct settings. I tested the failover and pgpool successfully makes slave node2 as a master. So far so good. </div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">My issue starts after the failover. After the failover I believe the original master is degenerated. But I can't recover it and start the pgpool again the old master. The reason been is that </div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div style="margin-top: 0px; margin-bottom: 0px; font-size: 12px; font-family: 'Andale Mono'; color: rgb(41, 249, 20); background-color: rgb(0, 0, 0);" class="" id="yui_3_16_0_1_1413353898450_29233">other_pgpool_hostname0</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">is pointing to slave node 3. Some how pgpool refuses to start unless I change hostname0 to the new master i.e node2. I was assuming the pgpool should each of other_pgpool_hostname and decide if its slave or a master. Why does it mandates that hostname0 i.e hast to be master node.</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">Appreciate the help,</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">Thanks,</div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr"><br></div><div id="yui_3_16_0_1_1413353898450_29129" dir="ltr">Sajeev</div></div></body></html>