The PostgreSQL agent cannot monitor due to the following error
No pg_hba.conf entry - FATAL: no pg_hba.conf entry for host "host", user "user"…
The entry for the user can be in several different formats, but the important thing to remember is that the user must be able to connect from the agent location and that it should be allowed to connect to all databases. Options like SSL and auth-method can be set at the discretion of the client, though generally for a POC, it’s easiest to not require SSL and use either “trust” or “md5” as the auth-method. More information on the pga_hba.conf file can be found:
https://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html
Typically this issue is related to SSL settings in the PostgreSQL agent in which changing the SSL mode to preferred and unchecking the use java keystore checkbox resolves the issue.
Note: When using PostgreSQL on Amazon RDS it is recommended to try using SSL as "Required" in the Agent Status Properties for the PostgreSQL agent.
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center