How to change postgres data store on Windows GigaFlow?

The new versions of GigaFlow is using a managed postgres.

Let's say you want to change your data directory from the default (c:\GigaFlow\Flow\data) to a custom location (c:\benoit\data)

This how to change the directory of postgres data folder : 

• Stop GigaFlow service
• Stop GFPostgresSvc
• Move/Copy your original directory (c:\GigaFlow\Flow\data) to the new location (c:\benoit\data)

Edit the ImagePath registry :

• HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\GFPostgresSvc\ImagePath

Change to "c:\GigaFlow\Flow\pgsql\bin\pg_ctl.exe" runservice -N "GFPostgresSvc" -D "c:\benoit\data" -w

Edit the postgresqlData and sqlData :

• HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\AnuViewSoftware\Flow\postgresqlData
• HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\AnuViewSoftware\Flow\sqlData

And change to c:\benoit\data

Important !!

 The new data directory requires proper permissions in order to allow the service to have access.
 - Open Windows Explorer
 - Go to the new PostgreSQL data directory in Windows Explorer
 - Right-click and select Properties
 - Click on the Security
 - Click on Add to add the "Network Service" user
 - Give the "Network Service"user the Full permission to Modify the directory

Restart GFPostgresSvc and restart GigaFlow services