Shaun M. Thomas: PG Phriday: Redefining Postgres High Availability
What is High Availability to Postgres? I’ve staked my career on the answer to that question since I first presented an HA stack to Postgres Open in 2012, and I still don’t feel like there’s an acceptable answer. No matter how the HA techniques have advanced since then, there’s always been a nagging suspicion in my mind that something is missing. But I’m here to say that a bit of research has uncovered an approach that many different Postgres cloud vendors appear to be converging upon.
Postgres缺乏本地高可用性（HA），现有的HA技术存在限制。然而，Postgres云供应商正在采用一种方法，将Postgres转变为真正的HA数据库引擎。存储层是一个关键考虑因素，复制存储系统提供了潜在的解决方案。将存储引擎与处理层解耦，并使用基于仲裁的分布式文件系统可以在系统之间提供一致性。分片和协调器/工作节点模型可以帮助扩展计算层。Postgres有潜力成为Web3组件，具有分布式块算法和共识实现。虽然这可能不会被Postgres社区采纳，但对于HA来说具有潜在的好处。目前，Patroni和Kubernetes操作员是管理Postgres集群的最新技术。Postgres变体如Aurora、NeonDB和AlloyDB也在取代存储层方面取得进展。
