Re: Long term database archival

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Long term database archival
Date: 2006-07-07 01:16:24
Message-ID: 44ADB5E8.4050008@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Agent M wrote:
[snip]
>
> 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.

Ingres has been around for longer than you think: about 20 years.

So, the data has been converted one time in 35 years. Pretty damned
stable if you ask me.

Another example: the on-disk structure of RDB/VMS has remained
stable ever v1.0 in 1984. That means that upgrading from
major-version to major version (even when new datatypes and index
structures have been added) is a quick, trivial process.

Companies with lots of important data like that.

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

ASCII will be here in 20 years. So will EBCDIC. As will UTF.

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFErbXoS9HxQb37XmcRAk8OAJ0bUv1kk7T0Q273jGkFVwy5TnHG9wCdFDI8
9ebDZyxwiIGwfmISbJpGWBs=
=DfBk
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2006-07-07 01:39:09 Re: Long term database archival
Previous Message Richard Broersma Jr 2006-07-07 01:07:17 Re: Long term database archival