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 1v9hyA-006FbP-7A for pgpool-general@arkaria.postgresql.org; Fri, 17 Oct 2025 10:45:57 +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 1v9hy9-001iPc-7E for pgpool-general@arkaria.postgresql.org; Fri, 17 Oct 2025 10:45:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v9hy9-001iPS-1Z for pgpool-general@lists.postgresql.org; Fri, 17 Oct 2025 10:45:56 +0000 Received: from mail-oi1-x22a.google.com ([2607:f8b0:4864:20::22a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1v9hy5-002hNb-3D for pgpool-general@lists.postgresql.org; Fri, 17 Oct 2025 10:45:55 +0000 Received: by mail-oi1-x22a.google.com with SMTP id 5614622812f47-43f9cc65f66so1013872b6e.2 for ; Fri, 17 Oct 2025 03:45:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760697952; x=1761302752; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=UVgwiit3z31mzxUNBJro6vsNd6fbjeseLDWb0hnOtOU=; b=X2tyvpH0YyAEqyF1OLMBDuP+wvxNkjeWds5zRZXPpOoixaudgLvT/lj8pK3PTuOjCe E4P7/m92b1WEXssClhJOlmUeJSHemuWnpsqUShjfvdb3LGNR1Gwpo4GQwlECEBi1UQyw CcumKyBeX0uSHrESYAgUU31p38FpS/wCGJm2J8cAJBU6PwCJaysrUvDn3cYZWsZbL3qW cPVXAnVZ7B9DhDSfWoopn5bS0++DpxenL7WBLWW1Hmic5E6pMxbVWkO1JLSwvHX+bCiL 4SBR9OBjOwuVA+HsNioRsoyribvLRwYwgOUZshSqGcUvElZqZHydboHp0Y7PHgR8jyuW Drew== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760697952; x=1761302752; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=UVgwiit3z31mzxUNBJro6vsNd6fbjeseLDWb0hnOtOU=; b=g7okOzxkdKGTlq5U+spBHagcp1Ny+bl2iJv9rwi4b6CbWp7J5tuVM6ntEE80RdRfe2 k41wZ3ycd7eI0GGo4efs3t5vW6vQtVoKnbqnlDT7VTA05KrdkHIy5VU+1xVMV1pJWgsw eIjaDHBGQFczQUY4Rv5FXRIUGhuUN95SMtcKUywov+qH1xEWg6d7v86iK6cPjHcB8M3n h/KwujQsEfYjIyRY5oVTTUG12zAiETPMbNWoEUQ2DRXBkhacZXgXlAHggtO/R16Mlpq+ jfqcfP6c9qkJdPTy4v5Au6a6BbkzRpMVwb/Pf4exn7f0EfAeIwuq48KYquZOFSGKsnuZ 5aCA== X-Gm-Message-State: AOJu0YxJJUyMEyFpexsNtAwUdPFiJlJJhlfzlPXZcbTgl2yJ9FNpFKi8 f1fgMMXsPZ5ODWITT3Rt9gbaEhVhT2fgQYSrIZyxbfbxqBR0/efK0C0eHNljEaQx36rXJU4LQ2h K4adtyJGmZMuOyEfV5ZxYEE4qBhthepTbByMq X-Gm-Gg: ASbGnctv1WdVItVqtQWqB2QwL8262J8KyKJFWQ95UFe3+uGrALO5piOBAT7BaG+S2mJ rV9QzMPv3lUSzmaIw214rGk1162T141RZaBO/phGT38U/O9+dXmHcNh9CWO54XWCr4TsEcXP53U wj/6p2S+7o3aEZd1Pb9WvN1ONUDaJ34VA8I3PalDjo60s3FnRGJHPBD/Wnxu+3aMZbyJ8zTvCq1 /mQnkwTfQ8emr2QqKpNYZgVMUTpeXAiVV/59vXjq6jqHRyKI8RdDiDAlHdsP7SeIGIZdQ== X-Google-Smtp-Source: AGHT+IFbZTFvhrgeyeog8yQqMtkMMMSmjZzCibhWSD0oqYML82RdoEY3YbXIa8jmDQrD1GsJPW8tOsj48LA7mze6cgw= X-Received: by 2002:a05:6808:1a0d:b0:43d:20f2:2e26 with SMTP id 5614622812f47-443a2ed7e2bmr1468340b6e.10.1760697952269; Fri, 17 Oct 2025 03:45:52 -0700 (PDT) MIME-Version: 1.0 From: Luca Ferrari Date: Fri, 17 Oct 2025 12:45:16 +0200 X-Gm-Features: AS18NWDkBAWlUAVDQWk0xDQ4b2iaio25QDv1wPbXaz5eyp0WnhhtoZXIy0bJ6Qc Message-ID: Subject: what is causing different pcp_node_info status To: pgpool-general@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi all, I'm using PgPool 4.6.2, PostgreSQL 17.5, three nodes: - pg1 primary - pg2 replica - pg3 replica So far so good, the initial situation of pcp_node_info reported by all the nodes seems consistent: % ssh pg1 'sudo -u postgres pcp_node_info -U pgpool' pg1 5432 2 0.166667 up up primary primary 0 none none 2025-10-16 11:49:45 pg2 5432 2 0.333333 up up standby standby 0 streaming async 2025-10-16 12:02:10 pg3 5432 2 0.500000 up up standby standby 0 streaming async 2025-10-16 11:49:53 % ssh pg2 'sudo -u postgres pcp_node_info -U pgpool' pg1 5432 1 0.166667 waiting up primary primary 0 none none 2025-10-16 11:51:36 pg2 5432 1 0.333333 waiting up standby standby 0 streaming async 2025-10-16 12:02:09 pg3 5432 1 0.500000 waiting up standby standby 0 streaming async 2025-10-16 11:51:36 % ssh pg3 'sudo -u postgres pcp_node_info -U pgpool' pg1 5432 1 0.166667 waiting up primary primary 0 none none 2025-10-16 11:41:22 pg2 5432 1 0.333333 waiting up standby standby 0 streaming async 2025-10-16 12:02:09 pg3 5432 1 0.500000 waiting up standby standby 0 streaming async 2025-10-16 11:49:53 Replicas are streaming, so I reboot pg3 (at 17:30) and the situation appears different: % ssh pg3 'sudo reboot'