POSETTE 2026

We hosted POSETTE: An Event for Postgres 2026 in June! This year marked our 5th annual event featuring 50 speakers and a total of 44 talks. PostgreSQL developers, contributors, and community members came together to share insights on topics covering everything from AI-powered applications to deep dives into PostgreSQL internals. If you missed it, you can catch up by watching the POSETTE livestream sessions.  If this conference sounds interesting to you and want to be part of it next year, don’t forget to subscribe to POSETTE news.

Features 💡

Chaos Studio Workspaces for Azure Database for PostgreSQL Flexible Server – Public Preview

Chaos Studio Workspaces now support Azure Database for PostgreSQL Flexible Server in Public Preview. You point a Workspace at a subscription or resource group, and Chaos Studio discovers your Flexible Server instances and recommends a PostgreSQL zone-down failover Scenario. The Scenario requires a Flexible Server with High Availability enabled. Running the Scenario simulates an availability-zone outage, drives an HA failover, and produces a Scenario report of exactly what happened. 

Read more here: https://aka.ms/ChaosStudioPostgreSQL 

Try it today: https://aka.ms/chaos-portal 

Microsoft Defender Security Assessment for Azure Database for PostgreSQL - General Availability

Microsoft Defender security posture assessments for Azure Database for PostgreSQL Flexible Server are now generally available. Built-in assessments continuously evaluate PostgreSQL configurations against PostgreSQL-specific security best practices, helping identify vulnerabilities and misconfigurations with actionable remediation guidance. Customers can use these assessments to strengthen their security baseline, prioritize remediation efforts, and support compliance requirements. 

Assessments are automatically available for servers already protected by Microsoft Defender for Cloud Security Posture Management (CSPM), with no additional setup required. An initial set of assessments is available today, with additional coverage planned for future releases to help strengthen the security posture of PostgreSQL workloads.

Read more here: Microsoft Defender for Cloud - Azure Database for PostgreSQL | Microsoft Learn 

DROP CAST Support added

Custom casts can be useful when applications need to convert between data types in a way that matches their business logic or migration requirements.  

Previously, while you could create custom casts, it wasn’t possible to drop them once they were no longer needed. With this update, you can now use the PostgreSQL DROP CAST command to clean up unused or obsolete casts, making it easier to manage schema customizations over time. 

Example: 

CREATE CAST (bigint AS text) WITH INOUT; 
… 
DROP CAST IF EXISTS (bigint AS text); 

Latest PostgreSQL minor versions: 18.4, 17.10, 16.14, 15.18, 14.23

Azure Database for PostgreSQL now supports the latest PostgreSQL minor versions: 18.4, 17.10, 16.14, 15.18, and 14.23. These updates are applied automatically during planned maintenance windows, helping keep your databases current with the latest PostgreSQL community fixes and reliability improvements, with no manual action required. 

This release includes fixes across query correctness, planner behavior, replication, backup and restore tooling, logical replication, foreign data wrapper behavior, and timezone data, improving overall stability and correctness of database operations. 

For details about the minor release, see the PostgreSQL announcement.

Azure PostgreSQL Learning Bytes 🎓

Generate a pgBadger report from Server Logs

Need a quick workload readout from PostgreSQL logs? Use pgBadger with Azure PostgreSQL Server Logs. 

Fast path: Server logs → Download '.log' files → Generate pgBadger report 

Before collecting logs, set log_line_prefix in Server parameters:

%m user=%u db=%d pid=%p: 

Then enable Server logs > Capture logs for download, download the .log files for the time window you want to analyze, place them in a local folder, and run: 

FOLDER=<logs-folder-name> 
 
pgbadger -f stderr \ 
  --prefix '%m user=%u db=%d pid=%p:' \ 
  ./$FOLDER/*.log \ 
  -o ./$FOLDER/pgbadger-report.html 

Open the generated report: 

start ./$FOLDER/pgbadger-report.html 

This gives you a quick HTML report for query activity, connection patterns, events, lock waits, and workload spikes - without setting up a storage account, BlobFuse mount, or JSON extraction pipeline. 

💡Tip: Start with one or two hourly log files first. Confirm the report looks right, then expand the log analysis window. 

Learn more: Log Insights in Minutes: A Simpler pgBadger Workflow