Re: Long term database archival - Mailing list pgsql-general

From Karl O. Pinc
Subject Re: Long term database archival
Date
Msg-id 1152230588l.4335l.4l@mofo
Whole thread Raw
In response to Re: Long term database archival  ("Florian G. Pflug" <fgp@phlo.org>)
Responses Re: Long term database archival  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-general
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.

Yes, but our data goes back over 30 years now
and is never deleted, only added to, and I
recently had occasion to want to look at a
backup from 1994-ish.  So, yeah we probably do
really want backups for that long.  They
probably won't get used, but we'll feel better.

Thanks.

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein


pgsql-general by date:

Previous
From: Agent M
Date:
Subject: Re: Long term database archival
Next
From: Richard Broersma Jr
Date:
Subject: Re: Long term database archival