Aiven for PostgreSQL®: Automatic Recreation of Replication Slots

Aiven for PostgreSQL®: Automatic Recreation of Replication Slots postgresql create replication slot PostgreSQL 10 came with the welcome addition of the logical replication feature This provides a more flexible and easier means to replicate postgresql replication slot In order to be able to ingest events from a Postgres database, Upsolver creates a replication slot for every CDC data source In Postgres

postgresql replication slot A replication slot is a PostgreSQL feature which ensures that a stream of changes stored in a WAL log file is replicated to the destination in the correct order

postgresql drop replication slot Allow you to replicate data out of Postgres · Use the write-ahead log as the source of changes · Use logical replication slots to send out Improve WAL archiving and streaming replication using replication slots PostgreSQL and later come with a feature called “replication slots”