PostgreSQL High Availability Options

Let’s review several popular solutions that increase the high availability of PostgreSQL deployments and, as a result, the overall application. It is shown how to approach the high availability for the following four PostgreSQL deployment scenarios:
1. Single primary database instance
2. Single primary database instance with read replicas
3. Multi-master deployment (sharded PostgreSQL with a coordinator, e.g. CitusData)
4. Multi-master (sharded PostgreSQL without the coordinator, e.g. YugabyteDB)
To learn more, read our guide to PostgreSQL high availability options: www.yugabyte.com/postgresql/p...
0:00 - Intro
0:31 - Widespread PostgreSQL deployment options
1:38 - High availability (HA) vs. disaster recovery
2:23 - HA with a single PostgreSQL database instance
6:34 - HA with a single primary instance and read replicas
8:04 - Sharding and horizontal scalability
9:06 - HA with multi-master deployments with coordinator (e.g. CitusData)
12:40 - HA for multi-master deployments without coordinator (e.g. YugabyteDB)
16:08 - Summary
RESOURCES:
-YugabyteDB / Start Now: cloud.yugabyte.com
-Site: www.yugabyte.com
-GitHub: github.com/yugabyte
COMMUNITY:
-Slack: communityinviter.com/apps/yug...
-CZcams: / yugabyte
-Instagram: / yugabytedb
-Twitter: / yugabyte
-LinkedIn: / yugabyte
You can connect to all our community channels here: linktr.ee/yugabyte

[@user-wz9mq1jo9n]

Thank you, it's great Explanation in single place.

[@Ayushcodez46]

Great Explanation..Thank you!!

[@zbigniewwiaterski209]

Thanks a lot ! Great explanation of subject, and great drawing. What tool did you use for drwaing ?

[@YugabyteDB]

Thanks for the feedback! Denis used excalidraw.com

[@user-cr2bg5qm5l]

Thank You. Question: Is pgpool and patroni compartible to postgres running on Windows ?

[@YugabyteDB]

Pgpool is officially supported for Linux. Patroni has ways to run on Windows.

[@San_OO7]

Try neondb