How to move server agent postgreSQL database files

The latest CentreStack Server Agent uses postgreSQL to manage tasks. By default, the postgreSQL database is stored under C:\ProgramData\Cloud Server Agent, on the server where server agent is installed.

It may cause issue if the C: drive size is limited. In that case, need to move the database file to a different drive.

. Stop Cloud Server Agent Access Service and Cloud Server Agent File Monitoring Service

. Stop gladpostgre sevice. This is the postgreSQL database service.

. Copy all files from C:\ProgramData\Cloud Server Agent to a different drive. Here, we copy the content to E:\Data\Cloud Server Agent

. Rename C:\ProgramData\Cloud Server Agent to something like 'Cloud Server Agent.old'.

. Open Command Prompt as Administrator. Go to C:\ProgramData. Run command

mklink /J "Cloud Server Agent" "<new path to the Cloud Server Agent Folder>".

In the example here, we run

mklink /J "Cloud Server Agent" "E:\Data\Cloud Server Agent"

Now, under C:\ProgramData, you'll see a link 'Cloud Server Agent', which links to the new 'Cloud Server Agent' folder. And you still see the renamed 'Cloud Server Agent.old'

. To clean some spaces, move 'Cloud Server Agent.old' to another folder as backup. Just in case.

. From Windows Services, start 'gladpostgre', Cloud Server Agent File Monitoring Service and Cloud Server Agent Access Service

. Start Server Agent Management Console. Go to Sync Status, Task Manager. Can see all the tasks.

. After server agent runs fine for couple of days, can delete 'Cloud Server Agent.old' folder.