立即与支持人员聊天
与支持团队交流

Foglight Evolve 9.2 - Installing Foglight on Windows with an External PostgreSQL Database

Before Installing Foglight Installing Foglight
Preparing to install Installing a new version of the Management Server Installed directories Foglight settings HP patch checking tool Uninstalling Foglight Upgrading the Management Server Installing Foglight FAQ
Running the Management Server Installing and Upgrading Cartridges Installing Agents

Option 2 - Run SQL scripts to configure the 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.
a
psql -U <DBA_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_drop_db.sql
b
psql -U <DBA_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_create_db.sql
c
psql -U <foglight_username> -d <dbname> -W -f <foglight_home>\scripts\postgresql_create_schema.sql
d
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

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:
1
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.
2
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.

Starting and stopping the Management Server

The following sections describe how to start and stop the Management Server:

•
Starting the Management Server
•
Running the Management Server as a Windows service
•
Stopping the Management Server
•
Starting and stopping the Management Server in High Availability mode
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级