Re: Long term database archival - Mailing list pgsql-general

From Michelle Konzack
Subject Re: Long term database archival
Date
Msg-id KZqi7D.A.7P.4ty2EB@t1950ct.private
Whole thread Raw
In response to Re: Long term database archival  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Am 2006-07-06 19:25:38, schrieb Ron Johnson:

> SQL was used 20 years ago, why not 20 years from now?
>
> I can't see needing data from 10 years ago, but you never know.

I have a Database (currently around 370 GByte of historical data,
exactly the last 14600 years, but most from the last 100 years)
and I want to read the backups in 20 or 30 years too...

Same for the 3,4 TByte of binary data (original docs, mp3, wav, ...)

So I am running into the same trouble, finding a realy good backup
starategy.

Oh yes, since my MAIN table of the history was exploded with around
95% of the database size, I have split them up into 10 years... which
can easyly backuped as text/plain dump.  But now I have problems
doing searches with "tsearch2" in over 1000 tables.

Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/6/61925193    67100 Strasbourg/France   IRC #Debian (irc.icq.com)


pgsql-general by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Re: How to use the full text index feature on PostgreSQL
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Tuning to speed select