Re: PITR logging control program

Alvaro Herrera wrote:
> On Thu, Apr 29, 2004 at 12:18:38AM -0400, Bruce Momjian wrote:
> 
> > OK, I looked over the code.  Basically it appears pg_arch is a
> > client-side program that copies files from pg_xlog to a specified
> > directory, and marks completion in a new pg_rlog directory.
> > 
> > The driving part of the program seems to be:
> > 
> >     while ( (n = read( xlogfd, buf, BLCKSZ)) > 0)
> >         if ( write( archfd, buf, n) != n)
> >             return false;
> > 
> > The program basically sleeps and when it awakes checks to see if new WAL
> > files have been created.
> 
> 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.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073