Replication in the PostgreSQL DBMS: types, testing, monitoring
-
20 min
PostgreSQL is an open-source database management system. Various PostgreSQL forks, such as PostgresPro, Pangolin, are included in the register of certified domestic software. It is actively used for import substitution. To increase fault tolerance and load balancing between servers, the DBMS uses replication, the process of synchronizing multiple copies of databases on different servers.
In the presentation, I will tell you what physical and logical replication in PostgreSQL is, how they differ, and what restrictions there are, how to test and monitor replication.