Difference between revisions of "Moving Temp Folders"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) (Created page with "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 ...") |
Kevin Wilkie (Talk | contribs) |
||
Line 1: | Line 1: | ||
Windows | Windows | ||
Move postgres temp folders onto faster disks | Move postgres temp folders onto faster disks | ||
+ | |||
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 |
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/'