I recently executed an incorrect UPDATE query (yes, ouch) and turns out my company doesn't have any recent backup for me to restore the data. Are there any version control tools or automated backup techniques that I can use so this doesn't happen again

CodePudding user response：

Liquibase, while it mainly oriented on managed schema-changes, it can be (TBT!) (with the same concept of roll-backed changesets) used for data-changes

CodePudding user response：

Version control tools and automated backup techniques are different things

Regarding the automated backup tools here are some examples :

• pgbarman : We use it in our organization
• pgbackrest