pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to bring Pgpool-II virtual IP up?
8+ messages / 5 participants
[nested] [flat]
* How to bring Pgpool-II virtual IP up?
@ 2023-05-05 11:03 ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 8+ messages in thread
From: ?????????? RMUTT CPE IX @ 2023-05-05 11:03 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
[https://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave_3.3/watchdog_master_slave.png]
Thank you very much.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
@ 2023-05-05 16:21 ` Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
0 siblings, 1 reply; 8+ messages in thread
From: Bruce Momjian @ 2023-05-05 16:21 UTC (permalink / raw)
To: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
@ 2023-05-06 03:56 ` Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 04:32 ` Re: How to bring Pgpool-II virtual IP up? Ron <ronljohnsonjr@gmail.com>
2023-05-06 05:54 ` Re: How to bring Pgpool-II virtual IP up? =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
0 siblings, 2 replies; 8+ messages in thread
From: Satyamnaidu Gokeda @ 2023-05-06 03:56 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>; pgsql-admin@lists.postgresql.org
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.
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
@ 2023-05-06 04:32 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Ron @ 2023-05-06 04:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
@ 2023-05-06 05:54 ` =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
2023-05-06 12:08 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 13:26 ` Re: How to bring Pgpool-II virtual IP up? Ron <ronljohnsonjr@gmail.com>
1 sibling, 2 replies; 8+ messages in thread
From: »ÅÒÇÒÌ·ÃÒ RMUTT CPE IX @ 2023-05-06 05:54 UTC (permalink / raw)
To: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Dear Satyam,
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 05:54 ` Re: How to bring Pgpool-II virtual IP up? =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
@ 2023-05-06 12:08 ` Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-07 06:03 ` Re: How to bring Pgpool-II virtual IP up? =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
1 sibling, 1 reply; 8+ messages in thread
From: Satyamnaidu Gokeda @ 2023-05-06 12:08 UTC (permalink / raw)
To: ปลาวาฬทราย RMUTT CPE IX <pws_admin@thaicpe.com>; +Cc: pgsql-admin@lists.postgresql.org
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)
> <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 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.
>
>
>
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 05:54 ` Re: How to bring Pgpool-II virtual IP up? =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
2023-05-06 12:08 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
@ 2023-05-07 06:03 ` =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
0 siblings, 0 replies; 8+ messages in thread
From: »ÅÒÇÒÌ·ÃÒ RMUTT CPE IX @ 2023-05-07 06:03 UTC (permalink / raw)
To: Satyamnaidu Gokeda <satyamnaidu215@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; pgpool-general@pgpool.net <pgpool-general@pgpool.net>
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<mailto:pws_admin@thaicpe.com>> wrote:
Dear Satyam,
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: How to bring Pgpool-II virtual IP up?
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Re: How to bring Pgpool-II virtual IP up? Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Re: How to bring Pgpool-II virtual IP up? Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 05:54 ` Re: How to bring Pgpool-II virtual IP up? =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
@ 2023-05-06 13:26 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 8+ messages in thread
From: Ron @ 2023-05-06 13:26 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
You should NEVER need to manually run 'ip address add133.137.177.143/24dev
eth0:0'.
On 5/6/23 00:54, ปลาวาฬทราย RMUTT CPE IX 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 add133.137.177.143/24dev 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 <http://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.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2023-05-07 06:03 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-05 11:03 How to bring Pgpool-II virtual IP up? ?????????? RMUTT CPE IX <pws_admin@thaicpe.com>
2023-05-05 16:21 ` Bruce Momjian <bruce@momjian.us>
2023-05-06 03:56 ` Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-06 04:32 ` Ron <ronljohnsonjr@gmail.com>
2023-05-06 05:54 ` =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
2023-05-06 12:08 ` Satyamnaidu Gokeda <satyamnaidu215@gmail.com>
2023-05-07 06:03 ` =?windows-874?B?u8XSx9LMt8PSwiBSTVVUVCBDUEUgSVg=?= <pws_admin@thaicpe.com>
2023-05-06 13:26 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox