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 -- Dave Smith CANdata Systems Ltd 416-493-9020 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster