Grenoble - January 30, 2024
The credcheck PostgreSQL extension provides few general credential checks, which will be evaluated during the user creation, during the password change and user renaming. By using this extension, we can define a set of rules:
This release is a maintenance release to fix a major issue with the backup of the password history file with pgBackRest and adds an authentication delay feature.
credcheck.auth_delay_ms
causes the server to pause for a
given number of milliseconds before reporting authentication failure. This
makes brute-force attacks on database passwords more difficult.
This patch is purely a copy/paste from the auth_delay extension just to limit the
number of extensions to preload. See https://www.postgresql.org/docs/current/auth-delay.html
for more information about the origin of this feature.$PGDATA/global/pg_password_history
to be a multiple of 8192
to fix pgBackRest error caused by the error message: "page misalignment in file
/.../global/pg_password_history: file size 2604 is not divisible by page size 8192"Extension upgrade requires a PostgreSQL restart to reload the credcheck library.
Complete list of changes and acknowledgments are available here
credcheck is an open project under the PostgreSQL license created at MigOps Inc, developped and maintained at HexaCluster Corp by Gilles Darold. Any contribution to build a better tool is welcome. You can send your ideas, features requests or patches using the GitHub tools.
Links :
The credcheck extension is an original work of MigOps Inc, Since MigOPs is closed Gilles Darold is the official maintainer. If you need more information please contact me
Documentation at https://github.com/MigOpsRepos/credcheck#readme