Kalai R <softlinne(dot)kv(at)gmail(dot)com> writes:
> I have found a problem in my database. The following error occurs sometime
> not any specific database operation.
> ERROR:XX000:count not create temporary file
> "pg_tblspc/86014/pgsql_tmp/pgsql_tmp3568.0":No
> such file or directory.
Does that pgsql_tmp directory exist? If not, does its parent directory
have the right ownership and permissions to let the server create it?
Note that pg_tblspc/86014 is presumably a symlink --- you need to look
at the directory the symlink points to.
regards, tom lane