Can I rollback a transaction I’ve already committed? (data loss)
No, you can’t undo, rollback or reverse a commit. STOP THE DATABASE! (Note: if you deleted the data directory off the filesystem, do NOT stop the database. The following advice applies to an accidental commit of a DELETE or similar, not an rm -rf /data/directory scenario). If this data was important, STOP YOUR DATABASE NOW … Read more