Postgres Pro
Downloads
Home   >   mailing lists

Re: How to relocate temporary files - Mailing list pgsql-admin

From Tom Lane
Subject Re: How to relocate temporary files
Date
Msg-id 17904.1099072544@sss.pgh.pa.us
Whole thread Raw
In response to How to relocate temporary files  (rray@tcmail.mstc.state.ms.us)
List pgsql-admin
Tree view 
rray@tcmail.mstc.state.ms.us writes:
> I'd like to give the temporary files a filesystem of their own.
> What would be the preferred method?

Change the subdirectory $PGDATA/base/<yourdb>/pgsql_tmp/ into a symlink
to someplace on another filesystem.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nikhil Parva"
Date:
Subject: unregister nikhil@fleetship.com
Next
From: "Vishal Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: psql won't "createdb"