scoobyjh <[EMAIL PROTECTED]> wrote: > When VACUUM cleaning a database it creates a temporary file by default in > /var/tmp. What happens when power is lost or unit crashes? Can the database > be correupted or lose data? >
VACUUM generates a rollback journal. So losing power in the middle of a VACUUM will just cause the database to revert to its original state when power is restored. Note, however, that because of the temporary file and the journal, VACUUM can use temporary disk space that is a little more than twice the size of the original database file. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------