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-07 00:04:24
Message-ID: 44ADA508.8050902@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Florian G. Pflug wrote:
> Karl O. Pinc wrote:
[snip]
> Anyway, 20 years is a _long_, _long_ time. If you _really_ need
> to keep your data that long, I'd suggest you create text-only
> schema dumps, and text-only data dumps. The postgres developers
> are very concerned about backward compatibility in my experience,
> but probably _not_ for versions from 20 years ago ;-)

20 years seems pretty long, but SARBOX sets many data retention
requirements at 7 years.

In a similar vein, we are the back-office contractor for a major
toll-road consortium, and regularly get subpoenas for transaction
details as old as 5 years.

The hassle of having to go thru old tapes and extract dozens and
dozens of GB of data just to ultimately retrieve 40 records is the
hook I'm using to get PostgreSQL into our old-guard datacenter.

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

iD8DBQFEraUIS9HxQb37XmcRAuz5AJ45f+daxvsF3tAr/d0cjklGj579kACfV5JH
6AYIuDWNwcytR3m4thqAnY8=
=DDJx
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Agent M 2006-07-07 00:05:37 Re: Long term database archival
Previous Message Karl O. Pinc 2006-07-07 00:03:08 Re: Long term database archival