Set up logical replication and decoding

Capture from PostgreSQL using Logical Replication - HVR 6 postgresql replication slot The solution is replication slots, a feature provided by Postgres that ensures the primary server only discards WAL records after they have been received by the postgresql replication slot The pg_replication_slots view provides a listing of all replication slots that currently exist on the database cluster, along with their current state For more

postgresql create replication slot Why does postgresql have so many replication slots open? · disabled the subscription on the replica