[pgpool-general: 6911] Re: pgpooladmin

[Loai Abdallatif]

yes , I have it on /var/www/.pcppass  with permission  0600 for user
www-data and group www.-data

FYI, the installed packages related to PostgreSQL  on master and slave
servers are:

[image: image.png]

the installed packages related to PostgreSQL and pgpool on pgpool server
are:

[image: image.png]







On Thu, Mar 5, 2020 at 6:41 AM Bo Peng <pengbo at sraoss.co.jp> wrote:

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


-- 
Best Regards,
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200305/3c7bcef8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 4855 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200305/3c7bcef8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 4809 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200305/3c7bcef8/attachment-0003.png>