[pgpool-general: 6924] Re: Backend Node Not registering with PgPool II
Nitish Kumar
itcell.mpwz at mp.gov.in
Mon Mar 9 18:05:11 JST 2020
Hi,
I ran following command on my active pgpool server
For first Backend
[pgpooladmin at ngbpgpool1 ~]$ pcp_node_info --username=pgpool_admin -W --verbose 0
Password:
Hostname : xxx.xx.xx.19
Port : 5432
Status : 2
Weight : 0.333333
Status Name : up
Role : primary
Replication Delay : 0
Replication State :
Replication Sync State :
Last Status Change : 2020-03-06 11:24:22
For second backend
[pgpooladmin at ngbpgpool1 ~]$ pcp_node_info --username=pgpool_admin -W --verbose 1
Password:
Hostname : xxx.xx.xx.20
Port : 5432
Status : 2
Weight : 0.333333
Status Name : up
Role : standby
Replication Delay : 0
Replication State :
Replication Sync State :
Last Status Change : 2020-03-06 11:24:22
For third backend
[pgpooladmin at ngbpgpool1 ~]$ pcp_node_info --username=pgpool_admin -W --verbose 2
Password:
Hostname : xxx.xx.xx.41
Port : 5432
Status : 0
Weight : 0.333333
Status Name : unused
Role : standby
Replication Delay : 0
Replication State :
Replication Sync State :
Last Status Change : 2020-03-06 11:24:22
----- Original Message -----
From: "Bo Peng" <pengbo at sraoss.co.jp>
To: "Nitish Kumar" <itcell.mpwz at mp.gov.in>
Cc: "PgPool General" <pgpool-general at pgpool.net>
Sent: Friday, March 6, 2020 9:49:52 AM
Subject: Re: [pgpool-general: 6918] Backend Node Not registering with PgPool II
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
More information about the pgpool-general
mailing list