Will unused replication slots prevent the server from deleting WAL segments?

From: Nagy László Zsolt <gandalf(at)shopzeus(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Will unused replication slots prevent the server from deleting WAL segments?
Date: 2018-03-19 07:34:10
Message-ID: 73cd3a8f-363f-c880-67c7-9bcf290ba2b7@shopzeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2018-03-19 08:53:00 Re: Will unused replication slots prevent the server from deleting WAL segments?
Previous Message Steven Crandell 2018-03-18 20:52:05 Re: Wal fetching standby refuses to promote