[pgpool-general: 6898] Re: pgpooladmin

Bo Peng pengbo at sraoss.co.jp
Wed Mar 4 12:32:42 JST 2020


Hello,

Did you installed "pgpool-II-pgxx-extensions" and 
created pgpool_recovery extension in template1?

$ yum install pgpool-II-pgxx-extensions
$ psql template1 -c "CREATE EXTENSION pgpool_recovery"

On Mon, 17 Feb 2020 21:51:55 +0200
Loai Abdallatif <loai.abdallatif at gmail.com> wrote:

> Dear Colleagues
> I have setup of two pg servers ( repmgr replication ) with additional
> server as pgpool .
> 
> the repmgr works seems fine between pgdb1 and pgdb2  as below:
> 
> [image: image.png]
> 
> from pgpool server using postgres user:
> the output as follow:
> 
> [image: image.png]
> 
> 
> the problem appears from pgpooladmin web interface when I tried to
> disconnect and stop only backend server fro example stop pgdb2 , i got
> error in pgdb2 logs as below
> 
> [image: image.png]
> 
> 
> any hint for such error ?


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan


More information about the pgpool-general mailing list