The Postgres docs describe how to set up read replicas and HA. They're admirably clear and high quality, more so than many FLOSS projects. You can also set up sharding to scale out further.