Planet PostgreSQL – Amit Kapila: Evolution of Logical Replication

This blog post is about how the Logical Replication has evolved over the years in PostgreSQL, what’s in the latest release-16, and what’s being worked upon for future releases. Logical replication is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key). We use the term logical in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. To know more about Logical Replication in PostgreSQL, read pgsql-docs.The foundation of Logical Replication has been laid in PostgreSQL-9.4 where we introduced Logical Decoding (that allows database changes to be streamed out in a customizable format), Replication Slots (that allow preservation of resources like WAL files on the…

External feed Read More at the Source: https://postgr.es/p/69U