Hello Bikram,
Am 22.08.2019 um 23:50 schrieb Bikram MAJUMDAR:
Hi,
Need help from anyone in the team who has worked on pgwatch2.
Yesterday we installed pgwatch2 docker image and started the container.
We are running the pgwatch2 container from the database server itself -
Now we want to add our databases for monitoring using the admin interface:
We are opening the pgwatch2 admin interface at <host IP>:8080/dbs.But, when we
try to add the database (cemtore) in the admin interface we get the following error:
Could not connect to specified host (ignore if gatherer daemon runs on another host): FATAL: no pg_hba.conf
entry for host "172.17.0.2", user "cemtore", database "cemtore", SSL off
Any idea what we are doing wrong?
We would now like to add the database manually following notes below:
Usage
by default the pgwatch2 configuration database running inside Docker is being
monitored so that you can immediately see some graphs, but you should add new
databases by opening the admin interface at 127.0.0.1:8080/dbs or logging into
the Postgres config DB and inserting into pgwatch2.monitored_db table (db -
pgwatch2 , default user/pw - pgwatch2/pgwatch2admin)
But, my question is, how do I run the psql on my database server to login to
this default pgwatch2 configuration DB?
Bikram Majumdar
Sr Software Developer/DBA, Aqsacom Inc.
c. 1.972.365.3737
As the message states (FATAL: no pg_hba.conf entry for host
"172.17.0.2", user "cemtore", database "cemtore", SSL off) you have to
edit pg_hba.conf of the PostgreSQL Cluster hosting the cemtore database
to allow connections from pgwatch to it as your current config doesn't
allow that. Also you may need the connecting user within your database
with the required rights (if not added yet).
regards
Georg
