Re: Failed CLUSTER seems to leave files behind

On Thu, Nov 03, 2005 at 10:03:16AM -0500, Tom Lane wrote:
> Antti Salmela <asalmela(at)iki(dot)fi> writes:
> > Failed CLUSTER due to insufficient disk space seems to leave temporary files
> > behind at least on 7.4.7.
>
> What was the "failure" exactly? If you ran out of disk space for the
> data files, I'd have expected it to reclaim the temp files. On the
> other hand, running out of disk space for WAL would lead to a
> database-wide PANIC, and there's no mechanism for getting rid of
> unreferenced files after a PANIC. (IIRC this is intentional ---
> deleting files that we think aren't used seems too risky.)

PANIC'ed.

> This is one of several reasons for keeping WAL and data on separate
> disks ...

Now I know better..

> > Is it safe to remove these files manually?
>
> Yeah, if you're sure they correspond to no pg_class.relfilenode entry.

Thanks.

--
Antti Salmela