Logical Decoding and Auditing
Channel: Andrea Ross
Date: 2015-03-19

Logical Decoding" is the cryptic name for a very powerful feature introduced in PostgreSQL 9.4. After a brief historical overview, we apply Logical Decoding to the specific problem of auditing a database. We also compare this solution to the more traditional approach, where triggers are created on those tables subject to auditing, evaluating in particular: - Simplicity - Performance - Separation between live data and audit data