Richard P. Welty wrote:
> but what are the consequences of backing up a WAL file
> if the archive process (probably scp in this case) is running
> when the backup copy is made? the whole thing won't make it onto
> tape, are there any downsides to running a recover with
> an incomplete WAL file?
The WAL file will obviously be no good. Just do something like:
cp $WALFILEPATH $ARCHIVE/$WALFILENAME.NEW
mv $ARCHIVE/$WALFILENAME.NEW $ARCHIVE/$WALFILENAME
Then simply exclude "*.NEW" from your backup.
-Glen
