Demystifying pglogical - Tutorial
pglogical is a logical replication system implemented entirely as a PostgreSQL extension. It is fully integrated, and requires no triggers or external programs. pglogical asynchronously replicates only changes in the data using logical decoding . This makes it very efficient as only the differences are replicated and also tolerant to network faults since it can resume after the fault. After a frustrating session trying to setup pglogical, I've decided to document some of the quirks and missing information from the documentation. All in all, the documentation is great, but there are some things I wish I knew before I started which would have made my experience less painful. Note that I won't be covering the installation process as it is well documented. However, I do have a postgresql ansible role for Ubuntu that handles it as well if you want to go that route. Note: this post does not attempt to be a replacement for the official documentation and only serves to p