Thread: temp space on different location

Is it possible to instruct postgres to use temporary space on a different
location in the filesystem? Clustering with DRBD would be a lot more
efficient if temporary data won't be copied to the other node. Any ideas?

Mario Weilguni <mweilguni@sime.com> writes:
> Is it possible to instruct postgres to use temporary space on a different
> location in the filesystem?

In 7.2, temp files are made in $PGDATA/base/dboid/pgsql_tmp/.  You could
replace the pgsql_tmp subdirectory(s) with a symlink to some other
directory.

            regards, tom lane