PMM for Google CloudSQL Postgre

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?

have you tried …

host cloudsqladmin postgres 10.0.0.0/24 md5

1 Like

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.

1 Like

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

2 Likes

Thanks for confirming @and!

1 Like

@AND and everyone, for the sake of completeness here’s a bug in PMM project https://jira.percona.com/browse/PMM-8125 that tracks a fix for this behavior.