Re: could not write to hash-join temporary file: No space left on device - Mailing list pgsql-novice

From Tom Lane
Subject Re: could not write to hash-join temporary file: No space left on device
Date
Msg-id 16775.1161093308@sss.pgh.pa.us
Whole thread Raw
In response to could not write to hash-join temporary file: No space left on device  (Sean Davis <sdavis2@mail.nih.gov>)
Responses Re: could not write to hash-join temporary file: No space left on device  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-novice
Sean Davis <sdavis2@mail.nih.gov> writes:
> Just a quick question, but where is the temporary directory that this error is
> complaining about?  I have plenty of disk space, but just need to know how to
> move things around....

$PGDATA/base/yourdboid/pgsql_tmp, or something close to that.  You can
replace that subdirectory by a symlink if you need to.  For security,
be sure the referenced directory is postgres-owned and mode 700.

            regards, tom lane

pgsql-novice by date:

Previous
From: Shane Ambler
Date:
Subject: Re: Subquery in INSERT?
Next
From: Sean Davis
Date:
Subject: Re: could not write to hash-join temporary file: No space left on device