| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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:59:39 |
| Message-ID: | 200610170959.39942.sdavis2@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tuesday 17 October 2006 09:55, Tom Lane wrote:
> 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.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2006-10-17 15:34:45 | Re: Subquery in INSERT? |
| Previous Message | Tom Lane | 2006-10-17 13:55:08 | Re: could not write to hash-join temporary file: No space left on device |