/ Shayon Mukherjee / blog

Introducing pg_easy_replicate 2.0

December 29, 2023
~2 mins

It’s exciting to share that pg_easy_replicate, a project I’ve been maintaining, has hit a new milestone with its 2.0 release! This tool is more than a practical solution for setting up logical replication between PostgreSQL databasesβ€”it’s been a profound source of learning about PostgreSQL concepts for me. Engaging with the community and discovering the ways they use pg_easy_replicate has been equally satisfying, making this journey an enjoyable and insightful experience.

What is pg_easy_replicate?

At its core, pg_easy_replicate is a CLI orchestrator tool that makes the process of setting up and managing logical replication between PostgreSQL databases a breeze. It’s designed to ensure zero data loss and minimal downtime, making operations like major version upgrades, load testing with blue/green database setups, and other similar tasks more manageable.


The Journey to 2.0

The journey to 2.0 has been an exciting one. One of the most awaited features I’ve been eager to introduce is the support for recreating indices post COPY, and it’s finally here in 2.0! This feature was on my mind since the inception of the project, but I just never got around to it. Here’s how it works:

Other Notable Enhancements in the Past Year

The past year has been a whirlwind of activity and improvement for pg_easy_replicate:

If you’d like to learn more about the tool and how it works, checkout the README at: https://github.com/shayonj/pg_easy_replicate

last modified December 29, 2023