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

From Gmail
Subject Re: stale WAL files?
Date
Msg-id 6F2111AD-1CD9-4077-AA8B-F6E1F7AD809D@gmail.com
Whole thread Raw
In response to Re: stale WAL files?  (Gmail <robjsargent@gmail.com>)
Responses Re: stale WAL files?  (Rene Romero Benavides <rene.romero.b@gmail.com>)
List pgsql-general

> On Mar 30, 2019, at 10:54 AM, Gmail <robjsargent@gmail.com> wrote:
>
>
>>>> 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 

Two more have been cleaned up.  001C and 001D generated at 16:38 Mar 16




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CVE-2019-9193 about COPY FROM/TO PROGRAM
Next
From: Samuel Williams
Date:
Subject: Re: libpq read/write