All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Looking for backup solution
faultyservers
Member
I've got a 1GB database in PGSQL that I need to keep backed up. I've not got much knowledge of how databases are backed up, so I thought I'd come here for some advice. I'm looking to do twice daily, maybe hourly backups, but I don't want to have a huge 1GB db dump every 12 hours from my server, so I'm looking for an incremental backup solution. I wouldn't want the backup operation to freeze my database writes.
So for the backups itself, should I do a pg_dump or something else?
And, for the host, should I go with Tarsnap, Backupsy, the R1Soft backup solution by Backupsy, or something different? I'd like to keep the costs under $10 a month, under $5 if possible.
I do apologize if this kind of question is not appropriate to ask here or if I'm being ignorant.
Comments
Well whatever procedure you follow do a tar.gz on it to save space. Thats all I can tell
Thanks, I'll keep that in mind.
http://www.postgresql.org/docs/9.1/static/continuous-archiving.html
Does that meet your needs as a solution (minus the hardware part)? seems a lot more space efficient and responsive for point-in-time recovery.
Here's an R1Soft free trial:
http://www.webhostingtalk.com/showthread.php?t=1469157
You can then test it to see if it works for your application.
I use Tarsnap and absolutely LOVE it, it's cheap and so easy to use.