> Am I correct that with no UNDO in 7.1.X, we should only be keeping one
> WAL file around, or maybe two?
Not necessarily. How much do you do between checkpoints?
But yeah, there's no reason to save data further back than one or maybe
two checkpoints, as long as UNDO isn't there.
Steve Wampler <[EMAIL PROTECTED]> writes:
> Are the WAL segment files the ones located in pg_xlog?
Right, the ones with sixteen-hex-digit filenames. Sorry for not being
perfectly clear.
regards, tom lane
---(end of broadcast)-
Steve Wampler <[EMAIL PROTECTED]> writes:
> FATAL 2: ZeroFill(/var/lib/pgsql/data/pg_xlog/xlogtemp.16747) failed: No such file
>or directory
The error message is bogus --- almost certainly, the real problem is not
enough free space to create another 16-MB WAL segment. (I have a TODO
item about
