Moving Temp Folders
From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 13:38, 17 June 2020 by Kevin Wilkie (Talk | contribs)
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/'