Backups 3.1 pg_dump

This is a small update in our series about our backup setup and schedule. You can read the previous three here: Backups Backups 2.0 DAS Edition Backups 3.0 Remote Most recently we did some database maintenance on Heroku. This is pretty straightforward as Heroku handles a lot of the heavy work for you. Periodically, we need to upgrade the database version or migrate to a larger database as needed. As part of their database package, you can set up both manual and automatic backups. These are saved to an S3 bucket associated with your database instance. Every time we need to make a change, we make a manual backing-up. There is also an automatic, nightly back-up when the server is quiet. During one maintenance phase, we were working to upgrade the database, but accidentally pressed the delete button. Luckily Heroku has a nice double confirmation so you can’t delete something that you’re not supposed to by accident. This got us worried, because had we actually deleted that database, all of…