Logical Replication in PostgreSQL Explained

This flag defaults to 10 and its limit grows with the memory of your Cloud SQL instance, allowing between 2 and 8 replication slots per GB of memory The

Replication in PostgreSQL works by processing WAL files In order for this to work, all WAL files have to be transiently available until they

replication slot already exists 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

replication slot A replication slot represents one specific stream of changes coming from a Postgres database and keeps track of how far a consumer has processed