Knowledgebase

Where can I change the storage location of the local PostgreSQL database?

Question / Problem

Where can I change the storage location of the local PostgreSQL database?

Answer / Solution

To change the location of the local PostgreSQL database, please follow these steps:


1. Close SpaceObServer and stop the scan service, provided no scan is currently running.

2. Open Windows Services and stop the "SpaceObServer PostgreSQL" service.

3. Copy the entire contents of the "C:\ProgramData\JAM Software\SpaceObServer\data" directory to a new location for the database (e.g., D:\Database\PostgreSQL\Data\).

4. Open the Registry Editor and navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SpaceObServer PostgreSQL."

5. Modify the "ImagePath" value by replacing the parameter -D "C:\ProgramData\JAM Software\SpaceObServer\data" with your new location ( -D "D:\Database\PostgreSQL\Data\").

6. Restart the "SpaceObServer PostgreSQL" service and verify that you can connect to the database via SpaceObServer.

7. Delete the old data directory "C:\ProgramData\JAM Software\SpaceObServer\data".

Need further help getting started?

You did not find what you were looking for? Please contact us so we can provide an answer to your question.

Contact Form