PostgreSQL: Standby Inspection Guards and psql Interrupt Fix
Pageinspect and pgstattuple now reject temporary and unlogged relations during recovery with clear errors instead of missing-file failures, while psql now stops non-interactive scripts on Ctrl+C during COPY and prompt input. A SASLprep comment correction rounds out the day.
Duration: PT2M13S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-11-09T14:03:28Z
- Audio duration: PT2M13S
Transcript excerpt
This excerpt keeps the crawler page concise. Listen to the episode or use the RSS feed for the full update.
It's November 9th, 2026, welcome to your PostgreSQL briefing.
The main pattern today is tighter guardrails for edge cases that used to fail confusingly, with two contrib modules getting the same recovery fix, plus a long-standing interrupt inconsistency in P S Q L.
First, inspection on standbys. Temporary and unlogged tables have no usable data on a standby, apart from the initialization fork of an unlogged table. But functions in page inspect and P G stat tuple tried to open them anyway and died with a low-level missing file error. Two commits, 0091c24 and 553262a, now reject…
Second, script interruption. In non-interactive P S Q L scripts, Control C during a running query aborts the whole script with exit code three. But while waiting for copy from standard input, or prompt and password input, it only cancelled that one command and kept running the rest of the script — so a copy followed…
Finally, a small correctness fix in S A S L prep documentation, correcting a Unicode code point reference in a comment from U 00 A 0 to U 0020.
What's next: expect cleaner standby tooling behavior and more predictable automation, worth a quick check of replica health checks and scripted loads.
Nearby episodes from PostgreSQL
- Silent Correctness and Upgrade Reliability Fixes
- Stats, Planner and Replication Crash Fixes
- Silent Wrong-Result Fixes and Worker Reliability
- Composite Type Security Hardening
- Weekly Recap - Reverts, Query Fixes, and Standby Safety
- JSON Revert and CI Overhaul
- Window Hangs, Planner Crashes and Replication Hardening
- Silent Correctness Fixes for Backups, Sorting and JSON