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.96) (envelope-from ) id 1wPdm9-000uyj-1n for pgsql-bugs@arkaria.postgresql.org; Wed, 20 May 2026 10:03:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wPdm7-0073in-1U for pgsql-bugs@arkaria.postgresql.org; Wed, 20 May 2026 10:03:40 +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.96) (envelope-from ) id 1wPdm7-0073ie-0f for pgsql-bugs@lists.postgresql.org; Wed, 20 May 2026 10:03:40 +0000 Received: from mail-oo1-xc2d.google.com ([2607:f8b0:4864:20::c2d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wPdm5-00000000WvO-3vuw for pgsql-bugs@lists.postgresql.org; Wed, 20 May 2026 10:03:39 +0000 Received: by mail-oo1-xc2d.google.com with SMTP id 006d021491bc7-6948fb494a0so2596681eaf.2 for ; Wed, 20 May 2026 03:03:37 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779271415; cv=none; d=google.com; s=arc-20240605; b=hmfWiS5tsnsHAMGJOVfJWyxpdzns4uipWpnwLOQQkrFQQvNqbFL2cvDt9sqoFcS7nh okkRTn2rGOn7qSxvtryDmHaZ77SLdblbIT0qx5XR39gBAMTNlLUAKPXKTjVpSGytUaNI 12fuHRk/MxlhsNN3byn3k2DitFj/eDo8vd/8dRTJ1R7rN/pgOqJ+pz3Qm+U7q6TztR6W 7YgeH0oX5A9T+iqy1yHEOIF8e9SyXQosihfRqcKKJWRsWqhSxUNZdEHG8mtjWI+HbsA6 CPuaWEib1nFPJq4kEjS1/43BQwK0ELKPMcHLA3OoWwcN5yTGzNw0Dj+TTYr98K8sZ2JM rvoA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=40bOQZabW3LxUqLXHpYOVT10QJTSz5nr6KLw/ajjqyQ=; fh=/+ysgKy8dR45xh65cdk7fKJ4YsQhAZ3bPGhBP3ahJMU=; b=BD2RpE9KGFCxLKC2VQ/9PZ3TEjN5vXVw53d1kJ4epiTHCYaQxK6FU281ITGfACIE2H 0LmTlEHmrwp2EWMtvGz01moD+dqcxkSdzQBR8B+y1rxlP7NQNsu3ErMGxZumMHY44hUj /XBWf9dqfDaLl+iVjpu0yE3/N9FgxM8LNjkGBnmw8+UjoUpS48ueaTVYQMEQYt4OZRLL YG0VQX2coX6Gm5+JJhWIlh1K2R7AAFKy310b+Wyt5t5i4NdrMX+x+AM/Gg1+gMZg6pM7 PEkve8JAQfQQ8zpoAUt0fmakcS4hWcm0QvWyo9f6DnWfH+1kP6WNm03eKjZE8GNH3NIc +rkw==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779271415; x=1779876215; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=40bOQZabW3LxUqLXHpYOVT10QJTSz5nr6KLw/ajjqyQ=; b=RfZZKpzMPuHMXbMzq22XWu0h0kAv4bAuef1ofrw4qXukSdPkf4nqK3FZyh7LG7PtY4 C907AJzWvrgAbJighAv3uDGeeCRpr9m8FGkT5IjhEzRRfO8zwceLMbzeLKnpDdRjWrqW unjQ2lUMwcAFojYLiEREHced0wXlFl/uY3ZLHAT604zr6mhn6gXYJXt1GoRj4/itzQY2 y7WY/8efAT0RnaspjexBI9vWU75sdLSQ52X5Yulmtl2uAkakdFo8YeBT+xg9wMbLcDd5 EJw+fF6aRrBF7IevPSdGnmWgcYue4hhoe+uPvw1lZ0AJXwtNcc+ucfnXZ0T6+K+Of5Pi xCkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779271415; x=1779876215; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=40bOQZabW3LxUqLXHpYOVT10QJTSz5nr6KLw/ajjqyQ=; b=K7Oe7UpaNsKa5tVtMobchDnWJlkMogRNP6x5S8QOSuF0lmxQ8Ji6VeuG5Rnq+opvsz BKswzOHtEwQ2p3iT8gplPyH8lVHbLgIPO90UJ0AuUNKBWYsse3SyJwPxh2iOanQvtMWZ ewjW8LJxlqzEvOMsQIfLI4rhl0W5Ei9g4l1QfEHMAOlOaOfwow16LzsGgFFgxThUhZcO IdKsO7074WhRL14S7BcyLgW1jArPqVvj+B0CdgNKaYwZKJ+oGmL5LK0m5hFPKDhhIzMt qePs7fM7Otv180VELWTqYOn7P+FPYSb0QYiMOqBhuovgZeYtA1bn/OUIJTkPZ8bJxLq8 s+Ag== X-Forwarded-Encrypted: i=1; AFNElJ82IHgNiMDklidLNVMVnB/aqQoftu3dU+sktIpHRugzbihOH7JnhRomKQbE3dpYjNYyhcg/6R0SC+61@lists.postgresql.org X-Gm-Message-State: AOJu0Yw48d8eAWLey17I3gHcABD+5/dMkubISodobhhI/6Ai/GGoOH9i SmXPahH6vUkEOoCq1FsjXZL+/opM/iaaOFkCGbm15ic4n6D2HZeJJAG8p8qHJK8quc4idBOmYrH XStUIO+dUAbcp7h0MLICMkNYo9Xf4d+4= X-Gm-Gg: Acq92OFahlRsFM3LbdPgFmerZCPTR50USZuCg7G43y2iY/Zasq7uF5aMtgCy9MnIg2K icOltB1Dr/8d3dSUL70Q/raq6+SyquQswri9RJeIBsQ+fY0KSygpUaijWyyGmb1XN4Cqilw/7az PN/sG7SW1Qc8dtp4LzUEAS2FOh7jx6Kam/zsNpp4z9rKXSqeVWGOq8P+9AIpkZG3j3rvnXaOgyK EiLd/D6XJc1SPzZUmMtu6i/2zQLwG+kBZfNru7dpMsCOmlDhIjd+hlTIL58AA+OmpuMXseIPjpY 7p4QgHc8aWRyLnrl/hofPcADooZq4/IjlcqEbGwH/Q3cGAS/+dN5 X-Received: by 2002:a05:6820:8105:b0:69b:34db:20d4 with SMTP id 006d021491bc7-69c9437c73dmr15111706eaf.32.1779271415536; Wed, 20 May 2026 03:03:35 -0700 (PDT) MIME-Version: 1.0 References: <19488-d7ccfca2bf6b74b0@postgresql.org> In-Reply-To: From: Fujii Masao Date: Wed, 20 May 2026 19:03:23 +0900 X-Gm-Features: AVHnY4JKlStN1elphfdX4GjFRNt7yLFbAQS2-91rjewaYxv8-9PpTNnJGPitSSs Message-ID: Subject: Re: BUG #19488: Standby connection fails after dropping on login event trigger enabled always To: Ayush Tiwari Cc: kyzevan23@mail.ru, pgsql-bugs@lists.postgresql.org, Alexander Korotkov Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, May 20, 2026 at 1:37=E2=80=AFPM Ayush Tiwari wrote: > Thanks for the report and the precise repro. +1 > Attached patch adds a RecoveryInProgress() check to skip the cleanup > branch on standbys. Thanks for investigating this issue and for the patch! The patch looks good to me. > I think this needs to be backpatched too. Yes. Seems this should be backpatched to v17, where login event triggers were introduced. Regards, --=20 Fujii Masao