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


	NOTE: For agents that are installed individually, run the agent installer executable and set up the agent on each machine you want to monitor with that type of agent. The Agent Manager defines agents with their Agent Package name. When displayed in the Create Agent dialog, the agent names are prepended with the cartridge name.

Depending on the type of agent that you installed, you may need to edit its properties to configure it for the part of your environment that you want to monitor. For information about agent properties, see the Administration and Configuration Guide and the User Guide for the cartridge with which the agent was included.

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.

Stop the Management Server.

Start the embedded database manually:

<foglight_home>\bin\runDb.sh

Export the database content:

<foglight_home>\postgresql\bin\pg_dump ‑U root -h localhost -p 15432 foglight > <foglight_home>/foglight_dump.sql

Shut down the database:

<foglight_home>\bin\shutdownDb.sh

Connect to the external PostgreSQL instance:

<foglight_home>\postgresql\bin\psql -h [postgresql host] -p [postgresql port] -U [superuser] [dbname]

Create the “foglight” user by running:

postgres=# CREATE USER "foglight" WITH PASSWORD 'foglight';

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;

Configure the Management Server to use this new database by opening the following file:

<foglight_home>\config\server.config

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.

Restart the Management Server.

Verify that the Management Server starts successfully:

Open the most recent Management Server log file in <foglight_home>\logs.

Look for the message Forge Server startup completed and ensure that there are no errors listed after it.

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.

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

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

Agent installers

Remote agent installation

Appendix: Switching from an Embedded to an External Database