From: Nagy László Zsolt <gandalf@shopzeus.com>
To: pgsql-admin@postgresql.org
Subject: Will unused replication slots prevent the server from deleting WAL segments?
Date: Mon, 19 Mar 2018 08:34:10 +0100
Message-ID: <73cd3a8f-363f-c880-67c7-9bcf290ba2b7@shopzeus.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gandalf@shopzeus.com
Subject: Re: Will unused replication slots prevent the server from deleting WAL segments?
In-Reply-To: <73cd3a8f-363f-c880-67c7-9bcf290ba2b7@shopzeus.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox