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