MIME-Version: 1.0
References: <CAD5k+7w8DdXLJYRzov5kXof6FanXe9Z=mHAKY_94LHbWHB8j4A@mail.gmail.com>
 <22b7b0b8-c348-44df-a9a4-ceba94f379b2@aklaver.com> <CANwR1ORBQW7x0=yhNNvtOcQJfnvLZiyAeMO0zEMai1i_Utbj4Q@mail.gmail.com>
 <CAD5k+7w408n_cLdWX6j7tJQnZLWobTxuGOg7zadEZTFeAopkYA@mail.gmail.com>
In-Reply-To: <CAD5k+7w408n_cLdWX6j7tJQnZLWobTxuGOg7zadEZTFeAopkYA@mail.gmail.com>
From: Kashif Zeeshan <kashi.zeeshan@gmail.com>
Date: Thu, 30 May 2024 08:47:11 +0500
Message-ID: <CAAPsdhfR-5r7cjP+yJGQV_s1mWvgeiJiEZ8ZwMu_VdmwHYU-TA@mail.gmail.com>
Subject: Re: Pgpool with high availability
To: vijay patil <vijay.postgres@gmail.com>
Cc: Muhammad Imtiaz <imtiaz.m@bitnine.net>, Adrian Klaver <adrian.klaver@aklaver.com>, 
	pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000093b29e0619a3b961"
Archived-At: <https://www.postgresql.org/message-id/CAAPsdhfR-5r7cjP%2ByJGQV_s1mWvgeiJiEZ8ZwMu_VdmwHYU-TA%40mail.gmail.com>
Precedence: bulk

--00000000000093b29e0619a3b961
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Vijay

The log shows that all the nodes are able to communicate now (master,
standby and standby1) and now what are the issue you are facing?

Regards
Kashif Zeeshan

On Thu, May 30, 2024 at 2:00=E2=80=AFAM vijay patil <vijay.postgres@gmail.c=
om>
wrote:

> Thanks Muhammad !
>
> Here i uploaded details.
>
> Thanks
> Vijay
>
> On Wed, May 29, 2024 at 10:58=E2=80=AFAM Muhammad Imtiaz <imtiaz.m@bitnin=
e.net>
> wrote:
>
>> Hi,
>>
>> Can you please provide the Pgpool logs? Additionally, in a distributed
>> environment, ensure that Pgpool is properly configured. You can follow
>> these documented steps to set up the Pgpool configurations
>> pgpool.conf,pcp.conf and pool_hba.conf .
>>
>> Regards,
>> Muhammad Imtiaz
>>
>> On Tue, 28 May 2024 at 23:01, Adrian Klaver <adrian.klaver@aklaver.com>
>> wrote:
>>
>>>
>>>
>>> On 5/28/24 1:31 AM, vijay patil wrote:
>>> >
>>> > HI Team,
>>> >
>>> > "I'm encountering challenges while configuring Pgpool with high
>>> > availability. The initial setup is completed, and Pgpool is
>>> operational
>>> > on a single node, functioning without issues. However, upon attemptin=
g
>>> > to start Pgpool on any additional nodes, particularly node 2, it
>>> becomes
>>> > immediately unreachable.
>>>
>>> And how we are supposed to arrive at an answer with essentially no
>>> information provided?
>>>
>>> Need:
>>>
>>> 1) Configuration for initial setup.
>>>
>>> 2) A more detailed explanation of what "... upon attempting
>>> to start Pgpool on any additional nodes" means? Include configuration
>>> changes.
>>>
>>> 3) The error messages.
>>>
>>> 4) Where the nodes are located?
>>>
>>>
>>> >
>>> > I'm seeking assistance to address this issue. My setup consists of
>>> three
>>> > nodes, each hosting both PostgreSQL and Pgpool services."
>>> >
>>> >
>>> > Thanks
>>> >
>>> > Vijay
>>> >
>>>
>>> --
>>> Adrian Klaver
>>> adrian.klaver@aklaver.com
>>>
>>>
>>>

--00000000000093b29e0619a3b961
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi=C2=A0Vijay<div><br></div><div>The log shows that all th=
e nodes are able to communicate now (master, standby and standby1) and now =
what are the issue you=C2=A0are facing?</div><div><br></div><div>Regards</d=
iv><div>Kashif Zeeshan</div></div><br><div class=3D"gmail_quote"><div dir=
=3D"ltr" class=3D"gmail_attr">On Thu, May 30, 2024 at 2:00=E2=80=AFAM vijay=
 patil &lt;<a href=3D"mailto:vijay.postgres@gmail.com">vijay.postgres@gmail=
.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div dir=3D"ltr">Thanks Muhammad !<div><br></div><div>Here i uploaded d=
etails.</div><div><br></div><div>Thanks</div><div>Vijay</div></div><br><div=
 class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, May 29=
, 2024 at 10:58=E2=80=AFAM Muhammad Imtiaz &lt;<a href=3D"mailto:imtiaz.m@b=
itnine.net" target=3D"_blank">imtiaz.m@bitnine.net</a>&gt; wrote:<br></div>=
<blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-=
left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr">Hi,<br><=
br>

Can you please provide the Pgpool logs? Additionally, in a distributed envi=
ronment, ensure that Pgpool is properly configured. You can follow these do=
cumented steps to set up the Pgpool configurations=20

pgpool.conf,pcp.conf and=20

pool_hba.conf

.

<br><br>Regards,<br>Muhammad Imtiaz</div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Tue, 28 May 2024 at 23:01, Adrian Kla=
ver &lt;<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adri=
an.klaver@aklaver.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex"><br>
<br>
On 5/28/24 1:31 AM, vijay patil wrote:<br>
&gt; <br>
&gt; HI Team,<br>
&gt; <br>
&gt; &quot;I&#39;m encountering challenges while configuring Pgpool with hi=
gh <br>
&gt; availability. The initial setup is completed, and Pgpool is operationa=
l <br>
&gt; on a single node, functioning without issues. However, upon attempting=
 <br>
&gt; to start Pgpool on any additional nodes, particularly node 2, it becom=
es <br>
&gt; immediately unreachable.<br>
<br>
And how we are supposed to arrive at an answer with essentially no <br>
information provided?<br>
<br>
Need:<br>
<br>
1) Configuration for initial setup.<br>
<br>
2) A more detailed explanation of what &quot;... upon attempting<br>
to start Pgpool on any additional nodes&quot; means? Include configuration =
<br>
changes.<br>
<br>
3) The error messages.<br>
<br>
4) Where the nodes are located?<br>
<br>
<br>
&gt; <br>
&gt; I&#39;m seeking assistance to address this issue. My setup consists of=
 three <br>
&gt; nodes, each hosting both PostgreSQL and Pgpool services.&quot;<br>
&gt; <br>
&gt; <br>
&gt; Thanks<br>
&gt; <br>
&gt; Vijay<br>
&gt; <br>
<br>
-- <br>
Adrian Klaver<br>
<a href=3D"mailto:adrian.klaver@aklaver.com" target=3D"_blank">adrian.klave=
r@aklaver.com</a><br>
<br>
<br>
</blockquote></div>
</blockquote></div>
</blockquote></div>

--00000000000093b29e0619a3b961--