MIME-Version: 1.0
References: <CAD5k+7w8DdXLJYRzov5kXof6FanXe9Z=mHAKY_94LHbWHB8j4A@mail.gmail.com>
 <22b7b0b8-c348-44df-a9a4-ceba94f379b2@aklaver.com>
In-Reply-To: <22b7b0b8-c348-44df-a9a4-ceba94f379b2@aklaver.com>
From: Muhammad Imtiaz <imtiaz.m@bitnine.net>
Date: Wed, 29 May 2024 10:28:18 +0500
Message-ID: <CANwR1ORBQW7x0=yhNNvtOcQJfnvLZiyAeMO0zEMai1i_Utbj4Q@mail.gmail.com>
Subject: Re: Pgpool with high availability
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: vijay patil <vijay.postgres@gmail.com>, pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="00000000000046af600619910556"
Archived-At: <https://www.postgresql.org/message-id/CANwR1ORBQW7x0%3DyhNNvtOcQJfnvLZiyAeMO0zEMai1i_Utbj4Q%40mail.gmail.com>
Precedence: bulk

--00000000000046af600619910556
Content-Type: text/plain; charset="UTF-8"

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 attempting
> > 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
>
>
>

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

<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">adrian.klaver@aklaver.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1e=
x"><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>

--00000000000046af600619910556--