Foglight 5.9.7 - Installing Foglight on Windows with an External PostgreSQL Database

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]):

•

[dbtype]_drop_db.sql

•

[dbtype]_create_db.sql

•

[dbtype]_create_schema.sql

•

[dbtype]_populate_db.sql

You can review these scripts before running them.

You must run the configured scripts against the database using a third-party tool.

To perform manual database configuration:


	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.

psql -U <DBA_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_drop_db.sql

psql -U <DBA_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_create_db.sql

psql -U <foglight_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_create_schema.sql

psql -U <foglight_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_populate_db.sql

After you have run all four scripts, you can start the Management Server. Proceed to Starting and stopping the Management Server.

Initializing the database

For external databases, once the database has been successfully initialized, you can run Foglight.

Accessing the database

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:

•

Connecting to the embedded database to check the database status or data.

•

Backing up and restoring the PostgreSQL database.

To change the console code page:

Set the code page by entering the following command:

cmd.exe /c chcp 1252

where: 1252 is a code page that is appropriate for German; you must replace it with your value.

Set the console font to “Lucida Console”, because the raster font does not work with the ANSI code page.

For more information, see “Notes for Windows Users” in the PostgreSQL documentation at
http://www.postgresql.org/docs/9.4/static/app-psql.html.