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

[Bo Peng]

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