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
