Re: Re : Credcheck extension

Hi,

On Mon, Nov 18, 2024 at 5:03 PM 張宸瑋 <kenny020307@gmail.com> wrote:
>
> Hello!
>   I would like to inquire about the installation of the credcheck third-party package to support password complexity
andexpiration 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
incorrectlogin 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
liketo ask if there is a solution for this issue. Thank you! 

I did a quick test locally and as far as I can see it seems to work as expected:

$ psql -U bob postgres
Password for user bob:
psql: error: connection to server at "127.0.0.1", port 11035 failed:
FATAL:  password authentication failed for user "bob"

$ psql -U postgres -c "SELECT roleid::regrole, * from pg_banned_role"
 roleid | roleid | failure_count | banned_date
--------+--------+---------------+-------------
 bob    | 750815 |             1 | <NULL>
(1 row)

If you don't get a similar behavior you should raise an issue to the
author directly on the extension's github repo.