How to relocate temporary files

From: rray(at)tcmail(dot)mstc(dot)state(dot)ms(dot)us
To: pgsql-admin(at)postgresql(dot)org
Subject: How to relocate temporary files
Date: 2004-10-26 13:54:49
Message-ID: Pine.LNX.4.58.0410260828570.13062@rray.drdc.mstc.ms.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a database that's about 18GBs.
[base]# du -hs 17165
18G 17165

Occasionally someone runs a query and they get
"could not write block 460593 of temporary file: No space left on device"
At present the filesystem for the database has about 3GB free.

I'd like to give the temporary files a filesystem of their own.
What would be the preferred method?

Thanks
Richard Ray

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-10-26 15:18:38 Limiting postmaster to listen in a particular ip address only
Previous Message Tom Lane 2004-10-26 03:13:39 Re: Question: drop database problem