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

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.

This session will include an overview, how to set up pgaudit, and a quick demo. Auditing is a key part of any proper database setup, and with this session, you can be an auditing pro in no time!

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.

► Video bookmarks:
⏩ 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

✅ Learn more:

📌 Let’s connect:

#CitusCon #PostgreSQL #AzureDBPostgres

[inzheneher]

Not many videos on YouTube cover this topic, so thank you so much for the excellent explanation! The content is still super relevant.

[aeroluis]

Josephine, thank you for this information, it is very valuable and not a lot out there about this in youtube. Really appreciate! I wanted to ask something. If you perform a default Azure Database for PostgreSQL installation (Flexible Server), do you need to install and configure pgaudit plugin in order to have the logs shown in 7:41 (DDL and Role Logs)? or lets say, instead of that, if I just configure Diagnostic Settings to send all logs (selecting "allLogs" option) to be sent to a storage account for example.. will I be able to see those same DDL and Role logs? Thanks!