From: | <o(dot)lepretre(at)gmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | oldest WAL files not removed |
Date: | 2021-09-01 10:48:51 |
Message-ID: | 053c01d79f1e$f3ed4f10$dbc7ed30$@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Looking at WAL folder after a crash, I noticed that new files after
restarting overwrite the more recent files before the crash and not the
oldest, which was what I expected.
Is that normal ? I got only one file marked .deleted. Does that happens
when a WAL file hase been completed updated in the database and if then
while all oldest files aren't marked .deleted after restarting ?
Example :
Crash occurs Aug 31 22:03 which is the more recent Wal file, the oldest file
is Aug 30 17:20 (and 105 files between those two)
After restarting Aug 30 17:20 is still there, Aug 31 22:03 disappeared, one
new file is Sep 1 12:15 marked .deleted (restarting date) and one new Sep 1
12:36 which I guess is normal. Right now, I see an new wal file and the
previous one marked .deleted which is ok.
Why are the oldest wal files still there ?? Can I remove them ?
Hope I'm clear enough and thanks for explanations,
Olivier
From | Date | Subject | |
---|---|---|---|
Next Message | sivapostgres@yahoo.com | 2021-09-01 11:44:11 | Re: New Server for PostgreSQL |
Previous Message | Mario Emmenlauer | 2021-09-01 08:55:23 | Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0 |