News for hackers. Stuff that matters.
Re:Ask HN: What set your hair on fire in 2012? by yesimahuman on Monday December 31, 2012 @01:59PM (#4990370)
My biggest pain in the ass this year was as simple as disk space constantly running out on our VPS servers. That, and automating postgres backups.
Re:Ask HN: What set your hair on fire in 2012? by heriC on Monday December 31, 2012 @06:17PM (#4991301)
We put all our databases on a mapped /data drive that is larger and allocated in the san for this reason. I'm not the sysadmin and the policy isn't mine, but it seems to work....
Re:Ask HN: What set your hair on fire in 2012? by themckman on Monday December 31, 2012 @03:30PM (#4990764)
How did you automate your postgres backups? I'm going to be tackling this for a client soon and have a few ideas, but would love to hear how you did it.
Re:Ask HN: What set your hair on fire in 2012? by yesimahuman on Monday December 31, 2012 @03:44PM (#4990819)
Well, first of all I mistakenly assumed our VPS backups would be sufficient, but the first step is actually dumping the database every interval you'd like. If you don't dump it, you might end up with a corrupt database should you be relying on the VPS backups.

Then, we set up a process to zip the database dump and send it off to tarsnap. We delete the backup done 30 days ago each time we run.

It works fine for us, but I much prefer using Heroku and not having to worry about it :)