[pgpool-general: 6909] Re: pgpooladmin

[Bo Peng]

Hello,

On Wed, 4 Mar 2020 21:50:30 +0200
Loai Abdallatif <loai.abdallatif at gmail.com> wrote:

> also when I stop the master node I got the below command line output

Did you create the .pcppass file under apache startup user's home directory?


For example:
-------------------
# cat /usr/share/httpd/.pcppass 
*:9898:postgres:postgres
-------------------

> [image: image.png]
> 
> whereis ON the we web pgpooladmin I got:
> 
> [image: image.png]
> 
> 
> 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,


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