> The website I'm working on now has a single monolithic Postgres server, and the majority of systems I've worked on connected to single monolithic datastores, so at the very least these systems exist.

These systems do not guaranty neither consistency, nor availability during network partitions.