PostgreSQL: Compressed Backup Integrity and Planner Fixes
Backup and restore tools were silently accepting truncated compressed data and hanging on multi-part gzip archives. Three related fixes restore truncation checks and streaming resets, alongside late-cycle corrections to plan advice and execution ahead of version 19.
Duration: PT2M20S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-10-09T13:03:41Z
- Audio duration: PT2M20S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
Good morning, it's Friday, October 9th, 2026, and this is your PostgreSQL developer briefing.
The big signal today is backup trust. Multiple fixes close gaps where compressed backups could look valid when they weren't, or hang during verification.
First, truncation detection. Commit e41b01f fixes pg verify backup missing truncated compressed tar backups for Z standard, L Z 4 and gzip. The decompressors weren't confirming the final frame or stream actually finished, so a cut-off file could pass. A companion fix, commit e01fc63, does the same for pg restore on…
Related, commit f884f35 fixes hanging, not just missed errors. When pg base backup writes write-ahead log tarballs with gzip, it writes a series of gzip members. The streaming decompressor didn't reset between members, so pg wall dump would stall, and pg verify backup which depends on it would hang. It now resets…
Second theme is last-minute planner corrections ahead of version 19. Three commits from Robert Haas repair the new plan advice feature around consolidated Append nodes. One carries child append sets through node elision, breaking A B I on master; another stops partition-wise scans being mislabeled as ordinary; a…
Finally…
Nearby episodes from PostgreSQL
- Parallel Material Storage Reporting
- Weekly Recap - Correctness Fixes and Backup Trust
- Index Scan Correctness Fixes
- Planner Correctness and Startup Lifecycle Fixes
- WAL Reliability and Failover Slot Fixes
- B-Tree Deduplication Fix and Planner Corrections
- Planner Correctness Cluster
- Safer Vacuum Pauses and Quiet Correctness Fixes