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.
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 |