Re: Multiple WALs for PITR ?

>Goulet, Dick
> As an Oracle DBA primarily, moving more towards PostGreSQL as time
> passes, the "alter system switch logfile" command is very often used at
> the end of a hot backup to force a logfile switch and consequently
> provide a full archive log set.  The command causes the database engine
> to cease using the current online redo log and have it archived to the
> archive log destination.  This is the only way to be sure that all
> required archive logs are present in a backup to reconstitute the
> database at another location.
>

Yep, know what it does - just wanted to check that people really used it.

I always felt I did that as a precaution rather than for good reason.

OK - 8.1 it is then,

Best Regards

Simon Riggs