Re: Mirroring with WAL? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Mirroring with WAL?
Date
Msg-id 24939.1003429471@sss.pgh.pa.us
Whole thread Raw
In response to Re: Mirroring with WAL?  ("Chad R. Larson" <chad@eldocomp.com>)
Responses Re: Mirroring with WAL?  (Giles Constant <gilesc@hyperlink-interactive.co.uk>)
List pgsql-admin
"Chad R. Larson" <chad@eldocomp.com> writes:
> At 10:35 PM 10/17/01 +0200, Peter Eisentraut wrote:
>> There are no plans to make WAL into a replication facility, for reasons
>> which were discussed on the developer lists as well.

> But we =are= still planning to use the WAL to implement a point-in-time
> recovery process, yes?

In its present form it's far too bulky to be kept around over any long
period of time --- or didn't you notice all the squawks about WAL files
overrunning disk as soon as anyone had a long-running transaction?

I'd say it's quite useless for PIT recovery unless we implement some
sort of filtering/compression process to produce an archivable WAL.
Which is doable, certainly, but it's not in the present implementation.

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Freeing Connections
Next
From: "Brett W. McCoy"
Date:
Subject: Re: "Can't Find any tables, sequences or indexes!" Message