[pgpool-general: 6928] Re: Backend Node Not registering with PgPool II
Bo Peng
pengbo at sraoss.co.jp
Tue Mar 10 17:12:28 JST 2020
Hello,
On Mon, 9 Mar 2020 14:35:11 +0530 (IST)
Nitish Kumar <itcell.mpwz at mp.gov.in> wrote:
> Hi,
>
> I ran following command on my active pgpool server
I think you added the node2(xxx.xx.xx.41) in pgpool.conf and restarted pgpool.
In this case, you need to discard previous node status restored in pgpool_status file
while starting pgpool.
To discard pgpool_status file, please edit "/etc/sysconfig/pgpool" and restart pgpool.
-------------------------------
# vi /etc/sysconfig/pgpool
(edit OPTS)
OPTS=" -D -n"
# systemctl restart pgpool
-------------------------------
> 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
>
>
--
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan
More information about the pgpool-general
mailing list