Re: Practical maximums (was Re: PostgreSQL theoretical

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Practical maximums (was Re: PostgreSQL theoretical
Дата
Msg-id 44D7F2AD.7000206@cox.net
обсуждение исходный текст
Ответ на Re: Practical maximums (was Re: PostgreSQL theoretical  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Practical maximums (was Re: PostgreSQL theoretical  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
-----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-----

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Disabling and enabling constraints and triggers to make pg_restore work
Следующее
От: Sundar Narayanaswamy
Дата:
Сообщение: Re: Autovacuum help..