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)