Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate

Pg_easy_replicate is a CLI tool that makes it easy to establish logical replication between two PostgreSQL databases and supports switchover. Once replication is complete, the tool puts the primary database into read-only mode and flushes all data to the new target database via logical replication, resulting in zero data loss and minimal application downtime. Users can create multiple replication groups for a single database and use custom tables for replication. Pg_easy_replicate is compatible with PostgreSQL 10 and later, and the database user should have permissions for SUPERUSER. The tool does not provide switchover functionalities but recommends strategies like rolling restart or DNS failover for minimal downtime.

To top