Re: Tablespace Problem

Kalai R <softlinne.kv@gmail.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