Re: Practical maximums (was Re: PostgreSQL theoretical

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