On Mon, 2024-03-04 at 00:04 +0100, Peter J. Holzer wrote:
> On 2024-02-28 20:30:35 +0100, Dimitrios Apostolou wrote:
> > On Wed, 28 Feb 2024, Laurenz Albe wrote:
> > > On Wed, 2024-02-28 at 12:16 +0100, Dimitrios Apostolou wrote:
> > > > So what is the moral of the story? How to guard against this?
> > >
> > > Monitor disk usage ...
> >
> > It happened *fast*. And it was quite a big suprise coming
> > from "just" a disk-full situation.
>
> Been there.
>
> To prevent this in the future I wrote a small script to monitor disk
> space (on multiple hosts and multiple file systems) every few seconds
> and invoke another script (which just terminates all database
> connections - a bit drastic but effective) if free space runs low:
> https://github.com/hjp/platzangst
And I maintain that "temp_file_limit" is the best solution.
Yours,
Laurenz Albe