Re: Wals not recycling

Поиск
Список
Период
Сортировка
От Rijo Roy
Тема Re: Wals not recycling
Дата
Msg-id 575555765.8547999.1545393607615@mail.yahoo.com
обсуждение исходный текст
Ответ на Re: Wals not recycling  (Ian Lawrence Barwick <barwick@gmail.com>)
Список pgsql-general
Yes Ian, it worked.. 

Many Thanks,
Rijo Roy

On Friday, 21 December, 2018, 4:16:09 AM IST, Ian Lawrence Barwick <barwick@gmail.com> wrote:


2018年12月20日(木) 21:58 Rijo Roy <rjo_roy@yahoo.com>:
>
> Thanks sk for replying Ian.. I have one inactive replication slot in the database. I suspected that could be the cause but was not sure of it. Could you please tell me what I should be doing in this case. Can I drop the replication slot since it is no more used and delete old wal files or will PG be able to recycle them by itself.

Yes, just drop the replication slot and the excess files will be removed.


Regards

Ian Barwick

--
  Ian Barwick                  http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Change from 9.6 to 11?
Следующее
От: Mike Martin
Дата:
Сообщение: Re: How to compare dates from two tables with blanks values