1.1.00 enhancements and patches

Review the PATROL for PostgreSQL enhancements and patches for features that will benefit your organization and to understand changes that might impact your users. For the list of issues resolved in this release, see Known-and-corrected-issues.

1.1.31

1.1.30

Added execution options for custom SQL queries

Users can choose to execute custom SQL queries on the primary, standby, or all instances. For more information, see Configuring-the-PostgreSQL-KM-in-TrueSight-or-Central-Monitoring-Administration and Configuring-the-PostgreSQL-Global-database.

PostgreSQL version 17.x database support

The PostgreSQL knowledge module, version 1.1.30, now supports PostgreSQL version 17.x database. For more information, see System requirements.

1.1.22

For more information about the corrected issues in this version, see Known and corrected issues.

1.1.21

Added a condition for long-running queries

Users can filter long-running queries by using a query condition to avoid unnecessary alerts for some queries that are expected to run longer.

For more information, see the following references:

Learn about the Last Archive Failed parameter

The PostgreSQL Database Metrics (PGR_DB_METRICS) monitor type includes an additional parameter for Last Archive Failed (DBLastArchiveFailed).

1.1.20

Enhanced support for PostgreSQL configuration

Use the PostgreSQL global configuration to apply monitoring settings across various environments. This process simplifies administrative tasks by minimizing configuration efforts.

For more information, see Global Configuration for monitoring PostgreSQL database.

Upgrade to PostgreSQL JDBC Driver version 42.7.3

The PostgreSQL JDBC Driver version 42.7.3 is supported.

For more information, see PostgreSQL JDBC Driver license.

1.1.11

Enhanced metrics

These monitor types include additional parameters for:

PostgreSQL Databases (PGR_DB_CONTAINER)

PostgreSQL Database Metrics (PGR_DB_METRICS)

Vaccum Full Query Count (DBNumVaccumFullQueryCount)

PostgreSQL Database LockMode(PGR_LOCK_MODE)

AllExclusiveLock (NumOfAllExclusiveLock)

1.1.10

Ability to monitor the wait time in PATROL for PostgreSQL

You can enable the monitoring for the Wait Time attributes in the PostgreSQL database. This helps you in identifying the queries that take more time to execute and the issues in your database even before they occur.
For more information, see Monitoring of wait time attributes of SQL query.

Vault support in PATROL for PostgreSQL

Access your secret credentials from the vault for the monitoring of the PostgreSQL database.
Currently, PATROL for PostgreSQL supports only the CYBERARK vault.
For more information, see Enabling vault access.

1.1.02

Security enhancements

BMC PATROL for PostgreSQL patch contains the following third-party software upgrade for security enhancement:

jackson-annotations-2.14.1.jar
jackson-databind-2.14.1.jar
jackson-core-2.14.1.jar

1.1.01

Enhanced PostgreSQL attributes

PATROL for PostgreSQL includes monitor types and attributes that provides you with data that you can use to see the condition and activity of the PostgreSQL database instance.