Postgresql has PITR backup. http://www.postgresql.org/docs/9.1/static/continuous-archiving.html http://www.postgresql.org/docs/9.1/static/continuous-archivi...

Postgresql has PITR backup. http://www.postgresql.org/docs/9.1/static/continuous-archiving.html http://www.postgresql.org/docs/9.1/static/continuous-archivi... This allows you to go back in time to an earlier snapshot of your data, without having to do a full database backup. Unfortunately, it's still a pain to setup, even with tools like https://github.com/greg2ndQuadrant/repmgr https://github.com/greg2ndQuadrant/repmgr. Wish there was more convention over configuration. (I use Heroku's WAL-E to backup the data to S3. https://github.com/heroku/WAL-E https://github.com/heroku/WAL-E)