SuperFola@programming.dev 1 year ago
There is still the journal you could use to recover the old state of your database. I assume you commited after your update query, thus you would need to copy first the journal, remove the updates from it, and reconstruct the db from the altered journal.
This might be harder than what I’m saying and heavily depends on which db you used, but if it was a transactional one it has to have a journal (not sure about nosql ones).
drekly@lemmy.world 1 year ago
It is after the event that I find that postgres’ WAL journalling is off by default 🙃