Last year, a financial services team I was working with had a nightmare scenario: a regulatory audit required them to prove exactly what their system showed on a specific Tuesday six months ago. Not what the data currently says. What it said then.

Their production Postgres had the current state. Their audit table had some breadcrumbs. Their...