Using PostgreSQL logical replication with Aurora

Answer If you do not see the replication slot under the slot_name column then the slot does not exist There are two potential reasons for this: If you do

Reviving lost replication slots Hi, A replication slot can be lost when a subscriber is not able to catch up with the load on the primary and the WAL to

postgres delete replication slot In Postgres 16 the replication slots persist after a failover, which is very exciting! Our former standby gets promoted to become the

postgresql create replication slot Take Away The morale of the story? Don't leave your replication slots unattended! There shouldn't be any slots which are inactive for too long