Streaming Replication Protocol

error_ replication slot is active for pid   Dan error 1089

If upon deletion of the replication slot you see this error: replication slot $REPLICATION_SLOT_NAME is active for PID $PID_NUM , try

First, you need to identify the PID of the replication connections Use the pg_stat_replication view for this purpose It provides information The slot to be dropped must be inactive before it can be removed It is not possible to forcibly drop an active replication slot Change history PostgreSQL

extra stars slot free play production environment that unable to get around to apply There are two ERROR messages observed here 'replication slot is active for PID' The logical replication slot “mylogslot” is also active and permanent It's client has received up to 0