[pgpool-general: 6906] Re: pgpooladmin

[Loai Abdallatif]

Hi Peng

I have installedthe below package on pgpool server in addition to pgpool2
itself
then created the extension as you requested
postgresql-11-pgpool2_4.0.2-1_amd64.deb
------------------------------

On Wed, Mar 4, 2020 at 5:32 AM Bo Peng <pengbo at sraoss.co.jp> wrote:

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


-- 
Best Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200304/fa60952e/attachment.html>