How to enable Audit Trail on PostgreSQL

Question

I am currently using PostgreSQL 9.1. I want to enable pg Audit Trail.

Can someone please help me with that as I am totally new on this thing.

Answer 1

There is no audit functionality available by default in the opensource postgresql database. You can check out edb_audit from Enterprisedb postgres for creating audit logs.

Or check out the pgAudit extension for the opensource version.