I have accidentally created an extra replication slot on a server. It was a long time ago, and it is not used (active=false). I'm planning to add another replication slave, but I can only do it later. I wonder if it prevents the server to recycle old WAL segments? template1=# select * from pg_replication_slots; slot_name | plugin | slot_type | datoid | database | temporary | active | active_pid | xmin | catalog_xmin | restart_lsn | confirmed_flush_lsn -----------+--------+-----------+--------+----------+-----------+--------+------------+------+--------------+-------------+--------------------- eke | | physical | | | f | f | | | | | docker02 | | physical | | | f | t | 66 | | | 0/7000000 | (2 rows) template1=# There is only one row in pg_stat_replication: template1=# select * from pg_stat_replication ; pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | backend_xmin | state | sent_lsn | write_lsn | flush_lsn | replay_lsn | write_lag | flush_lag | replay_lag | sync_priority | sync_state -----+----------+-----------------+------------------+-------------+-----------------+-------------+-------------------------------+--------------+-----------+-----------+-----------+-----------+------------+-----------+-----------+------------+---------------+------------ 66 | 16386 | phb_replication | walreceiver | 10.0.0.84 | | 58318 | 2018-03-01 08:27:07.044626+00 | | streaming | 0/7000000 | 0/7000000 | 0/7000000 | 0/7000000 | | | | 0 | async (1 row) template1=# Should I delete this slot and add it again later, when the new slave becomes available? Thanks, Laszlo
