Обсуждение: How to bring Pgpool-II virtual IP up?

Поиск
Список
Период
Сортировка

How to bring Pgpool-II virtual IP up?

От
?????????? RMUTT CPE IX
Дата:
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?

От
Bruce Momjian
Дата:
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?

От
Satyamnaidu Gokeda
Дата:
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?

От
Ron
Дата:
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?

От
ปลาวาฬทราย RMUTT CPE IX
Дата:
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?

От
Satyamnaidu Gokeda
Дата:
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,

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?

От
Ron
Дата:
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?

От
ปลาวาฬทราย RMUTT CPE IX
Дата:
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,

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.