[PostgreSQL]: Add Otel Input for Postgresql

### Integration Name

PostgreSQL [packages/postgresql]

### Dataset Name

_No response_

### Integration Version

1.32.1

### Agent Version

9.3.2

### OS Version and Architecture

Ubuntu 24.04 LTS

### User Goal

I am noticing certain fields aren't being captured in the Elastic's Postgresql integrations (for example connections fields).
I also am noticing more enhanced dashboards for Postgresql OTel content pack.
In effort to reap the benefits of using elastic, I would prefer to leverage elastic's EDOT Postgresql reciever. I noticed other integrations now have their own OTEL Input Integration.

### Existing Features

The data being collected from Elastic's Postgresql is not fully scope of what is needed for postgresql monitoring. I also don't feel like the dashboards are that appealing/useful. Providing a lackluster and frustrating experience.

### What did you see?

N/A

### Anything else?

_No response_