Re: temporary data after diskspace error - Mailing list pgsql-general

From Tom Lane
Subject Re: temporary data after diskspace error
Date
Msg-id 9650.1580141724@sss.pgh.pa.us
Whole thread Raw
In response to temporary data after diskspace error  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: temporary data after diskspace error
Re: temporary data after diskspace error
List pgsql-general
Willy-Bas Loos <willybas@gmail.com> writes:
> And also: How can i make postgres clean up the files?
> Can it be done without restarting the cluster?
> Will restarting it help?

A restart will clean out temp files.  I don't think there's any
terribly safe way to do it without that.  You could manually
remove such files that haven't been accessed recently, but the
risk of human error is high.

            regards, tom lane



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: temporary data after diskspace error
Next
From: Tanja Savic
Date:
Subject: RE: PostgresSQL 10 on remote server - Socket is not connected(0x00002749/10057)