[pgpool-general: 6869] Re: Recommended process to terminate postgres and pgpool processes

postgann2020 s postgann2020 at gmail.com
Wed Feb 12 18:00:25 JST 2020


Hi Bo,
Thanks for update.
We are using pg_terminate_backend(pid),but we observed failover was
happened at pgpool level.
Please suggest the process to terminate the processes.
Regards,
Postgann.

On Wed, Feb 12, 2020, 11:00 AM Bo Peng <pengbo at sraoss.co.jp> wrote:

> Hi,
>
> On Wed, 12 Feb 2020 10:37:00 +0900
> Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> > On Mon, 10 Feb 2020 23:06:51 +0530
> > postgann2020 s <postgann2020 at gmail.com> wrote:
> >
> > > Hi Team,
> > >
> > > We have 1 master and 2 slaves with pgpool configuration  running in
> > > streaming replication mode.
> > >
> > > Sometimes we are getting situation of terminating postgres and pgpool
> > > process from the db and terminate  , but while using
> pg_terminate_backend
> > > from progress which causing falover at pgpool level.and not sure how to
> > > close pgpool child process as well.
> > >
> > > Could you please suggest the recommended process to terminate postgres
> and
> > > pgpool process..
>
>
> Pgpool supports "select pg_terminate_backend(PID)".
>
> > > 1. How to terminate postgres process from database and terminate?.
> > > 2. How to terminate pgpool child process from pool and terminal?
> >
> > You need to terminate pgpool first before terminate postgres.
> > And also you need to start postgres before start pgpool.
> >
> > --
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS, Inc. Japan
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS, Inc. Japan
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200212/a822abe4/attachment.html>


More information about the pgpool-general mailing list