Database backups for a Django project

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.

backups postgresql

asked 10 Oct '12, 22:02

redseam
41●2●5
accept rate: 0%

One Answer:

active answers oldest answers newest answers popular answers

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.

permanent link

answered 10 Oct '12, 22:08

johns
5.4k●4●12
accept rate: 23%

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

postgresql ×109
backups ×6

question asked: 10 Oct '12, 22:02

question was seen: 3,541 times

last updated: 10 Oct '12, 22:08

Database backups for a Django project

Follow this question

Related questions