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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: sdavis2(at)mail(dot)nih(dot)gov
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: could not write to hash-join temporary file: No space left on device
Date: 2006-10-17 13:55:08
Message-ID: 16775.1161093308@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sean Davis <sdavis2(at)mail(dot)nih(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Sean Davis 2006-10-17 13:59:39 Re: could not write to hash-join temporary file: No space left on device
Previous Message Harald Armin Massa 2006-10-17 13:22:49 Re: Can we convert from Postgres to Oracle !!???