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

From Agent M
Subject Re: Long term database archival
Date
Msg-id 8b05f7ab4247b5427b56d2dae56974cb@themactionfaction.com
Whole thread Raw
In response to Re: Long term database archival  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: Long term database archival  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Long term database archival  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
> I am not to sure of the relevance, but I periodically worked as a
> sub-contractor for an
> Oil-producing Company in California.  They were carrying 35 years of
> data on an Alpha Server
> running Ca-Ingres.  The really bad part is that hundreds and hundreds
> of reporting tables were
> created on top of the functioning system for reporting over the years.
>  Now nobody know which
> tables are relevant and with are redundant and or deprecated.
>
> Also year after year, new custom text file reports were created with
> procedural scrips.  The load
> on the server was such that the daily reporting was taking near taking
> 23 hours to complete.  And
> the requests for new reports was getting the IT department very
> worried.

But the data from 35 years ago wasn't stored in Ingres and, if it's
important, it won't stay in Ingres. The data shifts from format to
format as technology progresses.

It seemed to me that the OP wanted some format that would be readable
in 20 years. No one can guarantee anything like that.

-M

¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬
AgentM
agentm@themactionfaction.com
¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬ ¬


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Long term database archival
Next
From: Michael Fuhr
Date:
Subject: Re: How do I revoke CREATE TABLE and other privileges?