Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Tue, 17 Oct 2006 09:55:08 -0400
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
- Follow-Ups:
- References:
- could not write to hash-join temporary file: No space left on device
- From: Sean Davis
- could not write to hash-join temporary file: No space left on device
- Prev by Date: Re: [SQL][GENERAL] Any documatation about porting from Oracle to PostgreSQL
- Next by Date: Re: could not write to hash-join temporary file: No space left on device
- Previous by thread: could not write to hash-join temporary file: No space left on device
- Next by thread: Re: could not write to hash-join temporary file: No space left on device
- Indexes: