11 points fdeth 3 days ago 2 comments

Hey everyone, a few months ago, after recovering from a Clade-generated bug, I was thinking to myself “wouldn’t it be nice if prod DB writes were easy to roll back”. I’ve put something together: it’s a two-container deploy plus a CLI tool. It’s far from being production ready, so please be gentle. All feedback welcome!

The nitty gritty: https://eterdb.com/tech

GitHub: https://github.com/eterdb/eterdb

NewJazz 2 days ago | parent

Uh, pitr is a thing in many many postgresql management layers.

https://pgbarman.org/

fdeth 2 days ago | parent

Yes, but PITR is not surgical, you can’t easily undo just the faulty transactions.