<div dir="auto">Ok. Figured out how to get node reattached as Master. <div dir="auto"><br></div><div dir="auto">Thanks.</div><div dir="auto"><br></div><div dir="auto">Eric</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Nov 9, 2017 10:08 AM, "Eric Powell" <<a href="mailto:epowell@3-gis.com">epowell@3-gis.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I am learning to use and deploy PGPOOL-II, and have run into a problem in my test environment:<div><br></div><div>Our test environment (Centos 7 and AWS) spins down every night, and for some unknown reason, when it spun up the other morning, the firewall on the Master database came up blocking traffic on port 5432. I have resolved that issue, have streaming replication back up and running, but this also caused PGPOOL to status the node as 'down' and place the the pool into standby:</div><div><br></div><div><div>postgres=# show pool_nodes;</div><div> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay</div><div>---------+-------------+------<wbr>+--------+-----------+--------<wbr>-+------------+---------------<wbr>----+-------------------</div><div> 0 | 172.17.5.9 | 5432 | down | 0.500000 | standby | 0 | false | 0</div><div> 1 | 172.17.5.10 | 5433 | up | 0.500000 | standby | 3 | true | 0</div><div>(2 rows)</div><div><br></div><div>How do I tell PGPOOL to bring Node 0 to status 'up' and pull the it out of out of standby mode?</div><div><br></div><div>IF it is in the docs, I apologize...lot's to digest....</div><div><br></div><div>Configuration:</div><div><br></div><div>Postgres 9.5 on Centos 7, PGPool 3.6.x on Centos.</div><div><br></div><div>I don't have watchdog and health-check configured, yet.</div><div><br></div><div>Any help would be appreciated.</div><div><br></div>-- <br><div class="m_2537184606472152009gmail_signature"><div dir="ltr"><div><div dir="ltr"><div style="font-size:12.8px"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="margin:0px"><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:10.5pt"><font color="#000000">Eric Powell, PG, GISP</font></span></strong></p><p style="margin:0px"><strong><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">| </span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">Senior Solutions Engineer</font></span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><font color="#000000"> </font></span></strong><strong style="font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">|</span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><span style="margin:0px;color:rgb(84,184,71)"> </span></span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">3-GIS</font></span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><font color="#000000"> </font></span></strong><strong style="font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">|</span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><span style="margin:0px;color:rgb(84,184,71)"> </span></span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">Mapping the Future</font></span></strong><strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><font color="#000000"></font></span></strong></p><p style="margin:0px"><strong style="font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">|</span></strong><strong><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt"> </span></strong><strong><span style="margin:0px;color:blue;font-family:Arial,sans-serif;font-size:9pt;font-weight:normal"><a href="tel:(256)%20560-0744" value="+12565600744" style="color:rgb(17,85,204)" target="_blank">256.560.0744</a> x 294 </span></strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">office</font></span><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><font color="#000000"> </font><strong style="font-family:arial,sans-serif;font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">|</span></strong><strong><span style="margin:0px;color:rgb(84,184,71)"> </span></strong></span><strong><span style="margin:0px;color:blue;font-family:Arial,sans-serif;font-size:9pt;font-weight:normal"><a href="tel:(256)%20560-0746" value="+12565600746" style="color:rgb(17,85,204)" target="_blank">256.560.0746</a></span></strong><strong><span style="margin:0px;color:blue;font-family:Arial,sans-serif;font-size:12pt"> </span></strong><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">fax</font></span><span style="margin:0px;font-family:Arial,sans-serif;font-size:12pt"><font color="#000000"> </font><strong style="font-family:arial,sans-serif;font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt"><wbr>|</span></strong><strong><span style="margin:0px;color:rgb(84,184,71)"> </span></strong></span><strong><span style="margin:0px;color:blue;font-family:Arial,sans-serif;font-size:9pt;font-weight:normal"><a href="tel:(803)%2640-3491" value="+12567144255" style="color:rgb(17,85,204)" target="_blank">803.640.3491</a></span></strong><span style="margin:0px;color:blue;font-family:Arial,sans-serif;font-size:9pt"> </span><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><font color="#000000">mobile </font><strong style="font-family:arial,sans-serif;font-size:12.8px"><span style="margin:0px;color:rgb(84,184,71);font-family:Arial,sans-serif;font-size:12pt">|</span></strong><strong><span style="margin:0px;color:rgb(63,174,41)"> </span></strong><span style="margin:0px;color:rgb(63,174,41)"><font color="#0000ff" style="color:rgb(17,85,204)"><a href="http://www.3-gis.com/" style="color:rgb(17,85,204)" target="_blank">www.3-<wbr>gis.com</a></font></span></span></p><p style="margin:0px"><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><span style="margin:0px;color:rgb(63,174,41)"><br></span></span></p><p style="margin:0px"><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><span style="margin:0px;color:rgb(63,174,41)">"Eschew Obfuscation"</span></span></p><div><span style="margin:0px;font-family:Arial,sans-serif;font-size:9pt"><span style="margin:0px;color:rgb(63,174,41)"><br></span></span></div></div></div></div></div></div></div></div></div></div>
</div></div>
</blockquote></div></div>
<br>
<font size="1" color="#999999" style="font-family:arial,sans-serif;background-color:rgb(255,255,255)"><span style="font-family:Helvetica">CONFIDENTIALITY NOTICE:</span><br style="font-family:Helvetica"><span style="font-family:Helvetica">The contents of this email message and any attachments are intended solely for the addressee(s) and may contain confidential and/or privileged information and may be legally protected from disclosure. If you are not the intended recipient of this message or their agent, or if this message has been addressed to you in error, please immediately alert the sender by reply email and then delete this message and any attachments. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying, or storage of this message or its attachments is strictly prohibited.</span></font><span style="background-color:rgb(255,255,255);font-family:Helvetica;font-size:13.3333px"> </span>