After you have imported the PostgreSQL server, and configured the resource name format if required, you can configure PostgreSQL in vRealize Hyperic.

Procedure

  1. Navigate to the Configuration Properties page for the PostgreSQL server instance.
  2. Enter the username for connecting to PostgreSQL in the postgresql.user text box.
  3. Enter the password for connecting to PostgreSQL in the postgresql.password text box.
  4. To limit the PostgreSQL tables that the agent discovers, enter a regular expression in the postgresql.table.regex text box.

    The default value All discovers all tables.

  5. To enable the discovery of PostgreSQL indexes, enter a regular expression in the postgresql.indexregex text box.

    The default value, Off, means that no indexes are discovered.

  6. To enable configuration tracking, select the server.config_track.enable checkbox.

    Configuration tracking for PostgreSQL is disabled by default. See Auto-Discovery. To enable configuration tracking and how to specify which files to track, see the vRealize Hyperic Administration Guide.

  7. (Optional) : To auto-discover PostgreSQL services (databases, tables, and indexes) and databases, select the Autodiscover Databases, indexes, and other services checkbox.

What to do next

  • Verify that metrics are collected in the Monitor tab.

  • vRealize Hyperic's PostgreSQL plug-in uses the PostgreSQL statistics collector to obtain metrics. Verify that the following parameter in PostgreSQLHome/data/postgresql.conf is set to Off.

    track_counts = true
  • If you edit postgresql.conf, restart PostgreSQL after saving your changes.