<div dir="auto">Hi Bo,<div dir="auto">Thanks for update.</div><div dir="auto">We are using pg_terminate_backend(pid),but we observed failover was happened at pgpool level.</div><div dir="auto">Please suggest the process to terminate the processes.</div><div dir="auto">Regards, </div><div dir="auto">Postgann.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Feb 12, 2020, 11:00 AM Bo Peng <<a href="mailto:pengbo@sraoss.co.jp">pengbo@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
On Wed, 12 Feb 2020 10:37:00 +0900<br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank" rel="noreferrer">pengbo@sraoss.co.jp</a>> wrote:<br>
<br>
> On Mon, 10 Feb 2020 23:06:51 +0530<br>
> postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank" rel="noreferrer">postgann2020@gmail.com</a>> wrote:<br>
> <br>
> > Hi Team,<br>
> > <br>
> > We have 1 master and 2 slaves with pgpool configuration running in<br>
> > streaming replication mode.<br>
> > <br>
> > Sometimes we are getting situation of terminating postgres and pgpool<br>
> > process from the db and terminate , but while using pg_terminate_backend<br>
> > from progress which causing falover at pgpool level.and not sure how to<br>
> > close pgpool child process as well.<br>
> > <br>
> > Could you please suggest the recommended process to terminate postgres and<br>
> > pgpool process..<br>
<br>
<br>
Pgpool supports "select pg_terminate_backend(PID)".<br>
<br>
> > 1. How to terminate postgres process from database and terminate?.<br>
> > 2. How to terminate pgpool child process from pool and terminal?<br>
> <br>
> You need to terminate pgpool first before terminate postgres.<br>
> And also you need to start postgres before start pgpool.<br>
> <br>
> -- <br>
> Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank" rel="noreferrer">pengbo@sraoss.co.jp</a>><br>
> SRA OSS, Inc. Japan<br>
> _______________________________________________<br>
> pgpool-general mailing list<br>
> <a href="mailto:pgpool-general@pgpool.net" target="_blank" rel="noreferrer">pgpool-general@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank" rel="noreferrer">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
</blockquote></div>