Starting with version 10, PostgreSQL natively supports logical replication using publication and subscription structures. These are directly managed by the PostgreSQL syntax parser as native SQL, and create objects in the system catalog that are managed just like everything else.
This makes it almost trivial to create lists of tables to transmit to recipient PostgreSQL servers located elsewhere. It also means standard PostgreSQL tools can interact with the subscription and table sets in ways that extensions cannot reproduce.
This recipe will create a basic table set and explain a bit about the limitations of this type of logical replication.
