Re: Howto: automate DB backups

2010-04-20 Thread Carl Anderson
Hey, that's great info, I didn't know there was a dropbox gem! Carl On Tue, Apr 20, 2010 at 7:55 AM, Andy Shipman a...@cllearview.com wrote: That is very cool. I adapted it slightly to download to Dropbox instead - using the dropbox gem - and now I get a backup locally as well as in the

Re: Howto: automate DB backups

2010-04-20 Thread Mooktakim Ahmed
Hi. I had a look at the Heroku's unlimited backup option. Only problem i have with it is how do i schedule it to capture every day or week etc? i'll need the cron bundle? i'm unsure about how to execute the heroku bundles:capture command from within the app. Regards, Mooktakim Ahmed On 15

Re: Howto: automate DB backups

2010-04-20 Thread Trevor Turk
On Apr 20, 9:55 am, Andy Shipman a...@cllearview.com wrote: That is very cool. I adapted it slightly to download to Dropbox instead - using the dropbox gem - and now I get a backup locally as well as in the cloud. Awesome! Thanks for posting that. On Apr 20, 10:33 am, Mooktakim Ahmed

Re: Howto: automate DB backups

2010-04-16 Thread kobi
I've just added Trevor's backup solution to my app on Heroku and works fine ... One offtopic question: do you store your backups unencrypted? If not what encrypting gems/libs you are using on Heroku? -- You received this message because you are subscribed to the Google Groups Heroku group. To

Re: Howto: automate DB backups

2010-04-15 Thread johnb
I use www.backupmyapp.com - pretty neat service, files + database. On Apr 15, 5:52 am, Trevor Turk trevort...@gmail.com wrote: I'm not too thrilled with the current backup options Heroku is offering, but I had to do something. So, I wrote up an article that shows how I'm enabling automatic

Re: Howto: automate DB backups

2010-04-15 Thread Jared Brown
Another option is to create a daily cronjob that backs up your database on Herkou. As for your code, the popular way to do this at the moment is to push your local Git repo to a site such as GitHub or CodaBaseApp. This ensures that your entire repo is backed up to a remote source. Jared On Apr

Re: Howto: automate DB backups

2010-04-15 Thread Trevor Turk
On Apr 15, 3:26 am, johnb john.bey...@gmail.com wrote: I usewww.backupmyapp.com- pretty neat service, files + database. Looks pretty cool, thanks for the link. On Apr 15, 9:04 am, Neil Middleton neil.middle...@gmail.com wrote: Side note - do people generally worry about backing up S3? They're

Re: Howto: automate DB backups

2010-04-15 Thread Jared Brown
The PostgreSQL instance in Heroku is automatically backed up to S3. Though that backup is not accessible to end users, only Heroku staff. If you want your own regular S3 accessible backup you need to use the Bundles Add-On. Jared On Apr 15, 10:04 am, Neil Middleton neil.middle...@gmail.com

Howto: automate DB backups

2010-04-14 Thread Trevor Turk
I'm not too thrilled with the current backup options Heroku is offering, but I had to do something. So, I wrote up an article that shows how I'm enabling automatic nightly PostgreSQL database backups from Heroku to Amazon S3. http://almosteffortless.com/2010/04/14/automated-heroku-backups/