• PostgreSQL: Documentation: 17: 29.2. Subscription
• Failover Replication Slots with Postgres 17
• Working with PostgreSQL Replication Slots | Simplified Guide

---

PostgreSQL: Documentation: 17: 29.2. Subscription

Identify the replication slot created by AWS DMS using the following command: SELECT * FROM pg_replication_slots;.

Failover Replication Slots with Postgres 17

Explore failover logical replication slots in Postgres v17, allowing you to keep track of how far a specific subscriber has consumed a database’s change event stream.

Working with PostgreSQL Replication Slots | Simplified Guide

libdata=# CREATE SUBSCRIPTION financials CONNECTION 'dbname=libdata user=postgres host=172.17.0.2' PUBLICATION financials; NOTICE: synchronized table states NOTICE: created replication slot "financials" on publisher CREATE SUBSCRIPTION.