-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Jeff Davis wrote: > On Mon, 2006-08-07 at 16:57 -0500, Ron Johnson wrote: >>> Attach X tape drive, put in a bunch of tapes, and just pg_dump > mdt0 >>> and you're backing up. Restore the other way around. >> Tape RAID? I like that!!!! >> >> If the disk system can keep the tape system full, though. >> > > What situation are you worried about here exactly? Backing up a large database in a limited amount of time. If the DB is large enough, and the time is short enough, then the single-reader pg_dump can not read the data fast enough (especially if other operations are pounding the disk system) to meet the time limit. Thus, the need (some times) for multiple readers. But, you say: do PITR and weekly full backups. Ok. Say you do Saturday night backups and nightly PITR backups. And the disk system barfs hard on Friday. If the Tuesday night PITR tape has a parity error, you're hosed and have lost 3 days of data. - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFE1/KsS9HxQb37XmcRAm+sAKCDRpDvzSlLpP9cFF061rCcaz4ufwCgq8Z+ dGCOEcOgIZRMzDOrLJ+kaak= =P0Q4 -----END PGP SIGNATURE-----
