>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