postgres=# select * from sessions where video_id = '_Fp-llPPSrE';
Agentic Hacking Postgres
End-to-end tests for archive-fed logical decoding and pause/resume behavior.
session summary
The session refined logical decoding from an archive-fed physical standby as a recoverable, production-independent pipeline: after losing the decoding node, a consumer can restore another standby at the acknowledged LSN and tolerate overlap. They reviewed the three-patch implementation and TAP test, found registration and naming issues, debated lock structure, and judged the code ready for discussion after fixes. They then specified an end-to-end WAL-G test with catalog churn, paused consumption, catch-up, and a final marker.
timecodes
- Recoverable decoding after a standby is lost
- Archive-fed WAL decoding without touching production
- Naming the feature: logical decoding from archive
- Reviewing the three-patch implementation
- TAP test registration and test readability
- Reviewing pause-on-conflict code and locking
- Patch readiness and concrete submission fixes
- Designing an end-to-end WAL-G recovery test