Episode

Handle Azure PostgreSQL Auditing With Ease | Citus Con: An Event for Postgres 2022

Citus Con: An Event for Postgres

Video of a conference talk by Josephine Bush at Citus Con: An Event for Postgres. Abstract: Are you tired of not knowing who's changing what in your Azure PostgreSQL databases? To audit Azure Database for PostgreSQL, you can use pgaudit. With auditing, you can track changes, report on usage to auditors, or change user permissions/passwords without breaking functionality.

Josephine Bush has over 10 years of experience as a Database Administrator. Her experience is extensive and broad-based, including in financial, business, and energy data systems using SQL Server, MySQL, Oracle, and PostgreSQL. Josephine is the author of Learn SQL Database Programming published by Packt in May 2020.

Chapters

  • 00:00 - Introduction
  • 00:36 - What is auditing
  • 02:20 - Azure PostgreSQL auditing
  • 08:11 - Azure Monitor
  • 11:35 - Demo: Azure PostgreSQL auditing
  • 19:56 - Reporting on auditing data

Connect

Have feedback? Submit an issue here.