Search Postgresql Archives

Re: Wals not recycling

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes Ian, it worked.. 

Many Thanks,
Rijo Roy

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


2018年12月20日(木) 21:58 Rijo Roy <rjo_roy@xxxxxxxxx>:
>
> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux