Create a backup process for database submissions

[pkoepke]

It would be a shame if something went wrong and we lost the record of applications. We should have a way to back up the DB.

I would consider using pg_dump to get the entire database (daily? weekly?), compress the database dump (it's text so it'll compress well), and store it in S3. We can keep all of the DB dumps on S3 with their dates in the file name so we have regular snapshots - that way if something went wrong several weeks ago and we caught it later, we can revert to the last good state.

[saxenanurag]

You could create a cron job with the pg dump command and copy the contents of the output to s3.
You can run this cron job at what ever schedule you want.