topic PostgreSQL - handle postgre version in extension in Extensions

PostgreSQL - handle postgre version in extension

Nicomon02 — Tue, 15 Oct 2024 15:10:40 GMT

Some queries executed by PostgreSQL extension are reporting errors while they are trying to get value from non-existing columns in differents version of PostgreSQL databases.

This behavior generate a huge amount of logs, and create incident on production activity.

it would be better to check the version before and then send proper queries regarding curent version of databases.

It will avoid to generate many logs.

exemple : queries on "total_time" column.

Re: PostgreSQL - handle postgre version in extension

Mike_L — Tue, 15 Oct 2024 16:47:18 GMT

Hi,

It is a limitation on our data source, please raise it as a product idea to have our data sources handle conditional queries.

Re: PostgreSQL - handle postgre version in extension

Peter_Youssef — Wed, 16 Oct 2024 13:44:49 GMT

Hello @Nicomon02

Regarding the raised concern, kindly find the below info:

For detailed info about PostgreSQL

There is alternative solution:

custom-database-extension according to current version of PostgreSQL, it supports PostgreSQL.

In case you have tried all these attempts, then:

Reach out to Dynatrace support team via live chat or raise a support ticket.
Share the detailed scenario, if possible include screenshots and logs with Dynatrace on DynatraceProductIdeas

KR,

Peter.

Re: PostgreSQL - handle postgre version in extension

Joseph_Hobbs — Mon, 23 Feb 2026 21:28:23 GMT

We ran into this situation as well... I've submitted an idea to address this concern...

https://community.dynatrace.com/t5/Product-ideas/Reduce-errors-generated-by-PostgreSQL-extension/idi-p/295146