Re: WAL -> Replication - Mailing list pgsql-hackers

From Curt Sampson
Subject Re: WAL -> Replication
Date
Msg-id Pine.NEB.4.43.0204261437130.1733-100000@angelic.cynic.net
Whole thread Raw
In response to Re: WAL -> Replication  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: WAL -> Replication  (Hannu Krosing <hannu@tm.ee>)
List pgsql-hackers
On Thu, 25 Apr 2002, Bruce Momjian wrote:

> WAL files are kept only until an fsync(), checkpoint, then reused.

One could keep them longer though, if one really wanted to.

> Also, the info is tied to direct locations in the file.  You could do
> this for hot backup, but it would require quite bit of coding to make it
> work.

That's kind of too bad, since log shipping is a very popular method of
backup and replication.

Not that I'm volunteering to fix this. :-)

cjs
-- 
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org   Don't you know, in this new Dark Age, we're
alllight.  --XTC
 



pgsql-hackers by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Vote totals for SET in aborted transaction
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: pg_constraint