Difference between revisions of "Moving Temp Folders"

Revision as of 13:38, 17 June 2020

Windows Move postgres temp folders onto faster disks

Remove original folder (in this case d:\Program Files\PostgreSQL\10\data\base\pgsql_tmp)

Create a new location on the new drive

mkdir c:\temp\psql_tmp

then create a symlink

mklink /D  "d:\Program Files\PostgreSQL\10\data\base\pgsql_tmp" c:\temp\pgsql_tmp

Edit the postgres.conf file and change

stats_temp_directory = 'c:/temp/'

Restart postgres and required services