Set up logical replication to Aiven for PostgreSQL

Currently postgres doesn't allow dropping a replication slot that's active This can make certain operations more time-consuming or stuck in production

A PostgreSQL replication slot may be stuck due to one of the following reasons: Check if the bgwriter process is healthy by inspecting its

postgresql create replication slot In that case, the Azure Database for PostgreSQL flexible server instance automatically drops that unused logical replication slot That

postgres create replication slot This requires that client authentication is set up to allow replication connections (see Section slot=test --drop-slot The following example shows SQL