Will unused replication slots prevent the server from deleting WALsegments?

Поиск
Список
Период
Сортировка
От Nagy László Zsolt
Тема Will unused replication slots prevent the server from deleting WALsegments?
Дата
Msg-id 73cd3a8f-363f-c880-67c7-9bcf290ba2b7@shopzeus.com
обсуждение исходный текст
Ответы Re: Will unused replication slots prevent the server from deletingWAL segments?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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


В списке pgsql-admin по дате отправления:

Предыдущее
От: Steven Crandell
Дата:
Сообщение: Re: Wal fetching standby refuses to promote
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Will unused replication slots prevent the server from deletingWAL segments?