PITR (was Re: Type of application that use PostgreSQL) - Mailing list pgsql-general

From Ron Johnson
Subject PITR (was Re: Type of application that use PostgreSQL)
Date
Msg-id 1065207762.1513.121.camel@haggis
Whole thread Raw
In response to Re: Type of application that use PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PITR (was Re: Type of application that use PostgreSQL)  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Fri, 2003-10-03 at 09:32, Tom Lane wrote:
> Shridhar Daithankar <shridhar_daithankar@persistent.co.in> writes:
> > Peter Childs wrote:
[snip]
> All that we basically need for PITR is to provide management code that
> lets old WAL segments get archived off to tape (or wherever) rather than
> deleted, plus some kind of control that lets the roll-forward process be
> stopped at the desired point-in-time rather than necessarily running to
> the end of the available WAL data.  This isn't a trivial amount of code,
> but there's no great conceptual difficulty either.

Hope everybody realizes that the amount of WALs will get very big
on active-update systems...

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

Great Inventors of our time:
Al Gore -> Internet
Sun Microsystems -> Clusters


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: online vs. hot backup (was Re: Type of application that use PostgreSQL)
Next
From: "scott.marlowe"
Date:
Subject: Re: pg_restore takes ages