Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.

PostgreSQL discovery

Log in to subscribe to topics and get notified when content changes.

PostgreSQL discovery

Discovery creates or updates a CMDB record when it detects a running instance of PostgreSQL on UNIX systems.

Credentials and other prerequisites

These credentials are required:

The user must have root-level access to the database to access the postgresql.conf file.

Classifiers, patterns, and probes

Classifier Trigger probes
PostgreSQL Instance
  • PostgreSQL - Configuration (add the must_sudo parameter to this probe)
  • PostgreSQL - Version

Data collected

Table 1. Data Collected by Discovery on PostgreSQL instances
Label Table Name Field Name Source
Name cmdb_ci_db_postgresql_instance name PostgreSQL Instance@hostname
Data Directory cmdb_ci_db_postgresql_instance data_dir running process
TCP port cmdb_ci_db_postgresql_instance tcp_port running process
SQL Configuration cmdb_ci_db_postgresql_instance postgres_conf data_directory/postgresql.conf
Version cmdb_ci_db_postgresql_instance version postmaster/postgres