WAL accumulating, Logical Replication pg 13

slot_name my_pub1 plugin pgoutput slot_type logical datoid 16401 database db temporary f active t active_pid

WAL accumulating, Logical Replication pg 13 Query on the primary instance is always running After creating a replica, the query SELECT * from pg_stat_activity where state = 'active' and pid = XXXX and

slot_name my_pub1 plugin pgoutput slot_type logical datoid 16401 database db temporary f active t active_pid

replication slot postgres slot_name my_pub1 plugin pgoutput slot_type logical datoid 16401 database db temporary f active t active_pid

When Kafka Connect attempts to restart the connector too quickly, the database sees that the slot is still active although the client has disconnected Hope

replication slot is active for pid This command shows information about logical replication slots that are setup on the database It shows if the slot is active, the state of the WAL sender

If a replication slot is inactive, the pg_wal logs corresponding to the slot are reserved forever PID you will use