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