PostgreSQL: Version 19's Growing Pains
Several fixes this cycle address gaps left by new PostgreSQL 19 features—subscription ownership, sequence replication, and recovery monitoring—alongside a shared-resource leak in injection points that could exhaust waiter slots.
Duration: PT2M39S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-07-23T13:04:43Z
- Audio duration: PT2M39S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good day. It's July 23rd, 2026, and this is your PostgreSQL briefing.
The clearest thread today: features introduced in version 19 are getting hardened as real-world edge cases surface.
Start with subscriptions. Fujii Masao's fix, commit 1c9c358, closes a gap where changing a subscription's owner didn't re-validate the connection info for servers requiring a password. Ownership transfer would succeed, then quietly fail later when a worker tried to connect. It's now checked upfront, and it's…
Related: Amit Kapila's commit, 1a8c172, tackles sequence synchronization against older publishers. Since sequence replication depends on a field only version 19 publishers return, older publishers triggered a confusing, repeating error instead of a clear failure. Now Postgres checks the publisher's version upfront…
Rounding out the version-19 cleanup, Fujii Masao also improved documentation for pg_stat_recovery, commit 937db82 — clarifying that the view can return zero or one row, not always one, and correcting how replay position fields should be interpreted. Small wording fixes, but important for anyone building monitoring…
Second theme: resource cleanup under error conditions. Michael…
Nearby episodes from PostgreSQL
- Polish Pass on Messages and Edge Cases
- Cleaning Up After Recent Features
- Closing the Gaps Between Correctness and Convention
- Weekly Recap - Correctness Fixes and Late-Beta Caution
- Five Bug Fixes, One Pattern of Care in Correctness
- Late-Beta Cleanup and Correctness Fixes
- Silent Corruption, Loud Fixes
- Visibility Map Bug Fixed, Old Baggage Dropped