Difference between revisions of "Moving Temp Folders"

From Observer GigaFlow Support | VIAVI Solutions Inc.
Jump to: navigation, search
Line 3: Line 3:
  
 
Remove original folder (in this case d:\Program Files\PostgreSQL\10\data\base\pgsql_tmp)
 
Remove original folder (in this case d:\Program Files\PostgreSQL\10\data\base\pgsql_tmp)
 +
 
Create a new location on the new drive  
 
Create a new location on the new drive  
 
  mkdir c:\temp\psql_tmp
 
  mkdir c:\temp\psql_tmp

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