Skip site navigation (1) Skip section navigation (2)

Re: How to relocate temporary files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rray(at)tcmail(dot)mstc(dot)state(dot)ms(dot)us
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to relocate temporary files
Date: 2004-10-29 17:55:44
Message-ID: 17904.1099072544@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
rray(at)tcmail(dot)mstc(dot)state(dot)ms(dot)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

In response to

pgsql-admin by date

Next:From: Vishal Kashyap @ [Sai Hertz And Control Systems]Date: 2004-10-29 20:15:50
Subject: Re: psql won't "createdb"
Previous:From: Nikhil ParvaDate: 2004-10-29 17:45:54
Subject: unregister nikhil@fleetship.com

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group