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
