Difference between revisions of "Moving Temp Folders"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) |
Kevin Wilkie (Talk | contribs) |
||
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/'