Temp file space (Re: creating an index with tablespace on a dedicated filesystem)

From: Glen Parker <glenebob(at)nwlink(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Temp file space (Re: creating an index with tablespace on a dedicated filesystem)
Date: 2006-12-14 19:34:18
Message-ID: 4581A73A.6070102@nwlink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message objectmodelol 2006-12-14 20:03:36 Failed to set permision Win2k3-PG Installation Issues
Previous Message Glen Parker 2006-12-14 19:31:07 Re: could not write to log -> PANIC -> System down