Difference between revisions of "Moving Temp Folders"

From Observer GigaFlow Support | VIAVI Solutions Inc.
Jump to: navigation, search
(Created page with "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 ...")

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/'