> I've actually considered running everything off of (multliple instances of) SQLite so that I don't have to manage Postgres.

If you considered SQLite, then you might want to just run a local Postgres instance on your Application's VPS and connect with a unix socket. The DSN is as simple as postgresql://dbname while still providing all features like replication