Re: temporary data after diskspace error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: temporary data after diskspace error
Date: 2020-01-27 16:15:24
Message-ID: 9650.1580141724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Willy-Bas Loos <willybas(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

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