[v1.10.0-beta3]: Could not find PG version info for DB pg

[pmpetit]

Hello,
for your information:
in pgwatch2/metrics/test_all_metrics.py

    data, err = executeOnRemoteHost(sql, host, port, 'template1', user, password, quiet=True)

but in aivan database, you can not connect to template1 :

\c template1
connection to server at "localhost" (::1), port 5432 failed: FATAL:  pg_hba.conf rejects connection for host "10.0.132.20", user "avnadmin", database "template1", SSL encryption
connection to server at "localhost" (::1), port 5432 failed: FATAL:  no pg_hba.conf entry for host "10.0.132.20", user "avnadmin", database "template1", no encryption

because we do not have postgres password, the best we can do is to connect with avnadmin user, and he can't connect to template1 db.

i think we will the same problem on RDS.

except trying to connect on defaultdb (for aiven only), i do not have solutions.

[pashagolub]

Thanks for this information. We would be happy to accept pull request from Aiven fixing this issue.

Meanwhile you can update this script to use it locally.

Kind regards