Skip to content

Releases: RafiaSabih/pg_auth_mon

v3.0

05 Aug 13:44
cdab237
Compare
Choose a tag to compare

Fixes to compile with Postgres version 17

Compatible with PG15

12 Apr 12:11
b10818c
Compare
Choose a tag to compare

This release extends the support of this extension to Postgres version 15.

Initial release

24 Feb 08:57
8a57226
Compare
Choose a tag to compare

The goal of this extension is to ease monitoring of login attempts to your database. Although each failed login is written to database log file, but it is not straightforward to identify through that information alone if your database is under some malicious intents.

Information in the view pg_auth_mon are as follows,

Total number of successful attempts
Last timestamp of successful login
Last time of failed login attempt
Total number of failed login attempts because of some conflict in hba file
Total number of authentication failures because of other issues
Each valid user who attempts the login gets a tuple in this view
However, all the attempts of login via some invalid user names are summed up in a single tuple, with its oid being zero
The username for a given oid can be retrieved from the system table -- pg_roles

This extension can be used with PostgreSQL versions starting from v9.6.