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
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 |