Chat now with support
Chat with Support

Foglight 5.9.1 - Installing Foglight on Windows with an Embedded PostgreSQL Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings Uninstalling Foglight Upgrading the Management Server
Running the Management Server Installing and Upgrading Cartridges Installing Agents Appendix: Switching from an Embedded to an External Database

Remote agent installation

You can install Foglight agents on any remote host on which the Agent Manager is installed. See the Agent Manager Guide.

For more information about remote agent installation, see the Administration and Configuration Guide.

 

Appendix: Switching from an Embedded to an External Database

You may find a performance improvement in Foglight if you use an external database.

This section describes how to migrate from using an embedded PostgreSQL® database with the Management Server to using an external PostgreSQL database.

1
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: You have to use slash in the path when executing this command on a Windows® platform. You may see some errors 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";
 
* 
NOTE: The server.database.password must also be updated if in Step 6 you set a different password than the embedded “foglight” user password.
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 your 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 your external PostgreSQL database host is listed in the Database Host box and that Embedded is set to false.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating