| From: | "Karl O(dot) Pinc" <kop(at)meme(dot)com> |
|---|---|
| To: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org, thm(at)duke(dot)edu |
| Subject: | Re: Long term database archival |
| Date: | 2006-07-07 00:03:08 |
| Message-ID: | 1152230588l.4335l.4l@mofo |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2006-07-07 00:04:24 | Re: Long term database archival |
| Previous Message | Florian G. Pflug | 2006-07-06 23:18:22 | Re: Best way to deal with quote_literal issue? |