PostgreSQL: Security Gets Smarter with SNI Support
Today's PostgreSQL brought us some exciting security enhancements, led by Daniel Gustafsson's major serverside SNI support implementation that enables hostname-specific SSL certificates. We also saw Michael Paquier add comprehensive SASLprep testing, Peter Eisentraut improve code quality with stricter compiler warnings, and several performance optimizations including smarter query planning for NOT IN operations.
Duration: PT4M8S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-03-19T10:02:22Z
- Audio duration: PT4M8S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Hey there, fellow code explorers! Welcome back to another episode of the PostgreSQL podcast. I'm your host, and wow, do we have some fantastic developments to dive into today from March 19th, 2026.
You know that feeling when you're working on something complex and suddenly all the pieces start clicking into place? That's exactly what's happening in the PostgreSQL world right now, and today's changes are absolutely buzzing with that energy.
Let me start with the star of the show - Daniel Gustafsson just landed some seriously impressive work on serverside SNI support for libpq. Now, if you're thinking "SNI what now?" - don't worry, I've got you covered. SNI stands for Server Name Indication, and this is a game-changer for how PostgreSQL handles SSL…
Picture this: you've got one PostgreSQL server that needs to serve multiple hostnames, and each hostname needs its own SSL certificate. Before today, that was... well, let's just say it was complicated. Daniel's implementation introduces a new config file called pg_hosts.conf that lets you specify which certificate…
This wasn't a solo effort either - Jacob Champion co-authored this work, and they had fantastic reviews from Zsolt Parragi,…
Spe…
Nearby episodes from PostgreSQL
- Performance and Quality Improvements
- Testing the Hidden Heroes
- Performance Optimizations and Better Backup Tools
- Performance Breakthroughs and Developer Experience Wins
- SQL Property Graphs Land with a Bang
- Foundation Fixes and Platform Polish
- Performance Revolution - SIMD Powers and Index Optimizations
- Performance Week - Smart Domains & Lightning-Fast Indexes