Difference between revisions of "Moving Temp Folders"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) |
Kevin Wilkie (Talk | contribs) |
||
Line 6: | Line 6: | ||
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 | ||
− | + | ||
+ | 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 | mklink /D "d:\Program Files\PostgreSQL\10\data\base\pgsql_tmp" c:\temp\pgsql_tmp | ||
Latest revision as of 14:53, 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
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