Documentation: 16: CREATE SUBSCRIPTION

Documentation: 16: CREATE SUBSCRIPTION postgresql create replication slot Replication slots are created independently from publications Publications to be used as a filter are specified when fetching changes stream postgresql drop replication slot To turn on logical replication for a newly created RDS for PostgreSQL DB instance

postgresql drop replication slot I have 2 logical replication slots in Postgres 12 Suddenly one of them failed couple of days ago

postgresql replication slot Let's say for instance you have a replication user called replication , created WITH REPLICATION , the role doesn't actually have permissions to the master doesn't create the replication slot This doesn't happen at every restart but randomlyinconsistent In the slave postgres logs: