Re: Log files polluted with permission denied error messages after every 10 seconds

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Log files polluted with permission denied error messages after every 10 seconds
Date: 2021-03-07 23:38:02
Message-ID: YEVj2uOY9XNlipeD@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Mar 07, 2021 at 11:45:26AM +0200, Andrus wrote:
> Should files with .deleted extension deleted manually to save disk space ?
> May of them have dates before today.

RemoveOldXlogFiles() would discard any of those .deleted files because
they don't match a legal WAL segment name, so checkpoints are not able
to work on them even in the future. I would avoid meddling with
anything that a backend may finish to touch while running, but that
should not really matter here as they are just never chosen for
deletion. Piling up those files is not a good thing, so while you
still need to figure out what's causing those files to remain around
on your side, perhaps we should improve the situation in the backend
itself.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-03-07 23:38:54 Re: Vacuuming by non owner/super users?
Previous Message Paul McGarry 2021-03-07 23:14:01 Vacuuming by non owner/super users?