Kalai R <softlinne.kv@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
