Re: stale WAL files?

From: Gmail <robjsargent(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: stale WAL files?
Date: 2019-03-30 16:54:59
Message-ID: 989E476E-D798-4F80-ADDE-3DA4EB9CAA3C@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> On Mar 29, 2019, at 6:58 AM, Michael Paquier <michael(at)paquier(dot)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_wal dir such that I can see which files get processed. It’s none of the files I’ve listed previously

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2019-03-30 18:14:47 CVE-2019-9193 about COPY FROM/TO PROGRAM
Previous Message David Steele 2019-03-30 15:03:04 Re: Regarding pgaudit log_directory