Set up logical replication to Aiven for PostgreSQL

replication slot is active for pid   Dan replication slot is active for pid

The recreation of replication slots gets enabled automatically for services created or updated as of January 2021 Additional details are outlined in our

active active_pid xmin catalog_xmin Query on the primary instance is always running After creating a replica, the query SELECT * from pg_stat_activity where state = 'active' and pid = XXXX and

slot hot spin we have couple Postgres RDS connectors and we face sometimes the same error with the replication slot being active  pid WHERE _type = 'logical'; slot_name On pg_stat_activity I see the logical replication worker of this table always active