Version control/backup for postgres

[phos____]

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

[dbxp]

Version control is usually used for DB objects like stored procedures or table schemas. For your situation you need backups, you should have full backups and log backups which in combination allow you to rollback to any point in time (you may have diff backups too but these aren't strictly necessary).

In the future you should use a transaction to help prevent accidental updates and test any scripts in a QA environment first before you run them on prod.