How To Start Logical Replication in PostgreSQL for Specific Tables

The function pg_create_physical_replication_slot is used to create a physical replication slot This command has to be run in the master node

PostgreSQL and later come with a feature called “replication slots” They can be used to make WAL archiving and streaming replication

postgresql replication slot The postgresql_replication_slot resource creates and manages a replication slot on a PostgreSQL server database

postgres create logical replication slot There are two types of replication slots: logical and physical Logical slots have the property to be able to connect to a particular database,