Daniel Colquitt
Right, that's it - litestream.io is being to flaky. It's time to migrate my #email server from #sqlite to #PostgreSQL. Pray for me. #selfhosting
Apr 4 at 5:38pmWeb
Show threadDaniel Colquitt2d ago

And, migration done. Live database on PostgreSQL and replicating to an offsite backup. It would have been straightforward had I not messed up the permissions.

Next step is PITR, but that can wait.

#email #sqlite #PostgreSQL #selfhosting

Show threadHelge Heß2d ago
@daniel I'm slightly confused what an email server would have to do with a database anyways?
Show threadDaniel Colquitt2d ago
@helge for storing metadata, account data, configuration, etc.
Show threadJakob1d ago
@daniel
Oh noes, I wanted to feed my r/o lldap backups with that. Right now its a script listening on changes to the sqlite and rsync. 😅
What are your problems?