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(at)pgmasters(dot)net