1.0.00.01: Fix Pack 1 for PATROL for PostgreSQL

What's new

Updated system requirements

Added support for the following system requirement resources.

For more system requirement information, see System-requirements.

New custom query operations

You can use the Value parameter in the Custom-SQL-Query-PGR_CUSTOM_SQL monitor type to create a monitor that has an assigned value based on the result of the query. As long as the query result has exactly one value, the PostgreSQL KM can use this result to assign a monitor for the value.

Before this fix pack, the value had to be a numeric data type within the database for the monitor to work.

With this fix pack release, the KM can also take a text-based data type that has a numeric value and uses it as a numeric data type with the monitor.  

For more information, see Using custom queries.

To download the installation files

The following table provides links to the pages in the EPD website that contain the installation files for this product. From the EPD page, you can select and download the installation files for your platform. Access to the EPD website requires that you provide your BMC Support credentials. You might also be prompted to complete the Export Compliance Form.

Installing the fix pack

Before you begin

You must install the fix pack on the following computers:

• Hosts running a PATROL Agent that is assigned to monitor a PostgreSQL database
• Hosts with the PATROL Console (if this console is required)
• Systems with the TrueSight Operations Management Presentation Server KM repository

Before you install the fix pack, complete the following steps:

1. Stop the PATROL Agent.
2. Back up the PATROL_CACHE directory.
3. Delete all of the PATROL for PostgreSQL files from the PATROL_CACHE directory.
4. Back up the PATROL_HOME/lib/knowledge and PATROL_HOME/lib/psl directories.

To install the PATROL for PostgreSQL KM 1.0.00.01 fix pack, if TrueSight Operations Management KM push is not used, and the PATROL console is in use:

1. Extract the installation utility:
   • For Windows, double-click ins_WINDOWS_11000.zip.
   • For Linux, run the following command
     tar -xvf ins_ALL_11000.tar
     The contents of the files are extracted into the bmc_products sub-directory.
2. Extract the fix packfiles:
   • For Windows, double-click  PGR_ALL_100001.zip
   • For Linux,  run the following command
     tar -xvf PGR_ALL_100001.tar
     The contents of the files are extracted into the bmc_products sub-directory. 
3. From the bmc_products directory, run the installation utility as appropriate for your operating system:
   • For Windows, double-click setup.exe.
   • For Linux, run setup.sh
4. Follow the on-screen instructions until the Select Products and Components to Install page is displayed. 
5. On the Select Products and Components to Install page, select PATROL for PostgreSQL Fix Pack (1.0.00.01)

6. Follow the on-screen instructions to complete the installation.

   After you complete the installation steps, you can delete the temporary directory and its contents.