pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. Logical Replication extension for PostgreSQL 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades. In my example to configure pglogical I used two systems 192.168.1.93 for provider(publish) and 192.168.1.120 for subscriber (subscribe).Both systems are on Centos7. Step 1. Install PostgreSQL I assume that on both systems PostgreSQL12 has already installed. If not installed use below link [root@pc1 ~]# yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latestpglogical.noarch.rpm [root@pc1 ~]# yum install postgresql12-server postgresql12-contrib [root@pc1 ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb [root@pc1 ~]# systemctl enable postgresql-12 [root@pc1 ~]# systemctl start postgre...