PITR (was Re: Type of application that use PostgreSQL)

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: PITR (was Re: Type of application that use PostgreSQL)
Date: 2003-10-03 19:02:42
Message-ID: 1065207762.1513.121.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2003-10-03 at 09:32, Tom Lane wrote:
> Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)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(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2003-10-03 19:04:52 Re: Postgres low end processing.
Previous Message Ron Johnson 2003-10-03 18:58:59 online vs. hot backup (was Re: Type of application that use PostgreSQL)