# PostgreSQL High Availability with Primary and Standby Servers

DevFeed: [PostgreSQL High Availability with Primary and Standby Servers](<https://devfeed.tech/articles/queen-princesses-and-workers-34574.md>)

Original publisher: [Read original article](<https://tapoueh.org/blog/2017/12/queen-princesses-and-workers/>)

Author: Dimitri Fontaine PostgreSQL Major Contributor; Author

Published: 2017-12-11T09:19:24Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [postgresql clusters](<https://devfeed.tech/topics/postgresql-clusters.md>), [Database](<https://devfeed.tech/topics/database.md>), [Load Balancing](<https://devfeed.tech/topics/load-balancing.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [load-balancing](<https://devfeed.tech/tags/load-balancing.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [primary](<https://devfeed.tech/tags/primary.md>), [replication](<https://devfeed.tech/tags/replication.md>), [standby](<https://devfeed.tech/tags/standby.md>)

## AI overview

This article explains PostgreSQL high-availability architectures using primary and standby servers. It discusses replication, online backups, automated recovery, and promoting a standby server when the primary becomes unavailable.

## Source excerpt

The PostgreSQL community made the explicit choice some times ago that they would not use the infamous master and slave terminology. Instead, the documentation introduces the concepts of High Availability, Load Balancing, and Replication with the terms Primary and Standby, and the even more generic term Replica is used in contexts when only the data flow is considered, rather than the particular role of a node.