From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Peter J. Holzer <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Orphan files filling root partition after crash
Date: Mon, 04 Mar 2024 05:07:34 +0100
Message-ID: <11bd4c047eb93a208a76a93f2601f231c2ed437e.camel@cybertec.at> (raw)
In-Reply-To: <20240303230428.6nvxibnhtbgq3h3q@hjp.at>
References: <d15a32be-915e-3cd8-4622-5a052d621f13@gmx.net>
<b76197c602b3466c6f5a50185e38526d150288b5.camel@cybertec.at>
<5233ff6e-f363-92a4-aa18-7a9392d35ad7@gmx.net>
<20240303230428.6nvxibnhtbgq3h3q@hjp.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: laurenz.albe@cybertec.at, hjp-pgsql@hjp.at, pgsql-general@lists.postgresql.org
Subject: Re: Orphan files filling root partition after crash
In-Reply-To: <11bd4c047eb93a208a76a93f2601f231c2ed437e.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox