Thread: could not write to hash-join temporary file: No space left on device

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....

Sean

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

On Tuesday 17 October 2006 09:55, Tom Lane wrote:
> 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.

That's kinda what I thought--thanks for clarifying.  I have seen this message
only once on a HUGE table, so I just couldn't find the offending file system
easily by free space.

Sean