Get Live Help
If you clicked Create during the database installation step, the SQL scripts in the<foglight_home>\scripts\sql directory are prepared with the provided configuration options. There are four SQL files for each database type ([dbtype]):
You can review these scripts before running them.
You must run the configured scripts against the database using a third-party tool.
NOTE: After running the psql command, you will be prompted for the password. The first two commands you need to type the <DBA_username> password, and the last two commands you need to type the <foglight_username> password.
After you have run all four scripts, you can start the Management Server. Proceed to Starting and stopping the Management Server.
For external databases, once the database has been successfully initialized, you can run Foglight.
Prior to accessing a PostgreSQL® database, you must set the proper code page for Windows® platforms.
The PostgreSQL interactive terminal (psql) is built as a “console application”. The Windows console windows use a different encoding than the rest of the system, so you must take special care when using 8-bit characters within psql. If psql detects a problematic console code page, it generates a warning at startup.
Examples of cases when you must run this command include:
For more information, see “Notes for Windows Users” in the PostgreSQL documentation at
The following sections describe how to start and stop the Management Server: