Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pv9bG-00010D-Kd for pgsql-admin@arkaria.postgresql.org; Sat, 06 May 2023 04:32:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pv9bE-0003d8-3S for pgsql-admin@arkaria.postgresql.org; Sat, 06 May 2023 04:32:48 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pv9bD-0003cz-Gd for pgsql-admin@lists.postgresql.org; Sat, 06 May 2023 04:32:47 +0000 Received: from mail-yw1-x112b.google.com ([2607:f8b0:4864:20::112b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pv9b6-000nO6-9u for pgsql-admin@lists.postgresql.org; Sat, 06 May 2023 04:32:46 +0000 Received: by mail-yw1-x112b.google.com with SMTP id 00721157ae682-559e53d1195so37166567b3.2 for ; Fri, 05 May 2023 21:32:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683347559; x=1685939559; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=gZ5Qgch1oA3N3ckX0smj3S1JlF/Tr1KiTuWeHk0cGFw=; b=XyPrk+hCf1SmbFRzVHbNZHhPEPlvXMgkLIqqMdZhyyP8aE2QiVCAEkBHzNx+Y4hv+E W820PgC8kXoarUZ7Ubx0SmzAPvKcwecqhnmENFNvz2KdfSREgBifKxFyeWWdX+BezfwS ECsGczz19JYmn3eRydc376SkLU5m32xjQ7OIXpxIHNIkNVnpujbE5BsrekOWOJgiIzoN NvxHfQehXhJJzpuPhdaKDF1GeoeNR93sobBFLaFP23c8ChLZ1FozxRPONcf8BQVXGT4c cfApAMGuzTVNgidw84+QoGs4scET0xRXCM5M6kCJvDTC+RgRaus2xKViLa2ziB7rgDyK 9CSQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683347559; x=1685939559; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=gZ5Qgch1oA3N3ckX0smj3S1JlF/Tr1KiTuWeHk0cGFw=; b=aWTxDC3kdMwstK+QxZsKGUWcW/LT1JOstDl3l7Qk0qR6FIsynWyRA9EjA27zXf2ymG 3lq1iTAqy6kSgtBz16qoVz2lBLH3myiiVGYyPPExGCDlbAwawbAp05tKYXmcFQExprN6 UGRnivrR/ICyLapfiWs8H8C/V5ityNMtSfQCK5VI68nY0VzZEgRLox91deTIMb3yEL1I 8sSzCd+59H+krtx6cfcEFFoieCiSRE9XLy+GozQxhkvKSOYWJVkKhnhz5PZwKVDBBiX3 RoFIGqY1JomsjJEiVXCfPn21wmPf5aiP7nsjRo8i8JPBRVQrwwD+FAQPy2pcGMvOUpOQ sItg== X-Gm-Message-State: AC+VfDx8441L4YtxybdMeElZbW91fcDl8jwsFdxr3mu3gSiMIHR0d/VA BQCEb4IzQPHZPajIj0agJLSYwwWpu+Q= X-Google-Smtp-Source: ACHHUZ7sVij+5L79YWJ0Rm1K53hQlqRtZf7/mZHArpvEFfkW5Cm1jkYDVbDM3N4ugpJZbrW1tax54Q== X-Received: by 2002:a81:920c:0:b0:55a:a635:7e1e with SMTP id j12-20020a81920c000000b0055aa6357e1emr5008142ywg.31.1683347558591; Fri, 05 May 2023 21:32:38 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:9997:2896:95fb:af3b? ([2600:1700:bd2c:b810:9997:2896:95fb:af3b]) by smtp.googlemail.com with ESMTPSA id j17-20020a819211000000b0055a581c7f03sm922396ywg.29.2023.05.05.21.32.37 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 05 May 2023 21:32:37 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------KyQg5tfcSIqph4ieCUTyUe4N" Message-ID: <1c84f5cb-2b37-e877-ae2a-ed3ee3ca799a@gmail.com> Date: Fri, 5 May 2023 23:32:37 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 Subject: Re: How to bring Pgpool-II virtual IP up? Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------KyQg5tfcSIqph4ieCUTyUe4N Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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 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  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. --------------KyQg5tfcSIqph4ieCUTyUe4N Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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.
--------------KyQg5tfcSIqph4ieCUTyUe4N--