On Thu, 25 Apr 2002, Bruce Momjian wrote: > WAL files are kept only until an fsync(), checkpoint, then reused.
One could keep them longer though, if one really wanted to. > Also, the info is tied to direct locations in the file. You could do > this for hot backup, but it would require quite bit of coding to make it > work. That's kind of too bad, since log shipping is a very popular method of backup and replication. Not that I'm volunteering to fix this. :-) cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]