<div dir="ltr"><div>Below is the status.</div><div><br></div><div>ubuntu@pgp1:/etc/pgpool2$ psql -U postgres -h localhost -p 9999 --pset pager=off -c "show pool_nodes"</div> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change <br>---------+----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------<br> 0 | pg1 | 5432 | down | 0.500000 | standby | 0 | false | 0 | 2020-08-18 10:36:42<br> 1 | pg2 | 5432 | up | 0.500000 | standby | 0 | true | 0 | 2020-08-18 10:36:42<br>(2 rows)<br><br>ubuntu@pgp1:/etc/pgpool2$ psql -U postgres -h pg1 -p 5432 -x -c "select pg_is_in_recovery();"<br>Password for user postgres: <br>-[ RECORD 1 ]-----+--<br>pg_is_in_recovery | f<br><br>ubuntu@pgp1:/etc/pgpool2$ psql -U postgres -h pg2 -p 5432 -x -c "select pg_is_in_recovery();"<br>Password for user postgres: <br>-[ RECORD 1 ]-----+--<br><div>pg_is_in_recovery | t</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Aug 18, 2020 at 3:46 PM Praveen Kumar K S <<a href="mailto:praveenssit@gmail.com">praveenssit@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div>Hello,</div><div><br></div><div>I'm facing same issue and would like to know <br></div><div>1. If failover script fails, how pgpool consider that situation.</div><div>2. My failover script has failed when failover triggered. Postgres primary and slave is working fine. But pgpool continues to show both as standby and primary as down. I tried restarting all the services. How can I reset pgpool to detect postgres status ?<br></div><div> <br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Aug 10, 2020 at 1:49 PM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">> Thanks for your reply and your time ,<br>
> <br>
> <br>
> <br>
> I checked it out , the script in create filename "trigger", and it is ok rather than "trigger_file"<br>
> <br>
> and as you can see recovery.conf postgress is looking for "trigger"<br>
> <br>
> as well in the logs logs I did see message like "found trigger file moving from hotstandby to master"<br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Here is the recovery.conf file<br>
> <br>
> root@XXX XXX]# cat recovery.conf<br>
> <br>
> standby_mode = 'on'<br>
> <br>
> primary_conninfo = 'host=mgrdb120-hb port=5432 user=XXXX password=XXXX'<br>
> <br>
> #restore_command = 'scp mgrdb120-hb:/home/postgres/archive/%f %p'<br>
> <br>
> trigger_file = '/home/postgres/databases/fabrix/trigger'<br>
> <br>
> archive_cleanup_command = 'ssh mgrdb120-hb /home/postgres/pg_utils/archive_cleanup.sh %r'<br>
> <br>
> recovery_target_timeline = 'latest'<br>
> <br>
> [root@mgrdb119 fabrix]#<br>
> <br>
> <br>
> <br>
> So now my question is still relevant why pgpool doesn't recognize the postgress as primary<br>
<br>
Pgpool says:<br>
2020-07-20 09:24:15: pid 4076: LOG: failover: set new primary node: -1<br>
2020-07-20 09:24:15: pid 4076: LOG: failover: set new master node: 1<br>
<br>
When was the PostgreSQL promoted? My wild guess is, the promotion took<br>
too long time and pgpool missed it.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr"><font style="font-family:courier new,monospace" size="1"><b style="color:rgb(102,102,102)">Regards,<br><br></b></font><div style="color:rgb(102,102,102)"><font size="1"><b><font face="'comic sans ms', sans-serif"><font style="font-family:courier new,monospace" size="1">K S Praveen Kumar<br>M: +91-9986855625 </font><br></font></b></font></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><font style="font-family:courier new,monospace" size="1"><b style="color:rgb(102,102,102)">Regards,<br><br></b></font><div style="color:rgb(102,102,102)"><font size="1"><b><font face="'comic sans ms', sans-serif"><font style="font-family:courier new,monospace" size="1">K S Praveen Kumar<br>M: +91-9986855625 </font><br></font></b></font></div></div>