Re: How to bring Pgpool-II virtual IP up?

Dear Satyam,

Okay, 'ip address add 192.168.0.10/24 dev eth0:0' for the VIP 192.168.0.10.
However, I have a little confused. If I add to all Pgpool machines, will the IP be duplicate between all of them?

Thank you very much.
________________________________
From: Satyamnaidu Gokeda <satyamnaidu215(at)gmail(dot)com>
Sent: Saturday, May 6, 2023 7:08 PM
To: ปลาวาฬทราย RMUTT CPE IX <pws_admin(at)thaicpe(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to bring Pgpool-II virtual IP up?

Please provide private IP ..start services if need help join my call.

Thanks & Regards,
Satyam N gokeda.
P: 9742450237

On Sat, May 6, 2023, 11:25 ปลาวาฬทราย RMUTT CPE IX <pws_admin(at)thaicpe(dot)com<mailto:pws_admin(at)thaicpe(dot)com>> wrote:
Dear Satyam,

From this example Watchdog Configuration Example (pgpool.net)<https://www.pgpool.net/docs/41/en/html/example-watchdog.html#EXAMPLE-WATCHDOG-VIP-SWITCH>
Should I use 'ip address add 133.137.177.143/24<http://133.137.177.143/24> dev eth0:0' command on all Pgpool servers?

Thank you very much.
________________________________
From: Satyamnaidu Gokeda <satyamnaidu215(at)gmail(dot)com<mailto:satyamnaidu215(at)gmail(dot)com>>
Sent: Saturday, May 6, 2023 10:56 AM
To: Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>>
Cc: ?????????? RMUTT CPE IX <pws_admin(at)thaicpe(dot)com<mailto:pws_admin(at)thaicpe(dot)com>>; pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org> <pgsql-admin(at)lists(dot)postgresql(dot)org<mailto:pgsql-admin(at)lists(dot)postgresql(dot)org>>
Subject: Re: How to bring Pgpool-II virtual IP up?

Hi Team,

Once you modify delegate_virtual IP in pgpool.conf you need to assign your VIP to your server using unit command
ip address add 192.168.0.10/24<http://192.168.0.10/24> dev ens192

Thanks,
Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>> wrote:
On Fri, May 5, 2023 at 11:03:07AM +0000, ?????????? RMUTT CPE IX wrote:
> Hi,
>
> I finished setting up the Pgpool, but I don't see the virtual IP from
> 'ifconfig' command. How should I do?
>
> https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/
> watchdog_master_slave.png
> [watchdog_m]

The pgpool email lists are the right place to ask this question:

https://www.pgpool.net/mediawiki/index.php/Mailing_lists

--
Bruce Momjian <bruce(at)momjian(dot)us<mailto:bruce(at)momjian(dot)us>> https://momjian.us
EDB https://enterprisedb.com

Embrace your flaws. They make you human, rather than perfect,
which you will never be.