99.9% of the companies in the world will never need more than 1 beefy box running postgres with a replica for a manual failover and/or reads.
That being said, the setups I typically see don't even go that far. Most companies don't mitigate for the database going down in the first place. If the db goes down they just eat the downtime and fix it.