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

[Nitish Kumar]

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.

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
> 
> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181201/7756f16e/attachment.html>