How databases handle connections and fault tolerance

One thing I found interesting while digging into databases is how differently they handle client connections. Let’s start with Postgres, because it does something very old-school but very solid. Postg