Search Postgresql Archives

Re: WAL segmentes names in wrong order?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux