Temp file space (Re: creating an index with tablespace on a dedicated filesystem) - Mailing list pgsql-general

From Glen Parker
Subject Temp file space (Re: creating an index with tablespace on a dedicated filesystem)
Date
Msg-id 4581A73A.6070102@nwlink.com
Whole thread Raw
In response to Re: creating an index with tablespace on a dedicated filesystem (postgresql 8.1.5)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)
List pgsql-general
Tom Lane wrote:
> Temp files are created in $PGDATA/base/yourdb/pgsql_tmp/.  If you have a
> mind to, you can replace that subdirectory with a symlink to a (suitably
> secure) directory elsewhere.

Tom, is it safe to assume that the contents of the temp directory do not
need to persist across Postgres restarts?  I may move ours to an
alternate volume, but the answer to this question will have an impact on
my backup strategy.

-Glen


pgsql-general by date:

Previous
From: Glen Parker
Date:
Subject: Re: could not write to log -> PANIC -> System down
Next
From: Paul Silveira
Date:
Subject: Re: shell script to populate array values