Re: Backing up 16TB of data (was Re: > 16TB worth of - Mailing list pgsql-general

From Jan Wieck
Subject Re: Backing up 16TB of data (was Re: > 16TB worth of
Date
Msg-id 3EA9B4B3.38158E6D@Yahoo.com
Whole thread Raw
In response to > 16TB worth of data question  (Jeremiah Jahn <jeremiah@cs.earlham.edu>)
Responses Re: Backing up 16TB of data (was Re: > 16TB worth of  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: Backing up 16TB of data (was Re: > 16TB worth of  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Ron Johnson wrote:
>
> On Mon, 2003-04-21 at 13:23, Jeremiah Jahn wrote:
> > I have a system that will store about 2TB+ of images per year in a PG
> > database. Linux unfortunatly has the 16TB limit for 32bit systems. Not
> > really sure what should be done here. Would life better to not store the
> > images as BLOBS, and instead come up with some complicated way to only
> > store the location in the database, or is there someway to have postgres
> > handle this somehow? What are other people out there doing about this
> > sort of thing?
>
> Now that the hard disk and file system issues have been hashed around,
> have you thought about how you are going to back up this much data?

Legato had shown a couple years ago already that Networker can backup
more than a Terabyte per hour. They used an RS6000 with over 100 disks
and 36 DLT 7000 drives on 16 controllers if I recall correctly ... not
your average backup solution but it's possible. But I doubt one can
configure something like this with x86 hardware.


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: Tom Lane
Date:
Subject: Re: pq_recvbuf: unexpected EOF
Next
From: "scott.marlowe"
Date:
Subject: Re: Backing up 16TB of data (was Re: > 16TB worth of