Audit Logging for PostgreSQL
David Steele is Principal Architect at Crunchy Data, the Trusted Open Source Enterprise PostgreSQL Leader. He has been actively developing with PostgreSQL since 1999.
David loves taking on big data challenges. Before Crunchy Data he was Data Architect at Resonate, an online media company using PostgreSQL to drive its transactional and data warehousing databases. Before that, he helped drive global mobile text messaging at Sybase365.
David's current project is pgBackRest, which will be the subject of this talk.
Many of us have had auditors ask for information that is difficult to provide with core PostgreSQL. Who made changes to table X in the last six months? When was table Y's DDL last modified and was that during a maintenance window? Who has viewed table Z? An extension available for PostgreSQL 9.5, pgAudit, seeks to answer these and many other questions by providing more detailed logging and finer control of what is logged than is currently available. This talk will examine pgAudit design and usage before presenting practical examples.
- 50 min
- PGConf US 2017 [PgConf.US]