temp space on different location
Started by Mario Weilgunialmost 24 years ago2 messagesgeneral
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?
Re: temp space on different location
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