pg_auth_mon

monitor connection attempts per user

Overview

Package	Version	Category	License	Language
`pg_auth_mon`	`5.0`	SEC	MIT	C

ID	Extension	Bin	Lib	Load	Create	Trust	Reloc	Schema
7150	`pg_auth_mon`	No	Yes	Yes	Yes	No	Yes	-

Related	`set_user` `login_hook` `pg_session_jwt` `auth_delay` `logerrors` `pg_stat_log` `pgelog` `pgaudit` `pg_permissions`

SQL version 1.1; requires preload.

Version

Type	Repo	Version	PG Ver	Package	Deps
EXT	MIXED	`5.0`	1817161514	`pg_auth_mon`	-
RPM	PGDG	`3.0`	1817161514	`pg_auth_mon_$v`	-
DEB	PIGSTY	`5.0`	1817161514	`postgresql-$v-pg-auth-mon`	-

OS / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PGDG 3.0 el8.x86_64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-3PGDG.rhel8.x86_64.rpm PGDG · 3.0 · 16.9KiB	PGDG 3.0 el8.x86_64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-1PGDG.rhel8.x86_64.rpm PGDG · 3.0 · 16.6KiB	PGDG 2.0 el8.x86_64.pg16 : pg_auth_mon_16 pg_auth_mon_16-2.0-1.rhel8.x86_64.rpm PGDG · 2.0 · 16.3KiB	PGDG 2.0 el8.x86_64.pg15 : pg_auth_mon_15 pg_auth_mon_15-2.0-1.rhel8.x86_64.rpm PGDG · 2.0 · 16.3KiB pg_auth_mon_15-1.0-1.rhel8.x86_64.rpm PGDG · 1.0 · 23.5KiB	PGDG 2.0 el8.x86_64.pg14 : pg_auth_mon_14 pg_auth_mon_14-2.0-1.rhel8.x86_64.rpm PGDG · 2.0 · 16.2KiB pg_auth_mon_14-1.0-1.rhel8.x86_64.rpm PGDG · 1.0 · 23.9KiB
el8.aarch64	PGDG 3.0 el8.aarch64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-3PGDG.rhel8.aarch64.rpm PGDG · 3.0 · 17.0KiB	PGDG 3.0 el8.aarch64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-1PGDG.rhel8.aarch64.rpm PGDG · 3.0 · 16.7KiB	PGDG 2.0 el8.aarch64.pg16 : pg_auth_mon_16 pg_auth_mon_16-2.0-1.rhel8.aarch64.rpm PGDG · 2.0 · 16.4KiB	PGDG 2.0 el8.aarch64.pg15 : pg_auth_mon_15 pg_auth_mon_15-2.0-1.rhel8.aarch64.rpm PGDG · 2.0 · 16.4KiB pg_auth_mon_15-1.0-1.rhel8.aarch64.rpm PGDG · 1.0 · 23.5KiB	PGDG 2.0 el8.aarch64.pg14 : pg_auth_mon_14 pg_auth_mon_14-2.0-1.rhel8.aarch64.rpm PGDG · 2.0 · 16.3KiB pg_auth_mon_14-1.0-1.rhel8.aarch64.rpm PGDG · 1.0 · 23.5KiB
el9.x86_64	PGDG 3.0 el9.x86_64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-6PGDG.rhel9.8.x86_64.rpm PGDG · 3.0 · 17.0KiB pg_auth_mon_18-3.0-3PGDG.rhel9.x86_64.rpm PGDG · 3.0 · 16.9KiB	PGDG 3.0 el9.x86_64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-6PGDG.rhel9.8.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_17-3.0-1PGDG.rhel9.x86_64.rpm PGDG · 3.0 · 16.8KiB	PGDG 3.0 el9.x86_64.pg16 : pg_auth_mon_16 pg_auth_mon_16-3.0-6PGDG.rhel9.8.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_16-2.0-1.rhel9.x86_64.rpm PGDG · 2.0 · 16.3KiB	PGDG 3.0 el9.x86_64.pg15 : pg_auth_mon_15 pg_auth_mon_15-3.0-6PGDG.rhel9.8.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_15-2.0-1.rhel9.x86_64.rpm PGDG · 2.0 · 16.3KiB pg_auth_mon_15-1.0-1.rhel9.x86_64.rpm PGDG · 1.0 · 23.9KiB	PGDG 3.0 el9.x86_64.pg14 : pg_auth_mon_14 pg_auth_mon_14-3.0-6PGDG.rhel9.8.x86_64.rpm PGDG · 3.0 · 17.0KiB pg_auth_mon_14-2.0-1.rhel9.x86_64.rpm PGDG · 2.0 · 16.3KiB
el9.aarch64	PGDG 3.0 el9.aarch64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-6PGDG.rhel9.8.aarch64.rpm PGDG · 3.0 · 17.0KiB pg_auth_mon_18-3.0-3PGDG.rhel9.aarch64.rpm PGDG · 3.0 · 16.7KiB	PGDG 3.0 el9.aarch64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-6PGDG.rhel9.8.aarch64.rpm PGDG · 3.0 · 17.0KiB pg_auth_mon_17-3.0-1PGDG.rhel9.aarch64.rpm PGDG · 3.0 · 16.7KiB	PGDG 3.0 el9.aarch64.pg16 : pg_auth_mon_16 pg_auth_mon_16-3.0-6PGDG.rhel9.8.aarch64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_16-2.0-1.rhel9.aarch64.rpm PGDG · 2.0 · 16.1KiB	PGDG 3.0 el9.aarch64.pg15 : pg_auth_mon_15 pg_auth_mon_15-3.0-6PGDG.rhel9.8.aarch64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_15-2.0-1.rhel9.aarch64.rpm PGDG · 2.0 · 16.2KiB pg_auth_mon_15-1.0-1.rhel9.aarch64.rpm PGDG · 1.0 · 23.7KiB	PGDG 3.0 el9.aarch64.pg14 : pg_auth_mon_14 pg_auth_mon_14-3.0-6PGDG.rhel9.8.aarch64.rpm PGDG · 3.0 · 17.0KiB pg_auth_mon_14-2.0-1.rhel9.aarch64.rpm PGDG · 2.0 · 16.1KiB pg_auth_mon_14-1.0-1.rhel9.aarch64.rpm PGDG · 1.0 · 23.7KiB
el10.x86_64	PGDG 3.0 el10.x86_64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-6PGDG.rhel10.2.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_18-3.0-3PGDG.rhel10.x86_64.rpm PGDG · 3.0 · 17.2KiB	PGDG 3.0 el10.x86_64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-6PGDG.rhel10.2.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_17-3.0-3PGDG.rhel10.x86_64.rpm PGDG · 3.0 · 17.3KiB	PGDG 3.0 el10.x86_64.pg16 : pg_auth_mon_16 pg_auth_mon_16-3.0-6PGDG.rhel10.2.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_16-3.0-3PGDG.rhel10.x86_64.rpm PGDG · 3.0 · 17.3KiB	PGDG 3.0 el10.x86_64.pg15 : pg_auth_mon_15 pg_auth_mon_15-3.0-6PGDG.rhel10.2.x86_64.rpm PGDG · 3.0 · 17.2KiB pg_auth_mon_15-3.0-3PGDG.rhel10.x86_64.rpm PGDG · 3.0 · 17.3KiB	PGDG 3.0 el10.x86_64.pg14 : pg_auth_mon_14 pg_auth_mon_14-3.0-6PGDG.rhel10.2.x86_64.rpm PGDG · 3.0 · 17.1KiB pg_auth_mon_14-3.0-3PGDG.rhel10.x86_64.rpm PGDG · 3.0 · 17.2KiB
el10.aarch64	PGDG 3.0 el10.aarch64.pg18 : pg_auth_mon_18 pg_auth_mon_18-3.0-6PGDG.rhel10.2.aarch64.rpm PGDG · 3.0 · 17.2KiB pg_auth_mon_18-3.0-3PGDG.rhel10.aarch64.rpm PGDG · 3.0 · 17.4KiB	PGDG 3.0 el10.aarch64.pg17 : pg_auth_mon_17 pg_auth_mon_17-3.0-6PGDG.rhel10.2.aarch64.rpm PGDG · 3.0 · 17.3KiB pg_auth_mon_17-3.0-3PGDG.rhel10.aarch64.rpm PGDG · 3.0 · 17.4KiB	PGDG 3.0 el10.aarch64.pg16 : pg_auth_mon_16 pg_auth_mon_16-3.0-6PGDG.rhel10.2.aarch64.rpm PGDG · 3.0 · 17.3KiB pg_auth_mon_16-3.0-3PGDG.rhel10.aarch64.rpm PGDG · 3.0 · 17.4KiB	PGDG 3.0 el10.aarch64.pg15 : pg_auth_mon_15 pg_auth_mon_15-3.0-6PGDG.rhel10.2.aarch64.rpm PGDG · 3.0 · 17.3KiB pg_auth_mon_15-3.0-3PGDG.rhel10.aarch64.rpm PGDG · 3.0 · 17.4KiB	PGDG 3.0 el10.aarch64.pg14 : pg_auth_mon_14 pg_auth_mon_14-3.0-6PGDG.rhel10.2.aarch64.rpm PGDG · 3.0 · 17.3KiB pg_auth_mon_14-3.0-3PGDG.rhel10.aarch64.rpm PGDG · 3.0 · 17.4KiB
d12.x86_64	PIGSTY 3.0 d12.x86_64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 3.0 · 16.5KiB	PIGSTY 3.0 d12.x86_64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 3.0 · 16.4KiB	PIGSTY 3.0 d12.x86_64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 3.0 · 16.4KiB	PIGSTY 3.0 d12.x86_64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 3.0 · 16.5KiB	PIGSTY 3.0 d12.x86_64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~bookworm_amd64.deb PIGSTY · 3.0 · 16.2KiB
d12.aarch64	PIGSTY 3.0 d12.aarch64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d12.aarch64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d12.aarch64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d12.aarch64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d12.aarch64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~bookworm_arm64.deb PIGSTY · 3.0 · 16.7KiB
d13.x86_64	PIGSTY 3.0 d13.x86_64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~trixie_amd64.deb PIGSTY · 3.0 · 16.5KiB	PIGSTY 3.0 d13.x86_64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~trixie_amd64.deb PIGSTY · 3.0 · 16.4KiB	PIGSTY 3.0 d13.x86_64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~trixie_amd64.deb PIGSTY · 3.0 · 16.5KiB	PIGSTY 3.0 d13.x86_64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~trixie_amd64.deb PIGSTY · 3.0 · 16.5KiB	PIGSTY 3.0 d13.x86_64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~trixie_amd64.deb PIGSTY · 3.0 · 16.3KiB
d13.aarch64	PIGSTY 3.0 d13.aarch64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~trixie_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d13.aarch64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~trixie_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d13.aarch64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~trixie_arm64.deb PIGSTY · 3.0 · 16.7KiB	PIGSTY 3.0 d13.aarch64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~trixie_arm64.deb PIGSTY · 3.0 · 16.8KiB	PIGSTY 3.0 d13.aarch64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~trixie_arm64.deb PIGSTY · 3.0 · 16.7KiB
u22.x86_64	PIGSTY 3.0 u22.x86_64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~jammy_amd64.deb PIGSTY · 3.0 · 17.6KiB	PIGSTY 3.0 u22.x86_64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~jammy_amd64.deb PIGSTY · 3.0 · 20.5KiB	PIGSTY 3.0 u22.x86_64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~jammy_amd64.deb PIGSTY · 3.0 · 20.5KiB	PIGSTY 3.0 u22.x86_64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~jammy_amd64.deb PIGSTY · 3.0 · 20.5KiB	PIGSTY 3.0 u22.x86_64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~jammy_amd64.deb PIGSTY · 3.0 · 20.3KiB
u22.aarch64	PIGSTY 3.0 u22.aarch64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~jammy_arm64.deb PIGSTY · 3.0 · 17.5KiB	PIGSTY 3.0 u22.aarch64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~jammy_arm64.deb PIGSTY · 3.0 · 20.5KiB	PIGSTY 3.0 u22.aarch64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~jammy_arm64.deb PIGSTY · 3.0 · 20.4KiB	PIGSTY 3.0 u22.aarch64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~jammy_arm64.deb PIGSTY · 3.0 · 20.4KiB	PIGSTY 3.0 u22.aarch64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~jammy_arm64.deb PIGSTY · 3.0 · 20.1KiB
u24.x86_64	PIGSTY 3.0 u24.x86_64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~noble_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u24.x86_64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~noble_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u24.x86_64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~noble_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u24.x86_64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~noble_amd64.deb PIGSTY · 3.0 · 17.4KiB	PIGSTY 3.0 u24.x86_64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~noble_amd64.deb PIGSTY · 3.0 · 17.2KiB
u24.aarch64	PIGSTY 3.0 u24.aarch64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~noble_arm64.deb PIGSTY · 3.0 · 17.4KiB	PIGSTY 3.0 u24.aarch64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~noble_arm64.deb PIGSTY · 3.0 · 17.4KiB	PIGSTY 3.0 u24.aarch64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~noble_arm64.deb PIGSTY · 3.0 · 17.4KiB	PIGSTY 3.0 u24.aarch64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~noble_arm64.deb PIGSTY · 3.0 · 17.4KiB	PIGSTY 3.0 u24.aarch64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~noble_arm64.deb PIGSTY · 3.0 · 17.3KiB
u26.x86_64	PIGSTY 3.0 u26.x86_64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~resolute_amd64.deb PIGSTY · 3.0 · 17.2KiB	PIGSTY 3.0 u26.x86_64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~resolute_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.x86_64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~resolute_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.x86_64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~resolute_amd64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.x86_64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~resolute_amd64.deb PIGSTY · 3.0 · 17.3KiB
u26.aarch64	PIGSTY 3.0 u26.aarch64.pg18 : postgresql-18-pg-auth-mon postgresql-18-pg-auth-mon_3.0-3PIGSTY~resolute_arm64.deb PIGSTY · 3.0 · 17.2KiB	PIGSTY 3.0 u26.aarch64.pg17 : postgresql-17-pg-auth-mon postgresql-17-pg-auth-mon_3.0-3PIGSTY~resolute_arm64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.aarch64.pg16 : postgresql-16-pg-auth-mon postgresql-16-pg-auth-mon_3.0-3PIGSTY~resolute_arm64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.aarch64.pg15 : postgresql-15-pg-auth-mon postgresql-15-pg-auth-mon_3.0-3PIGSTY~resolute_arm64.deb PIGSTY · 3.0 · 17.3KiB	PIGSTY 3.0 u26.aarch64.pg14 : postgresql-14-pg-auth-mon postgresql-14-pg-auth-mon_3.0-3PIGSTY~resolute_arm64.deb PIGSTY · 3.0 · 17.1KiB

Build

You can build the RPM / DEB packages for pg_auth_mon using pig build:

pig build pkg pg_auth_mon         # build RPM / DEB packages

Install

You can install pg_auth_mon directly. First, make sure the PGDG and PIGSTY repositories are added and enabled:

pig repo add pgsql -u          # Add repo and update cache

Install the extension using pig or apt/yum/dnf:

Install

pig install pg_auth_mon;          # Install for current active PG version

pig

pig ext install -y pg_auth_mon -v 18  # PG 18
pig ext install -y pg_auth_mon -v 17  # PG 17
pig ext install -y pg_auth_mon -v 16  # PG 16
pig ext install -y pg_auth_mon -v 15  # PG 15
pig ext install -y pg_auth_mon -v 14  # PG 14

dnf

dnf install -y pg_auth_mon_18       # PG 18
dnf install -y pg_auth_mon_17       # PG 17
dnf install -y pg_auth_mon_16       # PG 16
dnf install -y pg_auth_mon_15       # PG 15
dnf install -y pg_auth_mon_14       # PG 14

apt

apt install -y postgresql-18-pg-auth-mon   # PG 18
apt install -y postgresql-17-pg-auth-mon   # PG 17
apt install -y postgresql-16-pg-auth-mon   # PG 16
apt install -y postgresql-15-pg-auth-mon   # PG 15
apt install -y postgresql-14-pg-auth-mon   # PG 14

Preload:

shared_preload_libraries = 'pg_auth_mon';

Create Extension:

CREATE EXTENSION pg_auth_mon;

Usage

pg_auth_mon: Monitor authentication attempts

pg_auth_mon stores authentication attempt statistics per user, tracking successful and failed logins with timestamps.

CREATE EXTENSION pg_auth_mon;

Configuration

Add to postgresql.conf:

shared_preload_libraries = 'pg_auth_mon'

Optional GUC:

Parameter	Default	Description
`pg_auth_mon.log_period`	`0`	Dump stats to Postgres log every N minutes (0=off)

Querying Authentication Stats

SELECT * FROM pg_auth_mon;

The pg_auth_mon view provides per-user information:

Column	Description
`uid`	User OID (0 for invalid/non-existing usernames)
`successful_auth_count`	Total number of successful logins
`last_successful_auth`	Timestamp of last successful login
`failed_auth_count`	Total number of failed authentications
`last_failed_auth`	Timestamp of last failed login
`hba_conflicts_count`	Count of HBA file conflicts

All login attempts with invalid usernames are aggregated into a single row with OID 0.

pg_auth_mon

Overview

Version

Build

Install

Usage

Configuration

Querying Authentication Stats

Was this page helpful?