public inbox for [email protected]  
help / color / mirror / Atom feed
From: vijay patil <[email protected]>
To: Kashif Zeeshan <[email protected]>
Cc: Muhammad Imtiaz <[email protected]>
Cc: Adrian Klaver <[email protected]>
Cc: [email protected]
Subject: Re: Pgpool with high availability
Date: Thu, 30 May 2024 09:36:39 +0530
Message-ID: <CAD5k+7yJZMwPkJeyKodxR3cg8PfF24Ys3qOYxbtfVMhJNw6XCg@mail.gmail.com> (raw)
In-Reply-To: <CAAPsdhfR-5r7cjP+yJGQV_s1mWvgeiJiEZ8ZwMu_VdmwHYU-TA@mail.gmail.com>
References: <CAD5k+7w8DdXLJYRzov5kXof6FanXe9Z=mHAKY_94LHbWHB8j4A@mail.gmail.com>
	<[email protected]>
	<CANwR1ORBQW7x0=yhNNvtOcQJfnvLZiyAeMO0zEMai1i_Utbj4Q@mail.gmail.com>
	<CAD5k+7w408n_cLdWX6j7tJQnZLWobTxuGOg7zadEZTFeAopkYA@mail.gmail.com>
	<CAAPsdhfR-5r7cjP+yJGQV_s1mWvgeiJiEZ8ZwMu_VdmwHYU-TA@mail.gmail.com>

HI Kashif,

The VIP 10.127.1.18 is accessible from the leader node (ha0002) only  but
not from the standby nodes (ha0001 and ha0003).

Thanks
Vijay

On Thu, May 30, 2024 at 9:17 AM Kashif Zeeshan <[email protected]>
wrote:

> 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 AM vijay patil <[email protected]>
> wrote:
>
>> Thanks Muhammad !
>>
>> Here i uploaded details.
>>
>> Thanks
>> Vijay
>>
>> On Wed, May 29, 2024 at 10:58 AM Muhammad Imtiaz <[email protected]>
>> 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 <[email protected]>
>>> 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
>>>> [email protected]
>>>>
>>>>
>>>>


reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Pgpool with high availability
  In-Reply-To: <CAD5k+7yJZMwPkJeyKodxR3cg8PfF24Ys3qOYxbtfVMhJNw6XCg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox