Comparing logical replication and physical replication

Let’s now examine how a logical replica differs from a physical replica:

• One of the positive characteristics of physical replicas is their speed. However, a distinct disadvantage is that we have to replicate all the databases in the cluster. Using a physical replica, it is not possible to replicate a single database belonging to an instance of PostgreSQL, and it is not possible to replicate only some tables of a database. Logical replication is a little bit slower than physical replication, but by using logical replication, we can decide which databases we want to replicate within a cluster and/or which tables we want to replicate within a single database.
• Physical replication is only possible if the two servers have the same version of PostgreSQL. With logical replication, since the logical instruction to be executed is passed to the replica server, it is also possible to perform replications between different...