The format of resource names that the PostgreSQL plug-in assigns to PostgreSQL servers, databases, schemas and tables can be configured using agent properties.

About this task

If the plug-in manages only a single database, you can shorten schema and table names by removing the segment that identifies the associated database from the postgresql.index.name.format and postgresql.table.name.format properties.

If you configure a different format for PostgreSQL resources after importing resources with the default names, duplicate resources will exist in the vRealize Hyperic database. You can avoid this problem be deleting the existing resources before changing resource name properties.

Procedure

Define the required format in these agent properties:
  • postgresql.server.name.format

  • postgresql.database.name.format

  • postgresql.index.name.format

  • postgresql.table.name.format