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

Bo Peng pengbo at sraoss.co.jp
Wed Feb 12 10:37:00 JST 2020

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

More information about the pgpool-general mailing list