On Thu, Sep 24, 2020 at 05:34:15PM -0500, deoren wrote:
> > No, just WAL mode means that we haven't opened all the files that
> > might later be needed.
>
> If I run all tasks under the postfix user account, how likely am I to
> run into issues? Thus far it seems to be working, but I've yet to go a
> full 6 hours, much less 24 hours.
Well, you'd be running an unsupported configuration, so how adventurous
do you feel? If the WAL file is ever deleted, it might come back owned
by the wrong user, ... or some other unexpected permission issue.
When Postfix is accessing indexed files directly, they should be
read-only. For concurrent read-write, use a database.
SQLite is an embedded datastore for applications, where typically all
the reads and writes are handled by some component of that application.
For real multi-application concurrency, use a database designed for
that.
--
Viktor.
