Re: System crash and trying to run vacuum getting errors - Mailing list pgsql-general

Dave Smith <dave.smith@candata.com> writes:
> After a abnormal system shutdown I am trying to run a
> vacuum full verbose ANALYZE and getting the following error.

> NOTICE:  Analyzing classification
> NOTICE:  RelationBuildDesc: can't open pg_temp_5821_0: No such file or
> directory
> NOTICE:  --Relation pg_temp_5821_0--
> ERROR:  _mdfd_getrelnfd: cannot open relation pg_temp_5821_0: No such
> file or directory

You should be able to DROP that table even though it doesn't have an
underlying file.  My guess is that you are running atop a non-crash-safe
filesystem and it lost the directory entry for the just-created file.
You might want to think about switching to a journaling file system.

            regards, tom lane