Moving Temp Folders

From Observer GigaFlow Support | VIAVI Solutions Inc.
Jump to: navigation, search

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

Give "network service" full access to the folder

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