Submitted by lloydalbin on Wed, 01/17/2018 - 16:07
A shadow table is an table that is read and written by a trigger function and contains data similar to (in the same format as) its primary table, which is the table it's "shadowing" along with a few extra fields so that you can time travel the shadow table and know who did what and when. In this presentation we will cover traditional Shadow Tables which works with all current version of Postgresql and all cloud providers vers PGAudit which required Postgres 9.5 or newer.
- Shadow Tables:
- Writing a Shadow Table Function
- Attaching the Function via a Trigger to a Normal Table
- Time Traveling your Shadow Table
- Capturing DDL Changes
- PGAudit:
- Compiling PG Audit
- Auditing Tables
- Auditing DDL
- Pros & Cons
- Cloud Providers
- Amazon RDS Postgresql
- Amazon Aurora Postgresql
- Microsoft Azure Postgresql
- Google Postgresql
- Other Shadow Table Projects
Presentation will be posted here soon.