Re: WAL files not being recycled - Mailing list pgsql-general

From Vik Fearing
Subject Re: WAL files not being recycled
Date
Msg-id 573A7472.30400@2ndquadrant.fr
Whole thread Raw
In response to Re: WAL files not being recycled  (Scott Moynes <scott@vmfarms.com>)
List pgsql-general
On 17/05/16 00:54, Scott Moynes wrote:
> wal_keep_segments is set to 32.
>
> Here is the replication slot:
>
>     slot_name    |
> n6lbb2vmohwuxoyk_00018732_f58b5354_79ad_4e6e_b18b_47acb1d7ce1f
>     plugin       | test_decoding
>     slot_type    | logical
>     datoid       | 18732
>     database     | omitted
>     active       | f
>     xmin         |
>     catalog_xmin | 84884044
>     restart_lsn  | 1B3/4300CA60
>
> Can an inactive replication slot cause WALs to be retained?

Absolutely!  That's what they're for.

If you don't expect this slot to re-become active, you should drop it.
--
Vik Fearing                                          +33 6 46 75 15 36
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-general by date:

Previous
From: Elusai Soares
Date:
Subject: How to convert firebird stored procedures into postgresql functions
Next
From: Steve Kehlet
Date:
Subject: Re: preventing ERROR: multixact "members" limit exceeded