Using coroot-pg-agent with PostgreSQL v.15
Opened this issue · 0 comments
doonydoo commented
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.