Re: stale WAL files? - Mailing list pgsql-general

From Gmail
Subject Re: stale WAL files?
Date
Msg-id 989E476E-D798-4F80-ADDE-3DA4EB9CAA3C@gmail.com
Whole thread Raw
In response to Re: stale WAL files?  (Michael Paquier <michael@paquier.xyz>)
Responses Re: stale WAL files?  (Gmail <robjsargent@gmail.com>)
List pgsql-general
> On Mar 29, 2019, at 6:58 AM, Michael Paquier <michael@paquier.xyz> wrote:
>
>> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote:
>> This is pg10 so it's pg_wal.  ls -ltr
>>
>>
>> -rw-------. 1 postgres postgres 16777216 Mar 16 16:33
>> 0000000100000CEA000000B1
>> -rw-------. 1 postgres postgres 16777216 Mar 16 16:33
>> 0000000100000CEA000000B2
>>
>>  ... 217 more on through to ...
>>
>> -rw-------. 1 postgres postgres 16777216 Mar 16 17:01
>> 0000000100000CEA000000E8
>> -rw-------. 1 postgres postgres 16777216 Mar 16 17:01
>> 0000000100000CEA000000E9
>> -rw-------. 1 postgres postgres 16777216 Mar 28 09:46
>> 0000000100000CEA0000000E
>
I’m now down to 208 Mar 16 WAL files so they are being processed (at least deleted).  I’ve taken a snapshot of the
pg_waldir such that I can see which files get processed. It’s none of the files I’ve listed previously 


pgsql-general by date:

Previous
From: David Steele
Date:
Subject: Re: Regarding pgaudit log_directory
Next
From: "Daniel Verite"
Date:
Subject: CVE-2019-9193 about COPY FROM/TO PROGRAM