Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upEgq-001Qrd-RB for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 23:27:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1upEgq-001sSv-Ag for pgpool-hackers@arkaria.postgresql.org; Thu, 21 Aug 2025 23:27:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1upEgq-001sSn-5G for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 23:27:28 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1upEgn-0015uZ-2W for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 23:27:27 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:To:Message-Id:Date:Sender: Reply-To:Cc:Content-ID:Content-Description; bh=QyZZwRCPJMTGgr5K+133jOhTQGfbxD1FrflcjhfWCTg=; b=VMBhdkoxa8BdPuecMIPW7Z6y8L EydJYYy43Divf/L36aOtWXT8HuOFuAQFDYReuVBe9A+7XOBa6396IIYqKxhXSjI/8DwJKya6bw7XR /4aHrQmsb1h10nU5Hu3XKwQsY53yF845uxf7E+6uWWF8Mbv0WzsMwGp9WmdxIuopWJD71VV1c3wEs LmMjdqmrHlFEYJKbjbsocZDfVskMU/FziY83uT6thaF3otdH7KdG2JeYO7t1D2gTG1tyfepHVvjDM /yLQl9sH8J/9vUhVdNC9hTso0AspoezXHDFsiW8+DxiL1ngz7tTqM9xtnNyPLQJX5XB/g0WNkkbbD D4jeBLjg==; Received: from [2409:11:4120:300:d02a:fdde:32de:741] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305_SHA256 (Exim 4.96) (envelope-from ) id 1upEgk-002b3T-1M for pgpool-hackers@lists.postgresql.org; Thu, 21 Aug 2025 23:27:25 +0000 Date: Fri, 22 Aug 2025 08:26:47 +0900 (JST) Message-Id: <20250822.082647.288485281093236217.ishii@postgresql.org> To: pgpool-hackers@lists.postgresql.org Subject: Re: Enhance watchdog_setup From: Tatsuo Ishii In-Reply-To: <20250820.151646.1640218512808280876.ishii@postgresql.org> References: <20250820.151646.1640218512808280876.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 26.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:d02a:fdde:32de:741 (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > A tool called "watchdog_setup" has been used to create a simple test > cluster environment on localost for developing and testing > Pgpool-II. It allows to create 3 watchdog node and 3 PostgreSQL server > configuration by single command for example: > > $ watchdog_set -wn 3 -n 3 > > The command is also used in our regression test. > > One of the things that watchdog_setup does not support is, assigning > VIP. This is a limitation by deign as it runs on a single > host. However, I would like to test whether watchdog properly executes > if_up_cmd or if_down_cmd, which could increase the test coverage. In > the attached patch, a new option "-vip [ip]" is added to > watchdog_setup. If ip is omitted, '127.0.0.1' is assumed. > The parameters added by this option are followings: > > delegate_ip = '127.0.0.1' > if_up_cmd = '/usr/bin/echo "if_up_cmd executed"' > if_down_cmd = 'usr/bin/echo "if_down_cmd executed"' > arping_cmd = '/usr/bin/true' > > Comments and suggestions are welcome. Patch pushed to master branch. Thanks. -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp