One database as source of truth, & backups that are tested. Use replication to run analysis on Citus offered being able to have most of your database be plain

One database as source of truth, & backups that are tested. Use replication to run analysis on Citus offered being able to have most of your database be plain postgres & then having the few tables that take up most the database be distributed But for a small company you probably don't need scaling period