| 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: | Whole Thread | Raw Message | 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 |