| From: | Rijo Roy <rjo_roy(at)yahoo(dot)com> |
|---|---|
| To: | Ian Lawrence Barwick <barwick(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Wals not recycling |
| Date: | 2018-12-21 12:00:07 |
| Message-ID: | 575555765.8547999.1545393607615@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes Ian, it worked..
Many Thanks,Rijo Roy
On Friday, 21 December, 2018, 4:16:09 AM IST, Ian Lawrence Barwick <barwick(at)gmail(dot)com> wrote:
2018年12月20日(木) 21:58 Rijo Roy <rjo_roy(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Martin | 2018-12-21 13:48:19 | Re: How to compare dates from two tables with blanks values |
| Previous Message | Adrian Klaver | 2018-12-21 03:12:13 | Re: Change from 9.6 to 11? |