Planet PostgreSQL – Shayon Mukherjee: Use pg_easy_replicate for setting up Logical Replication and Switchover in PostgreSQL

Logical replication is a powerful feature in PostgreSQL that allows for real-time data replication between databases. It can be used for performing major version upgrades using a blue/green setup where you have two databases, allowing you to test and switch over to a new version with minimal downtime. Logical replication can also be use to facilitate database migrations between different environments, using the same technique and tooling.
In this post, I will describe the process of setting up simple replication and switchover between two databases using pg_easy_replicate.

External feed Read More at the Source: https://postgr.es/p/6zV