search

swan4kids / swan4kids.com

website
2 stars 1 forks source link

Automatic database backup #8

Closed carols10cents closed 13 years ago

carols10cents commented 13 years ago

I don't know if a Refinery engine exists for this, or a Rails thing or a Heroku thing would be best, but it would be nice to have the database backed up automatically (e.g. weekly email to somewhere?) so that SWAN doesn't have to worry about it.

seanmarcia commented 13 years ago

I read something about this recently, let me see if I can find the info.

anthias commented 13 years ago

SeanMarcia, are you taking this ticket?

seanmarcia commented 13 years ago

Sure! Still researching but hopefully I will have a good solution soon.

seanmarcia commented 13 years ago

After much more research than I needed to do it looks like this issue is moot. With heroku we can configure automatic backups of the database with the pgbackup addon: http://addons.heroku.com/pgbackups Here is the dev center info: http://devcenter.heroku.com/articles/pgbackups We just need a verified account and then we can add the service. The service is free, the account just needs verification.

carols10cents commented 13 years ago

Awesome, thanks for doing the research on this!! :heart: :heart: :heart: I went ahead and verified my account, chose one of the free options for pgbackup, and created a snapshot of the current database. This makes me feel a lot better.