PostgreSQL discovery

Discovery can find running instances of PostgreSQL on Windows and Linux systems.

Credentials and other prerequisites

These credentials are required:

• SSH credentials

• [optional] Applicative credentials

For a list of privileged commands that you need for Discovery and Service Mapping, see Service Mapping commands requiring a privileged user. This list includes commands that require elevated rights to discover and map Unix-based hosts in your organization.

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

Note:

For information on Probe to Pattern migration see the knowledge article KB0694477.

Classifiers, patterns, and probes

Classifier	Trigger probes	Patterns
PostgreSQL Instance	Horizontal Pattern: launches patterns PostgreSQL - Configuration* (add the must_sudo parameter to this probe) PostgreSQL - Version*	PostgreSQL DB

*For new instances, these probes are inactive on the classifier. Discovery uses patterns for discovery.

To use patterns, verify that the correct pattern is specified in the horizontal pattern probe on the classifier. See Add the Horizontal Pattern probe to a classifier for instructions.

Data collected

The following gathers specified information from the target. If the source is not configured, it brings back default information. For instance, for PostgreSQL Instance@hostname (default name), the source needs to be modified. If not, all the "PostgreSQL Instance@hostname" will be added in the source for the [cmdb_ci_db_postgresql_instance] table.

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

Relationships

Parent class	Relationship	Child class
cmdb_ci_db_postgresql_instance	Runs on:Runs	cmdb_ci_windows_server or cmdb_ci_linux_server