[pgpool-general: 6323] Re: Watchdog in Heartbeat mode !

[Bo Peng]

Hi,

On Sat, 01 Dec 2018 12:54:52 +0530
Nitish Kumar <itcell.mpwz at mp.gov.in> wrote:

> Yes, for monitoring PgPool II, I am using pgAdmin webapp. 
> 
> I just use it to login and view node status, check watchdog status and perform return of nodes when they get detached from 
> PgPool.

If so, you have to change pgpoolAdmin login user 
and the user configured in .pcppass.

> Regards,
> Nitish
> 
> On 12/01/18 08:43 AM, Bo Peng  <pengbo at sraoss.co.jp> wrote: 
> > 
> > Hi,
> > 
> > On Fri, 30 Nov 2018 01:12:30 +0530
> > Nitish Kumar <itcell.mpwz at mp.gov.in> wrote:
> > 
> > > Hi All,
> > > 
> > > I have PgPool II setup with watchdog mode enabled and wd_lifecheck_method set to as heartbeat. 
> > > 
> > > 
> > > Still when I am seeing my PostgreSQL Backend's logs I am receiving connection request from PgPool II severs 
> > > for template1 db ! 
> > > 
> > > 
> > > Here is the log output : 
> > > 
> > > 
> > > 
> > > 2018-11-29 21:14:40.234 IST [9051] ngb at template1/172.18.0.151(36476) FATAL: no pg_hba.conf entry for host "172.18.0.151", user "ngb", database "template1", SSL off
> > > 2018-11-29 21:14:40.250 IST [9052] ngb at template1/172.18.0.151(36484) FATAL: no pg_hba.conf entry for host "172.18.0.151", user "ngb", database "template1", SSL off
> > > 2018-11-29 21:14:40.522 IST [9057] ngb at template1/172.18.0.151(36512) FATAL: no pg_hba.conf entry for host "172.18.0.151", user "ngb", database "template1", SSL off
> > > 2018-11-29 21:14:40.539 IST [9058] ngb at template1/172.18.0.151(36520) FATAL: no pg_hba.conf entry for host "172.18.0.151", user "ngb", database "template1", SSL off
> > > 
> > > Earlier I was using ngb user for sr_check and health_check. But now I have created dedicated users for health_check and sr_check
> > > and have updated pgpool.conf file also and have restarted the services.
> > > 
> > > But still I am getting the above error in PostgreSQL's log files. There is no place in pgpool.conf file where I have provided user as ngb
> > > and db as 'template1' to connect.
> > > 
> > > The only place I could find template1 is in wd_lifecheck_dbname. 
> > > 
> > > I am not able to find out why this is happening. Kindly help team.
> > 
> > Did you run PCP commands, or use any application to connect pgpool such as pgpoolAdmin?
> > 
> >  
> > > Regards,
> > > Nitish Kumar
> > 
> > 
> > -- 
> > Bo Peng <pengbo at sraoss.co.jp>
> > SRA OSS, Inc. Japan
> > 
> > 


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