Postgres Pro
Downloads
Home   >   mailing lists

How to relocate temporary files - Mailing list pgsql-admin

From rray@tcmail.mstc.state.ms.us
Subject How to relocate temporary files
Date
Msg-id Pine.LNX.4.58.0410260828570.13062@rray.drdc.mstc.ms.gov
Whole thread Raw
Responses Re: How to relocate temporary files
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Shayne Patton
Date:
Subject: psql won't "createdb"
Next
From: "Lee Wu"
Date:
Subject: pg_ctl stop -m fast