Hi, On Wed, Dec 10, 2008 at 12:01 AM, Sridhar Dhanapalan <[email protected]> wrote: > Are there any good tools to backup/restore databases, with versioning, > delta storage and so on just like you get with rdiff-backup? I'm > currently running mysqldump and pg_dump in a shell script via cron > job, but surely there's a better way. I've seen a few tools, but what > do people on the list recommend?
If you are using LVM - http://lenz.homelinux.org/mylvmbackup/ (15gb db snapshot takes roughly 2-3 seconds) I believe there is a similar script floating around for PgSQL, however I have not used it. http://www.postgresqlforums.com/wiki/Backup_&_Recovery also has some docs on doing point in time recovery. -- Paul De Audney -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
