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 1tVltp-00BJ74-TF for pgsql-admin@arkaria.postgresql.org; Thu, 09 Jan 2025 06:20:10 +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 1tVltp-00D7yp-8n for pgsql-admin@arkaria.postgresql.org; Thu, 09 Jan 2025 06:20:08 +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 1tVlto-00D7yZ-Te for pgsql-admin@lists.postgresql.org; Thu, 09 Jan 2025 06:20:08 +0000 Received: from mail-pl1-x630.google.com ([2607:f8b0:4864:20::630]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tVltm-000ek7-2C for pgsql-admin@lists.postgresql.org; Thu, 09 Jan 2025 06:20:07 +0000 Received: by mail-pl1-x630.google.com with SMTP id d9443c01a7336-2156e078563so6833485ad.2 for ; Wed, 08 Jan 2025 22:20:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736403606; x=1737008406; darn=lists.postgresql.org; h=to:cc:date:message-id:subject:mime-version:from :content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=TslEVB20IWxRFJ6HVfG2BEM+Hr/7JmotVDrox3Ac4jw=; b=kfD2k4s82JZNbzKEnXhrtd3N7J0M9lXiJFDlIQOy564WD53Gd5wl8con9GTgRmfg34 OiR9rr1bQCeH3XGwvCMpu5eHMyZ/v+CfKXh0Yb7GvQxoK2WtAXz/h56vytUZx8aJ4PLv STH+Tn7kPxfYyQJfvLZSgpRN9RCyG1y2dTc61H2VJhyZJFS2irgWWRhpZ+S1QsPc1XqZ twZleiDvnKYBhr3crveSDo/78gRyqV1t7fI27d+w6XJAynbyqm0I4DTUieoR/Lwok4Rz 5pvdr1M9CefxF8JAu3CI4a5u3/VWoSBdGBhE2KzTPCQJkuFDDYfLmLL2MsRvSh8Nd59c 86lA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736403606; x=1737008406; h=to:cc:date:message-id:subject:mime-version:from :content-transfer-encoding:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=TslEVB20IWxRFJ6HVfG2BEM+Hr/7JmotVDrox3Ac4jw=; b=TiigRBilPp3vXu3W9YWbPirCqmWh3/Iyq/IvosNp7VfXpF3buE27oyPqrWgaqT9RTU dZ5EfcBzx7I2DPdpx8SG2dIxXJ46L5Qr3F535PxJglihHIAXhH0FiZuqhHZuFYXJ/SV1 g4tTAoHATHFX6lrnKNSXvHGD4IBBYcO4L1NNAmv8Zx+84SVHWdLngPtqbn0VKGYMR8PS 224GRptoK511FNiavNafe2GYY1iqIwWlnX8pbG7k8riUFYnuorujm9zLLpU/8OUQ0yFD kybnBPySzKwZSHod2UXxhZx+RPetyA+b1PLIhHDXPZe6w7N3/SDr45tsomJCwbVIxwXr 8vbA== X-Gm-Message-State: AOJu0Yw4eNVEuRLEwOXUBCNU1Hn2I9L1jKxLcFTT3/DwI/pM3zlgBMsx G6dqzxgxhFAbnnb8rrsVRNilbDABwCDg5QjuFkYUozMIe0wKUGS0 X-Gm-Gg: ASbGncuwABPL8kA8Xbqh1v5v0LNnIN/g0VedjdyecxgbVXMpVKTSzowsxaPgStPOnqI i9MecbgnqyjpIWZpWV9wCevmst9T/EMJhj04ZD+HSdxIDPsJg+7xrv7jpKDaPsc9EfHH0jy5zT/ F3dkGSm0rdoA2T8CpfNvD8rpTPjxINVgMsbd5vo3gAoos3GVZWzGzIvMTkPDLT9owjZI1Q1WT2P 5D3LOOHEeKVyYLpjvGKE82C5ngrFjyrKxKDEkRwofxD0jiXKU7RMvRGDYg8cau0EZ/K95U9iKkT 06E6W1go6KjmlG5jPva9yngblUqfV0KqzzllNCSuKp0K X-Google-Smtp-Source: AGHT+IEr/G/B1g/lBB/QtD03mqAWouV5MetuVhazMgMcJM66o5HPKkpa598JxI8r5aYo9nqC4J+YZg== X-Received: by 2002:a05:6a00:ac2:b0:725:e1de:c0bf with SMTP id d2e1a72fcca58-72d21f2dcbcmr7506411b3a.9.1736403604602; Wed, 08 Jan 2025 22:20:04 -0800 (PST) Received: from smtpclient.apple (syn-172-115-078-227.res.spectrum.com. [172.115.78.227]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-72aad836bd9sm36430032b3a.78.2025.01.08.22.20.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Jan 2025 22:20:04 -0800 (PST) Content-Type: multipart/alternative; boundary=Apple-Mail-05F27855-768B-49B2-8E6F-0EA81A9A0503 Content-Transfer-Encoding: 7bit From: Teja Jakkidi Mime-Version: 1.0 (1.0) Subject: Re: Credcheck max_auth_failure Message-Id: <131956F0-B580-465D-91B2-C52D9E54EA05@gmail.com> Date: Wed, 8 Jan 2025 22:19:53 -0800 Cc: pgsql-admin To: "David G. Johnston" X-Mailer: iPhone Mail (21G93) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-05F27855-768B-49B2-8E6F-0EA81A9A0503 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
=EF=BB=BFThank you, David.
=
Regards,
J. Teja.
=

On Jan 8, 2025, at 9:32=E2=80= =AFPM, David G. Johnston <david.g.johnston@gmail.com> wrote:

=EF=BB=BFOn Wedn= esday, January 8, 2025, Teja Jakkidi <teja.jakkidi05@gmail.com> wrote:

1. The parameter is working as expected on primary and banning the id in the= 3rd attempt with wrong password.
However, I am not able to figure out how to get the banned user back to work= ing. Restarting instance will get the banned user working but restarting who= le instance to activate one user is not a feasible solution.


You should read its docs.  It discusse= s this.


David J.

= --Apple-Mail-05F27855-768B-49B2-8E6F-0EA81A9A0503--