Re: Add hint about replication slots when nearing wraparound
От | Michael Paquier |
---|---|
Тема | Re: Add hint about replication slots when nearing wraparound |
Дата | |
Msg-id | CAB7nPqR5THjnrhNCbkCT1Ed6Bjq_uKOo-Ff6rwiz+mh-uiRFug@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Add hint about replication slots when nearing wraparound (Feike Steenbergen <feikesteenbergen@gmail.com>) |
Ответы |
Re: Add hint about replication slots when nearing wraparound
|
Список | pgsql-hackers |
On Wed, Dec 20, 2017 at 10:00 PM, Feike Steenbergen <feikesteenbergen@gmail.com> wrote: > As far as I know the issue only occurs for stale replication slots for > logical decoding but not for physical replication, is that correct? Yeah, I recall something similar. @@ -255,7 +255,9 @@ $ pg_recvlogical -d postgres --slot test --drop-slot even when there is no connection using them. This consumes storage because neither required WAL nor required rows from the system catalogs can be removed by <command>VACUUM</command> as long as they are required by a replication - slot. So if a slot is no longer required it should be dropped. + slot. In extreme cases this could cause the database to shut down to prevent + transaction ID wraparound (see <xref linkend="vacuum-for-wraparound"/>). + So if a slot is no longer required it should be dropped. </para> Don't you want to put that in its own <caution> block? That's rather important not to miss for administrators. -- Michael
В списке pgsql-hackers по дате отправления: