search

MigOpsRepos / credcheck

PostgreSQL plain credential checker
MIT License
57 stars 5 forks source link

feature : Authentication failure ban #27

Closed did16 closed 8 months ago

did16 commented 10 months ago

Hi
It will be nice if The authentication failures history could be stored in a file in $PGDATA/global/.
It is important to note that there have been connection attempts to the database for security reasons.

Thanks in advance
Best Regards

darold commented 10 months ago

The information can be found in PostgreSQL log, for example:

2023-12-02 12:31:13.868 CET [344648] [unknown]@[unknown] LOG:  connection received: host=127.0.0.1 port=43844
2023-12-02 12:31:13.875 CET [344648] test@gilles FATAL:  rejecting connection, user 'test' has been banned

I don't think it is necessary to keep additional traces of these failures through a view.