Skip site navigation (1) Skip section navigation (2)

Re: PITR logging control program

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PITR logging control program
Date: 2004-04-29 14:11:13
Message-ID: 20040429141113.GG2258@dcc.uchile.cl (view raw or flat)
Thread:
Lists: pgsql-hackers
On Thu, Apr 29, 2004 at 10:07:01AM -0400, Bruce Momjian wrote:
> Alvaro Herrera wrote:

> > Is the API able to indicate a written but not-yet-filled WAL segment?
> > So an archiver could copy the filled part, and refill it later.  This
> > may be needed because a segment could take a while to be filled.
> 
> I couldn't figure that out, but I don't think it does.  It would have to
> lock the WAL writes so it could get a good copy, I think, and I didn't
> see that.

I'm not sure but I don't think so.  You don't have to lock the WAL for
writing, because it will always write later in the file than you are
allowed to read.  (If you read more than you were told to, it's your
fault as an archiver.)

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Et put se mouve" (Galileo Galilei)

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2004-04-29 14:22:40
Subject: Re: PITR logging control program
Previous:From: Bruce MomjianDate: 2004-04-29 14:07:01
Subject: Re: PITR logging control program

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group