coroot/coroot-pg-agent

Using coroot-pg-agent with PostgreSQL v.15

Opened this issue · 0 comments

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.