PMM for Google CloudSQL Postgre

[AND]

Im trying to monitor my CloudSQL postgre instance,
followed step by step instructions from page but simply dont work:
db=cloudsqladmin,user=postgres FATAL: pg_hba.conf rejects connection for host "10.X.X.X", user "postgres", database "cloudsqladmin", SSL off"

I can use psql to conect to instance;
Firewall are entirely open;
all comands run as sudo;

Is this an postgres user issue? Its possible to teach pmm to ignore table cloudsqladmin?

[Jorge_Torralba]

have you tried …

host cloudsqladmin postgres 10.0.0.0/24 md5

[AND]

I cant reach pg_hba.conf, GCP dont let me touch this.
Looking in the docs, I found something in the postgres_exporter: exclude-databases, but I dont know how to use it with pmm.

[AND]

Solved, building my own postgres_exporter using flag exclude-databases
Tks for all Forum and Discord

[sergey.kuzmichev]

Thanks for confirming @and!

[sergey.kuzmichev]

@AND and everyone, for the sake of completeness here’s a bug in PMM project [PMM-8125] Error of monitoring GCP based PostgreSQL because of internal database "cloudsqladmin" - Percona JIRA that tracks a fix for this behavior.