We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Audit Logging for PostgreSQL

Formal Metadata

Title
Audit Logging for PostgreSQL
Title of Series
Number of Parts
34
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
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.