I do a nightly backup, and I see an almost minimal hit on performance. Sure the machine load goes from 0.5 to 2 for a couple hours, but the database is still plenty responsive to me.
I'm with Marc on this one. The Postgresql feature of PITR is awesome. With PITR you can go to a weekly backup and just save the PITR files through the week. Restore may take a bit longer, but probably not much and you can restore to 1m before the failure. I would like a mirrored setup, but honestly, there are possible problems there too as others mentioned. My eventual goal is that I'll be using something like dbmail-export, dump out users email into mbox format in the old standby style of Unix tar levels (daily, weekly, monthly). This is so I can also delete old mail and keep an archive of it just in case that one CEO desperately needs that 3 month old piece of spam about a million dollar offer from Nigeria. -- David A. Niblett | email: [EMAIL PROTECTED] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Dirix Sent: Thursday, January 25, 2007 3:14 AM To: DBMail mailinglist Subject: Re: [Dbmail] backup database, how often? > If you use MySQL, you have the binary log. That allows you restore any > changes done after the last full backup(or which point in time ever). > The binary logfile can be saved easily every hour. It can also get > moved to another machine, after you have cycled the logfiles. PostgreSQL has pretty much the same feature, you can use WAL (Write Ahead Logging) segments and move them automatically to a different location. The if needed do a PITR (Point in Time Recovery) as described in the documents. Works pretty neat! Marc _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
