[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