Re: need for in-place upgrades (was Re: State of - Mailing list pgsql-general

From Ron Johnson
Subject Re: need for in-place upgrades (was Re: State of
Date
Msg-id 1063614025.11739.1204.camel@haggis
Whole thread Raw
In response to Re: need for in-place upgrades (was Re: State of  ("Williams, Travis L, NEO" <tlw@att.com>)
Responses Re: need for in-place upgrades (was Re: State of
List pgsql-general
On Sun, 2003-09-14 at 12:55, Williams, Travis L, NEO wrote:
> Not that my DB is that big..  but if it was and it contained any sort of
> financial data (something that you might want to dispute 2 years down
> the road) then I would have multiple replicated systems (which I do have
> .. but they are MSSQL) and I would also be backing the data up to an
> offsite storage.. either via tape or another box with enough storage
> space.  Your best bet is to have geographical redundancy.

There are companies (Iron Mountain comes to mind) that have *large*,
secure, temperature-controlled warehouses (an old mine, in Iron
Mountain's case) and couriers that will bring your tapes (and
other documents, for that matter) to their facilities.

You put the "stuff" to be brought off-site in a special box, with
the "recycle date" on it.  Each day/week/month, they will bring
back the "old" box(es) and take away the "new" box(es).

For a fee, or as part of the service contract, some will even
bring out boxes at odd hours of the night/weekend.

> -----Original Message-----
> From: Lincoln Yeoh [mailto:lyeoh@pop.jaring.my]
> Sent: Sunday, September 14, 2003 10:20 AM
> To: Lamar Owen
> Cc: PgSQL General ML
> Subject: Re: need for in-place upgrades (was Re: [GENERAL] State of
>
>
>
> >At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
> >'migration' server.  And I really don't want to think about
> dump/restore
> >of 100TB (if PostgreSQL actually stores the image files, which it
> might).
>
> Hmm. Just curious, do people generally backup 100TB of data, or once
> most
> reach this point they have to hope that it's just hardware failures
> they'll
> deal with and not software/other issues?
>
> 100TB sounds like a lot of backup media and time... Not to mention
> ensuring
> that the backups will work with available and functioning backup
> hardware.
>
> Head hurts just to think about it,

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"All machines, no matter how complex, are considered to be based
on 6 simple elements: the lever, the pulley, the wheel and axle,
the screw, the wedge and the inclined plane."
Marilyn Vos Savant


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: [PERFORM] best arrangement of 3 disks for (insert) performance
Next
From: Christopher Browne
Date:
Subject: Re: How to remove CLUSTERs and 'partitioning tables'