Re: Problem with PITR recovery

Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > The wal file could be truncated after the log switch record, though I'd
> > want to make sure that didn't cause other problems.
> 
> Which it would: that would break WAL file recycling.

Good point. I don't see non-full WAL archiving as a problem for the
backup or shutdown, but I do see an issue with doing archives every X
seconds.  If someone sets that really low (and someone will) we could
easily fill the disk.  However, rather than do it ourselves, maybe we
should make it visible to administrators so they know exactly what is
happening and can undo it in case they need to recover, something like:

archive_command = 'gzip <%p >%f'

so the compression is done in a way that is visible to the
administrator.

--  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