Resolution: This is now documented since the 5.7.3 FMS Windows Installation doc in
Switching from an Embedded to an External Database1 Stop the Management Server.
2 Start the embedded database manually:
<foglight_home>\bin\runDb.sh
3 Export the database content:
<foglight_home>\postgresql\bin\pg_dump -U root -h localhost -p 15432 foglight >
<foglight_home>/foglight_dump.sql
4 Shut down the database:
<foglight_home>\bin\shutdownDb.sh
5 Connect to the external PostgreSQL instance:
<foglight_home>\postgresql\bin\psql -h [postgresql host] -p [postgresql port] -U [superuser] [dbname]
6 Create the “foglight” user by running:
postgres=# CREATE USER "foglight" WITH PASSWORD 'foglight';
7 Re-import the data dump:
postgres=# \i <foglight_home>/foglight_dump.sql
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
NOTE: Use slash in the path when executing this command on a Windows platform.
Some errors may appear like in the following example:
psql:dump_db.sql:51991: ERROR: role "root" does not exist
psql:dump_db.sql:51992: ERROR: role "root" does not exist
It is safe to ignore these errors because the embedded database includes the super user root but
the external may not.
Also, the foglight_dump.sql includes these two statements at the end of the file:
REVOKE ALL ON SCHEMA public FROM root;
GRANT ALL ON SCHEMA public TO root;
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
8 Configure the Management Server to use this new database by opening the following file:
<foglight_home>\config\server.config
9 Update the following values in the server.config file:
server.database.host = "[postgresql host]";
server.database.port = "[postgresql port]";
server.database.name = "[postgresql dbname]";
server.database.embedded = "false";
10 Restart the Management Server.
11 Verify that the Management Server starts successfully:
a Open the most recent Management Server log file in <foglight_home>\logs.
b Look for the message Forge Server startup completed and ensure that there are no errors listed after it.
12 Verify that the Management Server connects to the migrated external PostgreSQL database. There are two ways to do so:
• Open the most recent Management Server log file in <foglight_home>\logs. Verify that the parameter server.database.host lists the external PostgreSQL database host as its value and that server.database.embedded is set to false.
• Log in to the browser interface and navigate to Dashboards > Administration > Setup & Support> Management Server Configuration. Verify that the external PostgreSQL database host is listed in the Database Host box and that Embedded is set to false.
STATUS: FDOC-7878 Released in Foglight_5.7.5.3_InstallationGuide_WindowsEmbedded.pdf due Feb 2016