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