Re: WAL segmentes names in wrong order? - Mailing list pgsql-general

From David Steele
Subject Re: WAL segmentes names in wrong order?
Date
Msg-id c70a57f9-cfff-3b9d-3b65-44cb7f898111@pgmasters.net
Whole thread Raw
In response to WAL segmentes names in wrong order?  (Tom DalPozzo <t.dalpozzo@gmail.com>)
List pgsql-general
On 11/3/16 12:28 PM, Tom DalPozzo wrote:
> Hi,
> I found, in pg_xlog dir, several WAL segment files with old modification
> timestamp but with their names greater than more recent files.
> Ex.:
> 0000000100000000000000C6      modified today
> 0000000100000000000000DE      modified yesterday

This is completely normal.  WAL files are recycled so a file with a
later name can have an earlier timestamp.  What this means is it is
available but has not been used to record transactions yet.

So, 0000000100000000000000C6 is the end of your current WAL stream.

--
-David
david@pgmasters.net


pgsql-general by date:

Previous
From: Tom DalPozzo
Date:
Subject: WAL segmentes names in wrong order?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: WAL segmentes names in wrong order?