[pgpool-general: 6921] Re: pgpooladmin

[Bo Peng]

Hello,

Can you run "/usr/bin/pcp_stop_pgpool -w -h localhost -p 9898 -U postgres -m s" command
in command line using httpd startup user?


On Thu, 5 Mar 2020 11:19:59 +0200
Loai Abdallatif <loai.abdallatif at gmail.com> wrote:

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


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