Difference between revisions of "Moving Temp Folders"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) |
Kevin Wilkie (Talk | contribs) |
||
Line 11: | Line 11: | ||
Edit the postgres.conf file and change | Edit the postgres.conf file and change | ||
stats_temp_directory = 'c:/temp/' | stats_temp_directory = 'c:/temp/' | ||
+ | |||
+ | Restart postgres and required services |
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/'
Restart postgres and required services