PostgreSQL Pattern detecting the default running instance for 'hostname' - Support and Troubleshooting

PostgreSQL Pattern detecting the default running instance for 'hostname' Issue During a discovery it creates and updates CMDB records when it detects a running instance at the PostgreSQL level.

Per our docs it collects the name PostgreSQL instance@ hostname. However, as by default we see in the related tree of several CIs with 'PostgreSQL' with in the cmdb_ci_db_postgresql_instance table.

Cause Out of box we see this:

Step 19. Set label

Value: $instance Name: $name

This is the Output example: 'PostgreSQL'

In the related tree of the CI we see there are several PostgreSQL, listed in the cmdb_ci_db_postgresql_instance.

Resolution Do the following if you prefer to have the PostgreSQL pattern to populate the PostgreSQL@instance name.

Step 19. Set label added the following: Value: $instance + "@" + $computer_system.primaryHostname Name: $name

This is the Output example: ' PostgreSQL@mikecamba '