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 1pvHvv-0008Nv-Sk for pgsql-admin@arkaria.postgresql.org; Sat, 06 May 2023 13:26:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pvHvu-0003mp-E2 for pgsql-admin@arkaria.postgresql.org; Sat, 06 May 2023 13:26:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvHvu-0003mF-22 for pgsql-admin@lists.postgresql.org; Sat, 06 May 2023 13:26:42 +0000 Received: from mail-yb1-xb36.google.com ([2607:f8b0:4864:20::b36]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pvHvp-000wme-9n for pgsql-admin@lists.postgresql.org; Sat, 06 May 2023 13:26:41 +0000 Received: by mail-yb1-xb36.google.com with SMTP id 3f1490d57ef6-b9a879cd49cso3815396276.0 for ; Sat, 06 May 2023 06:26:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1683379595; x=1685971595; 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=mIxNjv0OhacKvmJF540y9tgf6FBQ1J34h4m1LrFCFIU=; b=gjHkq2JPOYhnL4yCKtYpf+K9RAwa1ATgjCk8aCDIyL2PostJB4twZQ9ykIflmBEuDw 6C+j6N42qStcJv8cEbisNPPADfka8cstk7boXD3M7hs8/C/A4MomnudDxRLYf7H+Kva5 YVzBC0SJSVJ32PUfWfuG9OBl+PabdxFRUIJEK90oWuRQis4DKVSENzlH4GR/3iePeHxa VWWH4hpX7vNyHuPSXk2VT98U7D90e1wWZqq+JgZ+Oy5VMVWPI6OZMvhhSINB+5yUJ6/L oD/7smBRdjXNGRYAZ60WdEkxGvIIgF60QKJleRFdlD7LBvOnyCAGRQ+OqWpEdITHNrRC zDDg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1683379595; x=1685971595; 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=mIxNjv0OhacKvmJF540y9tgf6FBQ1J34h4m1LrFCFIU=; b=iy7qEFXMlSG6QyT3rOT9zeBkqruDL7jXn+Aonwd/6ezuzr4XLxWxJJLPqDa8KDxIkK BzLKw1iosAzRrACTZw8PO8sEPUm1E4C48NnBi/eFDNiSvF/sKucAWp+lHtbtVyN3kEsW m+GFKqmm7u0TU5O+GvW64RRU3ExxxwARYTZJA4bK2HXAPgU4Bpki3/x9l+B2kM9kCRZY 2ErPhpsb507r0sV5XIQvyagUkcuRBCDOCh4dZN+bG2t4SayQS9SRHkWyH8vFWnMoOe55 bhJHFphOvPe2x4pz8CKCNVk418HJuAx0eMKFgttlN8/tJKgdxCNN38Qd+5Uf6UxQMqlR uKgg== X-Gm-Message-State: AC+VfDzZbpN483pFh7Po3D/LZTLuB8R8fONW2mbMFXRYgvxiqCm6jGhZ V6MucEScEqm5Ia5UtYTgThK043LiEmw= X-Google-Smtp-Source: ACHHUZ7glPXPrSiRIW9bG5felZgo/3ceLKAA2Ts+orp323hyiaxnLyCdza8DQKV8dikED2qlXqSzXg== X-Received: by 2002:a25:e70f:0:b0:b92:5c45:b01a with SMTP id e15-20020a25e70f000000b00b925c45b01amr5630837ybh.16.1683379595327; Sat, 06 May 2023 06:26:35 -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 c16-20020a25a2d0000000b00b9e6f1f9c76sm1067845ybn.29.2023.05.06.06.26.34 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 06 May 2023 06:26:34 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------Qb85tmqt3xSOqEXQ59XWJrTR" Message-ID: Date: Sat, 6 May 2023 08:26:34 -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. --------------Qb85tmqt3xSOqEXQ59XWJrTR Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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) > > Should I use 'ip address add133.137.177.143/24dev eth0:0' command on all > Pgpool servers? > > Thank you very much. > ---------------------------------------------------------------------------- > *From:* Satyamnaidu Gokeda > *Sent:* Saturday, May 6, 2023 10:56 AM > *To:* Bruce Momjian > *Cc:* ?????????? RMUTT CPE IX ; > 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 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. --------------Qb85tmqt3xSOqEXQ59XWJrTR Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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:
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.
--------------Qb85tmqt3xSOqEXQ59XWJrTR--