[pgpool-general: 6920] Re: Backend Node Not registering with PgPool II

[Bo Peng]

Hello,

On Thu, 5 Mar 2020 17:44:35 +0530 (IST)
Nitish Kumar <itcell.mpwz at mp.gov.in> wrote:

> 
> Hi Team, 
> 
> I am using PgPool II 4.1.1 with 3 PostgreSQL 10.11 backend nodes. 
> 
> The issue I am facing is that only 2 nodes have been registered with PgPool II as shown in PgPoolAdmin UI. 
> 
> I am attaching the screenshot for the same. 

I think it is not the issue of pgpoolAdmin,
because I tried the latest pgpoolAdmin, it works well.

Could you show the result of "show pool_nodes"?

  # psql -U postgres postgres -p 9999 -c "show pool_nodes"

Please try to edit "/etc/sysconfig/pgpool" and restart pgpool.

-------------------------------
# vi /etc/sysconfig/pgpool 
(edit OPTS)
OPTS=" -D -n"

# systemctl restart pgpool
-------------------------------

> The configuration of all the 3 backend nodes are same and correct. I don't know why its happening as 
> PgPool II is not outputing any explicit logs. 
> 
> I am facing this issue since PgPool II 4.1.0 version. The earlier resolution provided from you guys 
> that I should upgrade to latest rpm of same version ( PgPool II 4.1.0 ). 
> The problem existed even after applying that resolution. 
> 
> I hope it will fixed in the next minor release i.e v4.1.1. But even after updating my both PgPool II instances to 
> v4.1.1 the problem exists. 
> 
> Kindly help me in fixing this issue. 
> 
> Regards, 
> Nitish 
> 
> 


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