Postgres audit trails

TL;DR: Why and what options do we have to do audit trails in Postgres

Auditing is coming!

Motivation

In a very high-level view, audit trails respond to the questions of who, what and when access to the database.

Probably it’s a duty if your business has to pass an audit or it has compliance issues.