Hacker News new | past | comments | ask | show | jobs | submit login

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.



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....


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.


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 :)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: