PostgreSQL: Row Security and Replication Safeguards
Two reliability fixes restore silent protections for row-level security and replication slots, alongside small corrections to shared memory, reset-wal, and vacuum documentation. The pattern is preventing the system from quietly dropping safety checks.
Duration: PT2M24S
Episode overview
This episode is a short developer briefing from PostgreSQL.
It explains recent repository work in plain language.
- Show: PostgreSQL
- Published: 2026-09-30T13:03:54Z
- Audio duration: PT2M24S
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 September 30th, 2026 — this is your PostgreSQL briefing.
The pattern today is restoring silent safeguards, with two fixes stopping the system from quietly dropping row security and replication protections.
First, correctness under row-level security and logical replication. In commit D C A 6 A 9 E, self-join elimination is now blocked when range table entries use different check-as-user roles. The optimizer had merged references to the same table without comparing their security qualifications, risking lost filters…
Related in spirit is commit 9 5 1 0 A 8 2 on replication slot invalidation. The slot release path unconditionally copied process status flags using an offset that is only valid for regular backends. Checkpointer or startup doing invalidation could therefore overwrite the wrong entry, notably losing the…
Second, small regressions from recent cleanups. Commit C 7 1 2 B 0 D fixes single-user mode to allow unknown-size shared memory attaches after startup by testing whether shared memory is initialized, not whether running under the postmaster. Commit 1 F 7 0 1 3 F restores the reset-wal tool's documented behavior…
Finally, documentation catches up to…
Nearby episodes from PostgreSQL
- Repack Data Loss Fix and Test Stability
- Replication Race, Lock Timing, and Log Cleanup
- Weekly Recap - Hardening Privileges and Edge-Case Reliability
- pg_dump Tar Restore Fix
- Privilege Fixes and Stats Restore Repairs
- Repack, Vacuum and Replication Hardening
- Snapshot and Visibility Map Correctness
- Concurrency Race Fixes and Replay Relief