PostgreSQL: Major Auth Upgrade and Subscription Revolution
A big day for PostgreSQL with 6 substantial commits focusing on authentication improvements and database connectivity. Jacob Champion delivered a major OAuth authentication upgrade with backward-compatible versioning, while Jeff Davis revolutionized subscription management by integrating foreign servers. Plus important fixes for pg_dumpall and query parsing improvements.
Duration: PT4M24S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-03-07T11:05:22Z
- Audio duration: PT4M24S
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 developers! Welcome back to another episode of the PostgreSQL podcast. I'm your host, and wow, do we have an exciting day to dive into! March 7th brought us six fantastic commits that show the PostgreSQL team is really pushing the boundaries of what's possible with database connectivity and…
Let me start with the absolute standout commit today - Jacob Champion just delivered something really special for OAuth authentication in libpq. Now, I know authentication can feel like one of those "boring but necessary" topics, but stay with me because this is actually fascinating from a design perspective.
Jacob introduced what they're calling PQAUTHDATA_OAUTH_BEARER_TOKEN_V2, and here's why this matters. The team ran into a really interesting problem - they wanted to add new features to their OAuth system, but they discovered that the usual approach of just checking compile-time macros doesn't work for plugins. Why?…
So Jacob came up with this elegant solution - instead of breaking everything, they created a v2 version that works like inheritance in object-oriented programming. Applications can check for v2 first, fall back to v1 for compatibility, and everyone's happy.…
But…
…