But, after all that, the SQLite database from my mail server (which holds all my mail) is now continuously replicating to an offsite backup and the backup restores correctly. Hopefully, this means that if the machine goes down or the database gets corrupted I’ll lose, at most, 15 seconds worth of data (mail) rather than 24-hours as per my previous backup routine.
Setting up streaming replication was more of an adventure than I anticipated. Not only did it involve the expected database shenanigans, but it also required
- Battling with not standard chroots and internal-sftp
- Fiddling with the MTU on both ends of my link
- Applying a patch to litestream
- Downloading two different versions of go so that I can compile the binary on two machines running different architecture
- Buying more disk space on my VPS and expanding my LVM partition. 
Database migrated — it took far longer than necessary because I messed up the permissions. Next step: setting up streaming replication.
After a night playing around with #modoboa I think I found my next mailserver solution. It's easy to install, looks also easy to maintain, written in python, comes with important core elements, but no bloated stuff, works quite nice in my testing environment :)
#mailserver #selfhosting #mail #admin #mailadmin #postmaster
Came across an e-mail server Mox by @mjl written in 
Any fediversians using it? 
Must admit I've been using Exim and Postfix driven e-mail setups for more than two decades, therefore curious to explore a different server, which code I can actually read and understand well 
Will be setting up a machine to try Mox out 
Ich habe meine bisherigen Erfahrungen zum sehr holprigen Zusammenspiel meines Mailservers (Debian, Postfix, Yunohost) mit dem Microsoft Exchange Server der neuen Schule meines Kindes (und der dort eingesetzten Mailingliste) im Blog ausführlich zusammengefasst:
https://www.caliandro.de/blog/Zusammenspiel_Postfix_DKIM_SPF_DMARC_Mailinglisten.html
Fazit: Man muss die modernen, bisher für mich normalen Sicherheitsstandards leider reduzieren, um die Abwärtskompatibilität mit Microsoft zu gewährleisten.
#yunohost #postmaster #sysadmin #postfix #microsoftExchange #tls #spf #dkim #dmarc #spam #spamhaus #blog
Anton
Daniel Colquitt
DeltaLima 🐧
gregR ☯
Jan Wildeboer 😷
Gytis Repečka
st3fan