Ruby developer Shayonj has released a new utility called pg_easy_replicate, which allows for easy configuration of logical data replication between two postgreSQL DBMSs. The utility is designed to minimize downtime when transferring a database to another server or moving to a new postgreSQL branch. It can also streamline experiments and load testing with a synchronized copy of the working database on another server. The project code is written in Ruby, and is available under an open-source license.
pg_easy_replicate automates the replication settings and supports a switching mode of servers, where the initial server is converted to a reading-only mode after completing the replication and synchronization. This eliminates data loss and minimizes application downtime when performing works such as replacing DBMS versions or servers. Selective replication of tables from one database to different servers is also possible. The utility’s reliability has been successfully tested in the working systems of the Tines service.
Shayonj is also the creator of another utility called pg-SCC, which is designed to change the working database blocking scheme. When the scheme changes, tables are substituted using a “shadow table,” which is created separately and replicates the primary table. The shadow table’s scheme changes and data from the primary table are transferred, with the table names being replaced. Changes made during transfer are synchronized using triggers and an additional audit table.
Both pg_easy_replicate and pg-SCC demonstrate Shayonj’s expertise in developing utilities that aim to simplify and streamline database management processes. Developers can access the codes for both utilities via their respective projects’ GitHub pages: pg_easy_replicate and pg-SCC.