Re: Will unused replication slots prevent the server from deletingWAL segments?

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