Home > mailing lists

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

How to bring Pgpool-II virtual IP up?

From

?????????? RMUTT CPE IX

Date:

05 May 2023, 11:03:07

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

Thank you very much.

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

From

Bruce Momjian

Date:

05 May 2023, 16:21:01

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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

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

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

From

Satyamnaidu Gokeda

Date:

06 May 2023, 03:56:35

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 dev ens192

Thanks,

Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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

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

From

Ron

Date:

06 May 2023, 04:32:37

I didn't have to manually run the "ip" command. Just starting PgPool "magically" caused it to appear. (Presumably "ip address add" is baked into the code.)

On 5/5/23 22:56, Satyamnaidu Gokeda wrote:

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 dev ens192

Thanks,
Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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

--
Born in Arizona, moved to Babylonia.

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

From

ปลาวาฬทราย RMUTT CPE IX

Date:

06 May 2023, 05:54:49

Dear Satyam,

From this example Watchdog Configuration Example (pgpool.net)

Should I use 'ip address add 133.137.177.143/24 dev eth0:0' command on all Pgpool servers?

Thank you very much.

From: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
Sent: Saturday, May 6, 2023 10:56 AM
To: Bruce Momjian <bruce@momjian.us>
Cc: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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 dev ens192

Thanks,

Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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

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

From

Satyamnaidu Gokeda

Date:

06 May 2023, 12:08:08

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@thaicpe.com> wrote:

Dear Satyam,

From this example Watchdog Configuration Example (pgpool.net)
Should I use 'ip address add 133.137.177.143/24 dev eth0:0' command on all Pgpool servers?

Thank you very much.
From: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
Sent: Saturday, May 6, 2023 10:56 AM
To: Bruce Momjian <bruce@momjian.us>
Cc: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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 dev ens192

Thanks,
Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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

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

From

Ron

Date:

06 May 2023, 13:26:34

You should NEVER need to manually run 'ip address add 133.137.177.143/24 dev eth0:0'.

On 5/6/23 00:54, ปลาวาฬทราย RMUTT CPE IX wrote:

P {margin-top:0;margin-bottom:0;}
Dear Satyam,

From this example Watchdog Configuration Example (pgpool.net)
Should I use 'ip address add 133.137.177.143/24 dev eth0:0' command on all Pgpool servers?

Thank you very much.
From: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
Sent: Saturday, May 6, 2023 10:56 AM
To: Bruce Momjian <bruce@momjian.us>
Cc: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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 dev ens192

Thanks,
Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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

--
Born in Arizona, moved to Babylonia.

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

From

ปลาวาฬทราย RMUTT CPE IX

Date:

07 May 2023, 06:03:10

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@gmail.com>
Sent: Saturday, May 6, 2023 7:08 PM
To: ปลาวาฬทราย RMUTT CPE IX <pws_admin@thaicpe.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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@thaicpe.com> wrote:

Dear Satyam,

From this example Watchdog Configuration Example (pgpool.net)
Should I use 'ip address add 133.137.177.143/24 dev eth0:0' command on all Pgpool servers?

Thank you very much.
From: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
Sent: Saturday, May 6, 2023 10:56 AM
To: Bruce Momjian <bruce@momjian.us>
Cc: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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 dev ens192

Thanks,
Satyam N Gokeda.

On Fri, May 5, 2023, 21:51 Bruce Momjian <bruce@momjian.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@momjian.us> https://momjian.us
EDB https://enterprisedb.com

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