Nagy László Zsolt wrote: > 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) > > > Should I delete this slot and add it again later, when the new slave > becomes available? I'm not 100% certain if it can do any harm or not, but I'd drop the replication slot and create a new one later if you need it. Creating a replication slot is fast and simple. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
