Using coroot-pg-agent with PostgreSQL v.15

[doonydoo]

Hello,

I tried to use coroot-pg-agent for PostgreSQL v.14, it worked perfect according to your instructions.
But with PostgreSQL v.15 I've cought the problem:

[collector.go:166] pq: relation "pg_stat_statements" does not exist

The solvation I've found is:
set up

ALTER USER <USER> SET SEARCH_PATH TO <USER>,pg_catalog,public;

in database,
and disable SSL mode when starting the container (because I found the warning in logs "SSL mode is disabled!")

DSN: "postgresql:// <USER>: <PASSWORD>@<HOST>:<PORT>/<DATABASE_NAME>?sslmode=disable&connect_timeout=1&statement_timeout=30000"

It would be great if you add this notes to the docs.

[mohag]

I suspect that it might be if the user is shared with postgresql_exporter, that wants the search_path altered to ,pg_catalog, instead of the postgresql version...

[willowweevil]

Unfortunately, still have the ERROR: relation "pg_stat_statements" does not exist at character 260.
Database: PostgreSQL 17.4

I created the coroot role, granted it with pg_monitor. Also i tried extra grant: GRANT SELECT ON pg_stat_statements TO coroot;

I think the problem is the absence of pg_stat_statements extension for coroot database.
When I try to execute the \dx command for admin user i see the pg_stat_statements in extensions.
However there is no any for coroot user (as well as coroot database: psql --user coroot).

Also, when i try to install it for coroot user i get an error:

coroot=# create extension pg_stat_statements;
ERROR:  permission denied to create "pg_catalog.pg_stat_statements"
DETAIL:  System catalog modifications are currently disallowed.

Should the extension be installed for coroot user or just user should be granted? What database will be used to get pg_stats data?