edb databases not visible in dbname

[lguduk]

hello,

I am runing latest docker image file on my monitoring server. I can succesfully added postgresql database for monitoring. But I have a problem with edb database, edb databases are not visible in dbname in grafana dashboard. When I check the pgwatch logs, I see below error logs.

{"args":[],"err":"can't scan into dest[0]: cannot convert \u0026{170002000000000000 -16 false finite true} to integer","fields.time":3002131,"level":"error","msg":"Query","pid":4041433,"sql":"select /* pgwatch_generated */ \n\tcurrent_setting('server_version_num')::int / 10000 as ver, \n\tversion(), \n\tpg_is_in_recovery(), \n\tcurrent_database()::TEXT,\n\tsystem_identifier\nFROM\n\tpg_control_system()","time":"2025-02-14T12:38:42Z"}
{"level":"error","msg":"could not start metric gathering due to connection problem: can't scan into dest[0]: cannot convert \u0026{170002000000000000 -16 false finite true} to integer","source":"*****","time":"2025-02-14T12:38:42Z"}

Also I run below query in edb server.

select /* pgwatch_generated */
current_setting('server_version_num')::int / 10000 as ver,
version(),
pg_is_in_recovery(),
current_database()::TEXT,
system_identifier
FROM
pg_control_system();

It output different according to postgresql for ver coloumn.

ver |version |pg_is_in_recovery|current_database|system_identifier |
-------------------+----------------------------------------------------------------------------------------------------------------------------------------------+-----------------+----------------+-------------------+
17.0002000000000000|PostgreSQL 17.2 (EnterpriseDB Advanced Server 17.2.0) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-2), 64-bit|false |edb |7465337939877200622|

Do you have any suggestion or work around solution? I did not have this problem on pgwatch2, I could succesfully monitor edb postgres databases.

Above query output for postgresql:

ver|version |pg_is_in_recovery|current_database|system_identifier |
---+--------------------------------------------------------------------------------------------------------+-----------------+----------------+-------------------+
17|PostgreSQL 17.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-2), 64-bit|false |postgres |7461986884516555944|

Thank you.
Regards

[pashagolub]

Does edb have overloaded division operator for two ints?

pgwatch=> select 170002 / 10000 as div;
 div
-----
  17
(1 row)


pgwatch=> \gdesc
 Column |  Type
--------+---------
 div    | integer
(1 row)

[lguduk]

I think yes, it does.

edb=# select 170002 / 10000 as div;
div

17.0002000000000000
(1 row)

edb=# \gdesc
Column | Type
--------+---------
div | numeric
(1 row)

[pashagolub]

Will this one work?

select
(current_setting('server_version_num')::int / 10000)::int as ver

[pashagolub]

or maybe this one is better?

select div(current_setting('server_version_num')::int, 10000) as ver;

[lguduk]

thank you. It gives expected result. But where should ı change for monitoring?

edb=# select (current_setting('server_version_num')::int / 10000)::int as ver;
ver

17
(1 row)

edb=# select div(current_setting('server_version_num')::int, 10000) as ver;
ver

17
(1 row)

Thank you

[pashagolub]

I will patch the sources. Please, stay tuned

[lguduk]

thank you so much. I'm looking forward to it. by the way grafana graph says this panel requires angular (deprecated). Can you look also that.

[pashagolub]

You're welcome. I don't need to look into it, I know about it :)

There are v11 dashboards available. But anyway dashboards are only templates for you to create your own.

[pashagolub]

Fixed in #650