pg_replication_slots: Best practices for Amazon RDS PostgreSQL replication | AWS Database ... . Documentation: 17: 53.4. Streaming Replication Protocol. How to gain insight into the pg_stat_replication_slots view by .... postgresql - How to limit WAL size when using Postgres Logical ... .
rds-master=> select * from
pg_replication_slots; slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn .
Then query the pg_replication_slots view on your source database to make sure that this
slot does not have any active connections.
logical_replica_slot,0/7000180) (1 row) percona=# select * from pg_replication_slots ; slot_name | plugin | slot_type | datoid | database | temporary | active ...
postgres=# select * from pg_replication_slots; -[ RECORD 1 . slot_name | main_slot plugin | slot_type | physical datoid | database | active | t active_pid | 16297 xmin | catalog_xmin | restart_lsn | 2/F4000108 confirmed_flush_lsn | -[ RECORD 2 .