Message-ID: <2ad9e2b296875c15d583aebc074755a613289595.camel@cybertec.at>
Subject: Re: vacuumlo
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Atul Kumar <akumar14871@gmail.com>
Cc: Ian Dauncey <Ian.Dauncey@bankzero.co.za>,
	"pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Date: Tue, 31 Aug 2021 10:52:10 +0200
In-Reply-To: 
 <CA+ONtZ5QVUnbijFK1nVOJ8d+_Edybmk9hzcoSKttaRyN=kDXAw@mail.gmail.com>
References: 
	<DBAPR08MB5687F490FBCC6065B1F6224BC0FE9@DBAPR08MB5687.eurprd08.prod.outlook.com>
	 <CAOBaU_YNAsTVHXS1UFw_XBt2YOZjwsJ3KMnZXrwqKb+86WAhpg@mail.gmail.com>
	 <DBAPR08MB5687AE8E62995E251E23E26BC0CB9@DBAPR08MB5687.eurprd08.prod.outlook.com>
	 <CA+ONtZ5h6rsJVi5ujqHuDo1GoetWLzRjmMq7tzx=bHRfY1q8Fw@mail.gmail.com>
	 <81e40a246988aa51c647b5e0b384055a78e47862.camel@cybertec.at>
	 <CA+ONtZ5QVUnbijFK1nVOJ8d+_Edybmk9hzcoSKttaRyN=kDXAw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-1.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/2ad9e2b296875c15d583aebc074755a613289595.camel%40cybertec.at>
Precedence: bulk

On Tue, 2021-08-31 at 11:15 +0530, Atul Kumar wrote:
> On Tuesday, August 31, 2021, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> 
> > On Tue, 2021-08-31 at 01:11 +0530, Atul Kumar wrote:
> > You may restart the postgres services. That temp file will be deleted automatically then.
> > 
> > No - orphaned files left behind from a crash will not be removed during a restart.
>
> Ok, but after restart it is safe to remove such files.

It is always save to remove those files.
The problem is to identify them.
Remove the wrong file, and your cluster is toast.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com