We have a replication setup from AWS RDS PostgreSQL to Kafka. The replication slot's restart_lsn is not moving and WALs keep pilling up. I tried to remove all the Kafka replications and tried using logical replication and AWS DMS on the same postgreSQL instance, that too doesn't release it's position in WAL,Even though the changes are getting replicated to the target. Why replication slots are holding these WALs?
Asked
Active
Viewed 640 times
1
-
Does pg_replication_slots show exactly one entry? – jjanes Oct 31 '20 at 14:38
-
We have around 12 replication slots there, reatart lsn doesn’t move for all of those. WALs get released all at once we reload the target tables of the replication. – Chetan Dev Khanna Oct 31 '20 at 22:39