Re: > 16TB worth of data question - Mailing list pgsql-general

From Jan Wieck
Subject Re: > 16TB worth of data question
Date
Msg-id 3EA9ACC9.D6DB8268@Yahoo.com
Whole thread Raw
In response to Re: > 16TB worth of data question  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: > 16TB worth of data question  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
List pgsql-general
Jeremiah Jahn wrote:
>
> On Tue, 2003-04-22 at 10:31, Lincoln Yeoh wrote:
> > How about backups? Backing up 2-16TB needs a bit more planning and design.
> The proposed solution here is to have the raid controller mirror accross
> the street to a similar system. At what point do off line backups become
> pointless?

Fine, so you have a 10 MBit link across the "street" in the budget but
nothing to buy decent server hardware? 4TB (just to be around where you
expect to be after 6 months or so) per year means an average MBit per
second ... on a second thought, the 10 MBit will probably not be enough
to satisfy peak times.

Who made that mirror proposal and where is your PITR capable backup? I
once saved a company by doing PITR. They ran an Oracle database on two
software mirrored Raid5 systems ... and the application was
misconfigured and deleted too much data (way too much).


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: David Link
Date:
Subject: Re: pq_recvbuf: unexpected EOF
Next
From: Alvaro Herrera
Date:
Subject: Re: pq_recvbuf: unexpected EOF