Thread: WAL segmentes names in wrong order?
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
I thought it could not be possible.
I'm doing some tests with archiving and base backups.
Never performed a restore so far.
Sometimes I restared the server due to changes in conf files.
Never copied or manually handled files in pg_xlog dir.
What am I missing?
Regards
Pupillo
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
On Thu, Nov 03, 2016 at 11:28:57AM +0100, Tom DalPozzo wrote: > What am I missing? David already explained, but you might want to read also: https://www.depesz.com/2011/07/14/write-ahead-log-understanding-postgresql-conf-checkpoint_segments-checkpoint_timeout-checkpoint_warning/ depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/
Hi,
so if I understand right, the ...DE file's previous name, was less than ...C6, then it was renamed in big advance for later use. I was missing this advance.
Thanks!
Pupillo
2016-11-03 11:45 GMT+01:00 hubert depesz lubaczewski <depesz@depesz.com>:
On Thu, Nov 03, 2016 at 11:28:57AM +0100, Tom DalPozzo wrote:
> What am I missing?
David already explained, but you might want to read also:
https://www.depesz.com/2011/07/14/write-ahead-log- understanding-postgresql-conf- checkpoint_segments- checkpoint_timeout-checkpoint_ warning/
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
On 11/3/16 1:16 PM, Tom DalPozzo wrote: > so if I understand right, the ...DE file's previous name, was less than > ...C6, then it was renamed in big advance for later use. I was missing > this advance. That is correct. -- -David david@pgmasters.net