Ron Garret:
> WAL mode was previously discussed here:
> 
> https://marc.info/?l=postfix-users&m=160096626120296&w=2

In other words the reader requires database write permission. I
fully agree that is not desirable.

> The upshot appears to be this, at least as things currently stand:
> 
> > DO NOT use SQLite as a Postfix backend database updated live while
> > Postfix is running.

Just like other file-based databases, the safest update
approach is

        create a temporary db file
        rename the temporary db file

The exception is LMDB which can handle concurrent reads and writes
without reader permission errors, busy errors, and so on.

So, who adds a busy timer to the sqlite client?

        Wietse

Reply via email to