Re: Long term database archival

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Long term database archival
Date: 2006-07-12 15:59:26
Message-ID: 44B51C5E.6090903@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Karl O. Pinc wrote:
>
> On 07/12/2006 09:25:45 AM, Jan Wieck wrote:
>> On 7/6/2006 8:03 PM, Karl O. Pinc wrote:
>>
>>> On 07/06/2006 06:14:39 PM, Florian G. Pflug wrote:
>>>> Karl O. Pinc wrote:
>>>>> Hi,
>>>>>
>>>>> What is the best pg_dump format for long-term database
>>>>> archival? That is, what format is most likely to
>>>>> be able to be restored into a future PostgreSQL
>>>>> cluster.
>>>
>>>> Anyway, 20 years is a _long_, _long_ time.
>
>> The best way is to not only backup the data. With todays VM technology
>> it should be easy enough to backup a virtual disk that contains a full
>> OS and everything install for every major Postgres release.
>
> I think that that's the answer, put the whole OS and db on a
> bootable cd or DVD.

It's *highly* *unlikely* that a DVD-R will be readable in 20 years.

CSV files on DLT is a definite plan.

Also, and "archive server", with a simple CPU, not "much" RAM and
slots for 3.5" SATA drives. Populate with with large, affordable
drives as needed.

> In 20 years they'll surely be no
> problem running the whole thing from RAM so media access
> speed should not be an issue.
>
> The only thing to worry about is if the underlying architecture
> goes away entirely. I suppose if you choose something common
> they'll be an emulator.

That's how people are still running VAX/VMS...

- --
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

iD8DBQFEtRxeS9HxQb37XmcRAuHcAKCDs+AUv90ZSg2IpXAAF4q9pg7fpACgqXkq
WXHDz9yMyIUs63RDTop9lR0=
=ZKDb
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message nkunkov 2006-07-12 16:14:57 Re: Dynamic table with variable number of columns
Previous Message Sean Davis 2006-07-12 15:44:01 Re: pgsql vs mysql