Page tree

The PATROL for PostgreSQL fix pack corrects issues reported in the earlier versions of this product. This topic includes instructions for downloading and installing this fix pack.

What's new

Updated system requirements

Added support for the following system requirement resources.

PostgreSQL database version
  • 10.1
  • 10.0

Note: Removed support for PostgreSQL database version 9.2.

TrueSight Operations Management
  • 11.0.00
Operating system
  • Red Hat Enterprise Linux AS/ES version 6.x thru 7.4 for x86 (64-bit)

For more system requirement information, see System requirements.

New custom query operations

You can use the Value parameter in the PostgreSQL Custom 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.

ComponentEPD linkInstallation file name
PATROL for PostgreSQL

Linux download link Open link

Windows download link Open link

  • Linux  – PGR_ALL_100001.tar
  • Windows –

PATROL Installation Utility 11.0.00

Linux download link Open link

Windows download link Open link

  • Linux  – ins_LINUX_11000.tar
  • Windows –

Installing the fix pack


The PATROL for PostgreSQL KM fix pack contains all of the files that are required for a complete product release. You can install the fix pack over an existing installation of the KM, or as a fresh installation.

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 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
    • 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
    • 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
  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 (

  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.