Credcheck max_auth_failure

From: Teja Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Credcheck max_auth_failure
Date: 2025-01-09 05:27:06
Message-ID: 5BC62BD6-1C34-4698-99ED-9267F46341A8@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Admins,

We are trying to setup password policies on open source Postgres 14 (on SUSE Linux) using credcheck on an instance that has got stand by setup on other server.
On primary, Installed the binaries, created the extension and enabled below parameter:
credcheck.max_auth_failure to 3;

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 working. Restarting instance will get the banned user working but restarting whole instance to activate one user is not a feasible solution.
2. The same parameter is not working on the stand by instance. Even after 3 failed attempts user is still active.

Please let me know if you are aware of any solutions.

Thanks,
J. Teja.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-01-09 05:32:20 Re: Credcheck max_auth_failure
Previous Message SOzcn 2025-01-08 08:48:02 Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster