Re: Wals not recycling

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Wals not recycling
Date: 2018-12-20 22:45:56
Message-ID: CAB8KJ=hHMCP_AytAMy47L90iLywv+TdwE7KvS_ZYzPoWkey=uA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2018-12-20 23:16:18 Re: Multiple LDAP Servers for ldap Authentication
Previous Message Kumar, Virendra 2018-12-20 21:17:02 RE: Multiple LDAP Servers for ldap Authentication