--- title: Best PostgreSQL posts — May 2026 | daily.dev description: The most upvoted PostgreSQL posts from May 2026, curated by the daily.dev community. canonical: https://daily.dev/sources/postgres/best-of/2026/05 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/postgres/best-of/2026/05 og:type: website og:site_name: daily.dev og:title: Best PostgreSQL posts — May 2026 | daily.dev og:description: The most upvoted PostgreSQL posts from May 2026, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of PostgreSQL — May 2026 1. 1 [](https://daily.dev/posts/pgformatter-v5-10-has-been-released-qtlapjvbq "pgFormatter v5.10 has been released") Article PostgreSQL · 18w pgFormatter v5.10 has been released pgFormatter v5.10 has been released, bringing several formatting improvements and bug fixes for this SQL and PL/pgSQL code formatter dedicated to PostgreSQL. Available as a CLI or CGI program, pgFormatter supports SQL-92 through SQL-2011 standards plus PostgreSQL-specific keywords. The full changelog is available on GitHub. 94 2 2. 2 [](https://daily.dev/posts/pgedge-launches-ai-dba-workbench-an-ai-co-pilot-for-database-administrators-kurfl5drb "pgEdge Launches AI DBA Workbench, an AI Co-Pilot for Database Administrators") Article PostgreSQL · 19w pgEdge Launches AI DBA Workbench, an AI Co-Pilot for Database Administrators pgEdge has launched the AI DBA Workbench, an open-source AI-powered monitoring and management tool for PostgreSQL. It features an integrated assistant called Ellie that continuously monitors query performance, vacuum activity, connection health, WAL throughput, and replication lag. A three-tier anomaly detection system combines statistical baselines, vector similarity pattern matching, and AI classification to catch issues early. Ellie can run EXPLAIN ANALYZE on slow queries, inspect schemas, and walk DBAs through diagnostic workflows, providing specific SQL fixes for review before application. The tool supports any Postgres 14+ database including Amazon RDS and Supabase, is fully open source on GitHub, and is also available as part of pgEdge Enterprise Postgres. 44 3. 3 [](https://daily.dev/posts/barman-3-18-0-released-guk4mu91y "Barman 3.18.0 Released") Article PostgreSQL · 16w Barman 3.18.0 Released Barman 3.18.0 has been released by EnterpriseDB, introducing experimental block-level incremental backups for cloud storage (S3, Azure Blob, GCS) that reduce storage costs and upload times by only sending changed data blocks. A new backup\_method=local-to-cloud option brings cloud backup directly into the main Barman CLI, moving toward deprecating the standalone barman-cloud-\* scripts. The release also adds a new barman cloud-wal-archive command for WAL archiving to cloud object storage with multiple compression options, LZ4 compression support for cloud backups, S3 addressing style control, a custom restore command option, Python 3.14 compatibility, and a fix for a WAL archiving file handle leak. 28 4. 4 [](https://daily.dev/posts/plpgsql-wrap-v1-0-released-wad4wz7gw "plpgsql_wrap v1.0 released") Article PostgreSQL · 16w plpgsql\_wrap v1.0 released plpgsql\_wrap v1.0 is a new PostgreSQL extension that obfuscates PL/pgSQL stored procedure source code using AES-256-GCM encryption, storing the encrypted blob directly in pg\_proc.prosrc. It works identically to standard LANGUAGE plpgsql but makes source code unreadable without the encryption key. pg\_dump output is also obfuscated yet fully restorable. A built-in unwrap function allows recovery of plain text using the key. Compatible with PostgreSQL 12 and above, it targets use cases where sensitive business logic must be protected when delivering code to third parties. 11 [See all PostgreSQL archives](/sources/postgres/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/sources/postgres/best-of/2026/05#page","url":"https://daily.dev/sources/postgres/best-of/2026/05","name":"Best PostgreSQL Posts — May 2026","description":"The most upvoted PostgreSQL posts from May 2026, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/postgres/best-of/2026/05#items","numberOfItems":4,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/pgformatter-v5-10-has-been-released-qtlapjvbq","name":"pgFormatter v5.10 has been released"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/pgedge-launches-ai-dba-workbench-an-ai-co-pilot-for-database-administrators-kurfl5drb","name":"pgEdge Launches AI DBA Workbench, an AI Co-Pilot for Database Administrators"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/barman-3-18-0-released-guk4mu91y","name":"Barman 3.18.0 Released"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/plpgsql-wrap-v1-0-released-wad4wz7gw","name":"plpgsql_wrap v1.0 released"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"PostgreSQL","item":"https://daily.dev/sources/postgres"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/postgres/best-of"},{"@type":"ListItem","position":5,"name":"May 2026"}]}]} ```