pg.ddx.io pgsql-admin@postgresql.org mailing list archive help / color / mirror / Atom feed From: Georg H. <georg-h@silentrunner.de>
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Question on pgwatch
Date: Fri, 23 Aug 2019 09:00:36 +0200
Message-ID: <2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de> (raw )
In-Reply-To: <AM6PR0502MB36249643361A7E23189FE185EFA50@AM6PR0502MB3624.eurprd05.prod.outlook.com >
References: <AM6PR0502MB36240E7D8C081584D618A557EFD30@AM6PR0502MB3624.eurprd05.prod.outlook.com >
<CAKoxK+7=tsOeNwG4_gAwdbiroV70U0vDjPLAyG-eQviOot5HgA@mail.gmail.com >
<AM6PR0502MB3624547753A9749E454EA6BFEFD20@AM6PR0502MB3624.eurprd05.prod.outlook.com >
<CAKoxK+6x_SPVJqpqeZQFVqvf1SGHE3_4oLoBTGoYS1kS+QcJ=Q@mail.gmail.com >
<9CB8AC2E-27EA-431A-A00A-763E7DF124BA@elevated-dev.com >
<AM6PR0502MB3624E424FBF9C49F1DF49E73EFD20@AM6PR0502MB3624.eurprd05.prod.outlook.com >
<CAKoxK+4_-h7W2MENrw+-6eP6d1dmEg8CexzoA9qxy5tyObygCA@mail.gmail.com >
<AM6PR0502MB3624021F836D421D56DB75FCEFAD0@AM6PR0502MB3624.eurprd05.prod.outlook.com >
<CAKoxK+7ibJ=Ab9Wz06qUZbdO9XpEwPi6zS=mfAaM+XZYKc0NyQ@mail.gmail.com >
<AM6PR0502MB3624751E4B2B236FA3575E2EEFAF0@AM6PR0502MB3624.eurprd05.prod.outlook.com >
<AM6PR0502MB36249643361A7E23189FE185EFA50@AM6PR0502MB3624.eurprd05.prod.outlook.com >
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
view thread (17+ messages) latest in thread
Message-ID: <2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de>
Permalink: ../2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de/
Also on: postgresql.org/message-id/2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: georg-h@silentrunner.de, Bikram.Majumdar@aqsacom.com, pgsql-general@postgresql.org
Subject: Re: Question on pgwatch
In-Reply-To: <2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox