---
sourceDocument: Australia IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/it-operations-management

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# PostgreSQL

# PostgreSQL discovery {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

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

## Credentials and other prerequisites {#r_DiscoverPostgreSQLInstances__section_ix5_ymk_mbb}

These credentials are required:

* [SSH
  credentials](https://www.servicenow.com/docs/access?context=r_SSHCredentialsForm&version=australia&pubname=australia-platform-security&ft:locale=en-US)
* \[optional\] [Applicative credentials](https://www.servicenow.com/docs/access?context=applicative-creds&version=australia&pubname=australia-platform-security&ft:locale=en-US)

{#r_DiscoverPostgreSQLInstances__ul_wvj_wkg_kcb}

For a list of privileged commands that you need for Discovery
and Service Mapping, see [Service Mapping commands requiring a privileged user](https://www.servicenow.com/docs/fMLKP9ztw9H4ZPck4RnumQ "Service Mapping uses commands requiring elevated rights to discover and map Unix-based hosts in your organization. In addition to configuring necessary credentials, configure servers in your organization to allow Service Mapping to run these commands with elevated rights."). 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](https://support.servicenow.com/kb_view.do?sysparm_article=KB0694477).

## Classifiers, patterns, and probes {#r_DiscoverPostgreSQLInstances__section_mcx_zmk_mbb}

{#r_DiscoverPostgreSQLInstances__table_fzd_2yv_jz__entry__3}

| Classifier | Trigger probes | Patterns |
|-|-|-|
| PostgreSQL Instance | * Horizontal Pattern: launches patterns * PostgreSQL - Configuration\* (add the must_sudo parameter to this probe) * PostgreSQL - Version\* {#r_DiscoverPostgreSQLInstances__ul_ixv_myv_jz} | PostgreSQL DB |
[ ]

{#r_DiscoverPostgreSQLInstances__table_fzd_2yv_jz}

\*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](https://www.servicenow.com/docs/WtfJx~H7mHHJKPMU3hBM9w#t_AddHorizontalPatternProbe "To use a pattern for the identification and exploration phases of horizontal discovery, you must add the Horizontal Pattern probe to the classifiers for the CIs are you trying to discover.") 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.  
{#r_DiscoverPostgreSQLInstances__entry__10}

| Label | Table Name | Field Name | Source |
|-|-|-|-|
| Name | cmdb_ci_db_postgresql_instance | name | PostgreSQL Instance@<var class="keyword varname">hostname</var> |
| 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 | <var class="keyword varname">data_directory</var>/postgresql.conf |
| Version | cmdb_ci_db_postgresql_instance | version | postmaster/postgres |
[ ]

## Relationships {#r_DiscoverPostgreSQLInstances__section_gyd_q4k_mbb}

{#r_DiscoverPostgreSQLInstances__table_hvy_q4k_mbb__entry__3}

| Parent class | Relationship | Child class |
|-|-|-|
| cmdb_ci_db_postgresql_instance | Runs on:Runs | cmdb_ci_windows_server or cmdb_ci_linux_server |
[ ]

{#r_DiscoverPostgreSQLInstances__table_hvy_q4k_mbb}