I have created a Django app for a client. He is very concerned about his database. He has asked that I create nightly backups of his database in 3 different locations - one of those can include Webfaction's backup. He thought "cloud" storage would be a good idea.
I just wanted to bounce this idea off of some experts. Does anyone here have expertise in this area. How would you go about creating extra postgres DB backups nightly?
This is a very small database by the way and I don't anticipate it growing very big.
asked Oct 10 '12 at 22:02
This is a great idea. The simplest way would be to pick a provider and than write a script which would be executed daily in cron, the script would make the DB dump, check it for filesize to make sure the dump worked, than upload to the 3rd party servers.
answered Oct 10 '12 at 22:08