Re: Dump format for long term archiving.

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: brian <brian(at)zijn-digital(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Dump format for long term archiving.
Date: 2008-03-13 23:19:06
Message-ID: b35603930803131619t78fb8b66tc98290d19091a3a0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 14/03/2008, brian <brian(at)zijn-digital(dot)com> wrote:
> The version you dump it from is unlikely to be difficult to find ten
> years from now. I'd just make sure to append the pg version to the
> archive so it's obvious to any future data archaeologists what's needed
> to breathe life back into it.
Let me play devils advocate here ...

While the source for PG 8.x will be around there's no guarantee
that future enhancements to gcc (or whatever commercial compiler
you'll be using) will still allow you to compile it w/o potentially long-
winded modifications to the original source.

My gut-feeling is that trying to keep data as a "moving target", with
some redundancy in terms of storage and hardware, and updating
the appropriate means every few years (financial life-cycle?) is a
sensible method :}

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dawid Kuroczko 2008-03-13 23:20:51 Re: Trigger to run @ connection time?
Previous Message Adrian Klaver 2008-03-13 23:12:47 Re: postgre vs MySQL