Re : Credcheck extension - Mailing list pgsql-general

From 張宸瑋
Subject Re : Credcheck extension
Date
Msg-id CAFsaSDg3oCwP=Oq7Ej7=PLLHy6_5sUn65LwrQFxw0MvEwm=uAA@mail.gmail.com
Whole thread Raw
Responses Re: Re : Credcheck extension
Re: Re : Credcheck extension
List pgsql-general
Hello! 
  I would like to inquire about the installation of the credcheck third-party package to support password complexity and expiration date, etc., when setting up open-source PostgreSQL. I am using the credcheck--2.8.0.sql version from GitHub. After completing the setup, I encountered the following issue: when an account exceeds the configured number of incorrect login attempts, it gets locked. The command SELECT * FROM pg_banned_role; should display the columns roleid, failure_count, and banned_date, and the view is working properly and shows the information. However, according to the example, the roleid does not correctly display the corresponding oid for the account with failed login attempts. I would like to ask if there is a solution for this issue. Thank you!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Getting error 42P02, despite query parameter being sent
Next
From: Julien Rouhaud
Date:
Subject: Re: Re : Credcheck extension