Postgres Pro
Downloads
Home   >   mailing lists

Re: Wals not recycling - Mailing list pgsql-general

From Rijo Roy
Subject Re: Wals not recycling
Date
Msg-id 575555765.8547999.1545393607615@mail.yahoo.com
Whole thread Raw
In response to Re: Wals not recycling  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Change from 9.6 to 11?
Next
From: Mike Martin
Date:
Subject: Re: How to compare dates from two tables with blanks values