Home > mailing lists

keeping WAL after dropping replication slots - Mailing list pgsql-general

From	Tom DalPozzo
Subject	keeping WAL after dropping replication slots
Date	April 4, 2017 20:45:54
Msg-id	CAK77FCRkkRMTY4bd8Ku7D2W=-t8HjUV6wmf20OQ=TUmSWRqEgw@mail.gmail.com Whole thread Raw
Responses	Re: keeping WAL after dropping replication slots (Adrian Klaver <adrian.klaver@aklaver.com>)
List	pgsql-general

Hi,

I had two replication slots on my primary. Slaves off and (around 800) WALs kept as expected.

I dropped those slots but over time, the system kept on adding new WALs without reusing them or deleting them.

Only after shutdown and restart the system deleted those WAL files.

Is that ok?

regards

Pupillo

From: Merlin Moncure
Date: 04 April 2017, 20:11:54
Subject: Re: Query never completes with low work_mem (at least notwithin one hour)

From: "Armand Pirvu (home)"
Date: 04 April 2017, 21:34:51
Subject: Re: audit function and old.column