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