oldest WAL files not removed
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
RE: oldest WAL files not removed
Hy Kyotaro, Thanks for this explanation. I joined the files to be complete. Have a good day, Olivier 30/08/2021 20:4016 777 216 0001008E0088 30/08/2021 20:5816 777 216 0001008E0089 30/08/2021 21:0916 777 216 0001008E008A 30/08/2021 21:2416 777 216 0001008E008B 31/08/2021 10:5616 777 216 0001008E008D 31/08/2021 11:0416 777 216 0001008E008E 31/08/2021 11:0516 777 216 0001008E0090 31/08/2021 11:0516 777 216 0001008E0092 31/08/2021 11:0516 777 216 0001008E0091 31/08/2021 11:1216 777 216 0001008E008F 31/08/2021 11:2116 777 216 0001008E0093 31/08/2021 11:2916 777 216 0001008E0095 31/08/2021 11:3016 777 216 0001008E0096 31/08/2021 11:3616 777 216 0001008E0098 31/08/2021 11:3716 777 216 0001008E0099 31/08/2021 11:3716 777 216 0001008E009A 31/08/2021 11:3716 777 216 0001008E009B 31/08/2021 11:3716 777 216 0001008E009D 31/08/2021 11:3716 777 216 0001008E009E 31/08/2021 11:3716 777 216 0001008E009C 31/08/2021 11:3716 777 216 0001008E009F 31/08/2021 11:3716 777 216 0001008E00A0 31/08/2021 11:3716 777 216 0001008E00A2 31/08/2021 11:3716 777 216 0001008E00A3 31/08/2021 11:3716 777 216 0001008E00A4 31/08/2021 11:3716 777 216 0001008E00A1 31/08/2021 11:3716 777 216 0001008E0097 31/08/2021 11:3816 777 216 0001008E0094 31/08/2021 12:0816 777 216 0001008E00A6 31/08/2021 12:0816 777 216 0001008E00A8 31/08/2021 12:0816 777 216 0001008E00A7 31/08/2021 12:1216 777 216 0001008E00A9 31/08/2021 12:2116 777 216 0001008E00AC 31/08/2021 12:2116 777 216 0001008E00AB 31/08/2021 12:2116 777 216 0001008E00AE 31/08/2021 12:2116 777 216 0001008E00AD 31/08/2021 12:2716 777 216 0001008E00AA 31/08/2021 14:2716 777 216 0001008E00A5 31/08/2021 14:3616 777 216 0001008E00B0 31/08/2021 14:3616 777 216 0001008E00B3 31/08/2021 14:3616 777 216 0001008E00B2 31/08/2021 14:3616 777 216 0001008E00B5 31/08/2021 14:3616 777 216 0001008E00B4 31/08/2021 14:4216 777 216 0001008E00B1 31/08/2021 14:4816 777 216 0001008E00AF 31/08/2021 14:4816 777 216 0001008E00B6 31/08/2021 14:5516 777 216 0001008E00B9 31/08/2021 14:5516 777 216 0001008E00BB 31/08/2021 14:5516 777 216 0001008E00BA 31/08/2021 15:0216 777 216 0001008E00B8 31/08/2021 16:0116 777 216 0001008E00B7 31/08/2021 16:0416 777 216 0001008E00BD 31/08/2021 16:1116 777 216 0001008E00C0 31/08/2021 16:1116 777 216 0001008E00BF 31/08/2021 16:1116 777 216 0001008E00C2 31/08/2021 16:1116 777 216 0001008E00C1 31/08/2021 16:1216 777 216 0001008E008C 31/08/2021 16:1716 777 216 0001008E00BE 31/08/2021 17:3116 777 216 0001008E00BC 31/08/2021 17:3816 777 216 0001008E00C4 31/08/2021 17:4116 777 216 0001008E00C7 31/08/2021 17:4116 777 216 0001008E00C6 31/08/2021 17:4116 777 216 0001008E00C5 31/08/2021 17:4116 777 216 0001008E00C9 31/08/2021 17:4716 777 216 0001008E00C8 31/08/2021 17:5116 777 216 0001008E00C3 31/08/2021 17:5316 777 216 0001008E00CA 31/08/2021 17:5816 777 216 0001008E00CD 31/08/2021 17:5816 777 216 0001008E00CC 31/08/2021 17:5816 777 216 0001008E00CF 31/08/2021 17:5816 777 216 0001008E00CE 31/08/2021 18:0116 777 216 0001008E00CB 01/09/2021 12:1516 777 216 0001008E0061.deleted 01/09/2021 16:3516 777 216 0001008E0086.deleted 01/09/2021 16:3516 777 216 0001008E0087 -Message d'origine- De : Kyotaro Horiguchi Envoyé : jeudi 2 septembre 2021 04:41 À : o.lepre...@gmail.com Cc : pgsql-gene...@postgresql.org Objet : Re: oldest WAL files not removed At Wed, 1 Sep 2021 12:48:51 +0200, wrote in > Hi, > > > > Looking at WAL folder after a crash, I noticed
