[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: stale WAL files?
From:       Gmail <robjsargent () gmail ! com>
Date:       2019-03-30 23:03:28
Message-ID: 6F2111AD-1CD9-4077-AA8B-F6E1F7AD809D () gmail ! com
[Download RAW message or body]



> 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_wal dir 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


[prev in list] [next in list] [prev in thread] [next in thread]