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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly