CAP theorem
In a distributed system you can only have two of three: Consistency, Availability, Partition tolerance.
Eric Brewer (2000). Since network partitions happen, the practical choice is CP (Postgres replication, MongoDB with strong consistency) or AP (Cassandra, DynamoDB by default). Modern theory (PACELC) nuances the picture.