<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">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" 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>