The pg_proaudit extension enables detailed logging of various security events.

pg_proaudit works in parallel with the standard PostgreSQL logging solutions (logging collector) and does not depend on them. Security event log of the pg_proaudit extension is stored separately from the server log. At the Postgres Pro Shardman startup, pg_proaudit launches a special background process to log security events.

Complete pg_proaudit documentation can be found here.