Replication is one of the most important aspects of achieving high availability. Any unexpected failures on a database server could cause downtime for an application or a business. Configuring replication is thus the right practice to ensure that there is an option to perform failover in the event of disasters.
PostgreSQL is known for providing robust replication features for high availability without the need for an enterprise license or additional fees. There are two types of replication methods that are built into the community PostgreSQL source, namely streaming replication and logical replication.
Here are some of the differences between the two replication types:
- A standby in streaming replication does not allow writes whereas a standby (subscriber) in logical replication allows writes unless explicitly disabled.
- You cannot have selective...
