[exporter/postgres] - initial Revamped PR for new Postgres Exporter Component

[destrex271]

Description

Adds support for exporting traces, metrics and logs to Postgres.

Link to tracking issue

Implements component #35451 & revamped version of PR #35485 since that branch became a mess after merging with upstream

Sponsor Details

@philippemnoel from ParadeDB has expressed his intent to sponsor this component since this feature is primarily being developed for this issue in Paradedb paradedb/paradedb#1632

[destrex271]

I am facing some problems in generating the headers right now, will update the PR once done

[atoulme]

The sponsor needs to be an approver or maintainer of the contrib project.

[philippemnoel]

The sponsor needs to be an approver or maintainer of the contrib project.

Ah. Then I'm not sure I can help for now.

[github-actions]

This PR was marked stale due to lack of activity. It will be closed in 14 days.

[github-actions]

Closed as inactive. Feel free to reopen if this PR is still being worked on.

[smehboub]

Hello @destrex271
This feature would be great!
Do you know why it's blocked ?

[destrex271]

Hello @destrex271
This feature would be great!
Do you know why it's blocked ?

Hi, we were unable to secure any sponsors for this in the previous PR and after that I got busy with some of my uni stuff but I plan to reopen this as soon as possible(probably by the end of this month).

I have created a separate unofficial exporter for the time being at: https://github.com/destrex271/postgresexporter

since it was a feature required for paradedb.