<html><head></head><body><div style="font-family:courier new, courier, monaco, monospace, sans-serif;font-size:16px;"><div></div>
<div><br></div><div>This is the pool status:</div><div><br></div><div><span><div><br></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>---------+--------------+------+--------+-----------+---------+------------+-------------------+-------------------</div><div> 0 | 172.28.33.10 | 5432 | up | 0.500000 | standby | 2 | false | 0</div><div> 1 | 172.28.33.11 | 5432 | up | 0.500000 | primary | 4 | true | 0</div><div>(2 rows)</div><div><br></div><div>postgres=# show pool_nodes;</div><div>server closed the connection unexpectedly</div><div> This probably means the server terminated abnormally</div><div> before or while processing the request.</div><div>The connection to the server was lost. Attempting reset: Succeeded.</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>---------+--------------+------+--------+-----------+---------+------------+-------------------+-------------------</div><div> 0 | 172.28.33.10 | 5432 | up | 0.500000 | standby | 2 | true | 0</div><div> 1 | 172.28.33.11 | 5432 | down | 0.500000 | standby | 4 | false | 0</div><div>(2 rows)</div><div><br></div><div>postgres=# </div></span><br></div><div><br></div><div><br></div><div><br></div>
<div id="yahoo_quoted_3893248718" class="yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Friday, April 6, 2018, 2:49:53 PM EDT, rachel Ajebon <rachel_ajebon@yahoo.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="yiv3600726430"><div><div style="font-family:courier new, courier, monaco, monospace, sans-serif;font-size:16px;"><div>I am new to pgpool, I have tried setting up 3 pgpool nodes and 3 backend Postgresql database</div><div>and 3 pgppool node and 2 backend Postgres database.</div><div><br></div><div>The issue with the above 2 settings are that I sometimes get this error when performing a failover "f<span>ailover: set new primary node: -1" and the failover does not occur and all databases becomes standby databases please what does the -1 stand for and what might I be doing wrong. Please let me know.</span></div><div><span><br></span></div><div><span><br></span></div><div><span><span><div>Apr 6 18:41:20 admin1 pgpool[7156]: [241-1] 2018-04-06 18:41:20: pid 7156: LOG: find_primary_node: checking backend no 0</div><div>Apr 6 18:41:20 admin1 pgpool[7156]: [242-1] 2018-04-06 18:41:20: pid 7156: LOG: find_primary_node: checking backend no 1</div><div>Apr 6 18:41:21 admin1 pgpool[7156]: [243-1] 2018-04-06 18:41:21: pid 7156: LOG: find_primary_node: checking backend no 0</div><div>Apr 6 18:41:21 admin1 pgpool[7156]: [244-1] 2018-04-06 18:41:21: pid 7156: LOG: find_primary_node: checking backend no 1</div><div>Apr 6 18:41:22 admin1 pgpool[7156]: [245-1] 2018-04-06 18:41:22: pid 7156: LOG: find_primary_node: checking backend no 0</div><div>Apr 6 18:41:22 admin1 pgpool[7156]: [246-1] 2018-04-06 18:41:22: pid 7156: LOG: find_primary_node: checking backend no 1</div><div>Apr 6 18:41:23 admin1 pgpool[7157]: [79-1] 2018-04-06 18:41:23: pid 7157: LOG: new IPC connection received</div><div>Apr 6 18:41:23 admin1 pgpool[7157]: [80-1] 2018-04-06 18:41:23: pid 7157: LOG: received the failover command lock request from local pgpool-II on IPC interface</div><div>Apr 6 18:41:23 admin1 pgpool[7157]: [81-1] 2018-04-06 18:41:23: pid 7157: LOG: failover command lock request from local pgpool-II node received on IPC interface is forwarded to master watchdog node "172.28.33.10:9998 Linux config"</div><div>Apr 6 18:41:23 admin1 pgpool[7157]: [81-2] 2018-04-06 18:41:23: pid 7157: DETAIL: waiting for the reply...</div><div>Apr 6 18:41:23 admin1 pgpool[7156]: [247-1] 2018-04-06 18:41:23: pid 7156: LOG: failover: set new primary node: -1</div><div>Apr 6 18:41:23 admin1 pgpool[7156]: [248-1] 2018-04-06 18:41:23: pid 7156: LOG: failover: set new master node: 0</div></span><br></span></div><div><span><br></span></div><div>the second question for the first setup which is 3 pgpool nodes and 3 postgres database, how do I make the second standby sync with the master database after failover? Please let me know.</div><div><br></div><div>Thanks so much for your help!</div></div></div></div></div>
</div>
</div></div></body></html>