[receiver/postgresql] Add service.instance.id resource attribute to metrics and logs

[sv-splunk]

Component(s)

receiver/postgresql

Describe the issue you're reporting

Overview

Add the service.instance.id to all metrics and logs emitted by the PostgreSQL receiver in resource attribute. This attribute provides a logical identifier for the service instance, improving observability and allowing better correlation of telemetry data across different signals. The value of service.instance.id will be in the format <host>:<port>. 5432 will be used as the default port.

Related issue for reference

sql server - #41894

Tip

_{React with 👍 to help prioritize this issue. Please use comments to provide useful context, avoiding +1 or me too, to help us triage it. Learn more here.}

[github-actions]

Pinging code owners:

• receiver/postgresql: @antonblock @ishleenk17

See Adding Labels via Comments if you do not have permissions to add labels yourself.