RE: Question on pgwatch

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

Disclaimer. This electronic mail message contains CONFIDENTIAL information which is (a) CUSTOMER / SUPPLIER / PARTNER PRIVILEGED COMMUNICATION, WORK PRODUCT, PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW FROM DISCLOSURE, and (b) intended only for the use of the Addressee(s) named herein. If you are not an Addressee, or the person responsible for delivering this to an Addressee, you are hereby notified that reading, copying, or distributing this message is prohibited. If you have received this electronic mail message in error, please reply to the sender and take the steps necessary to delete the message completely from your computer system. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of AQSACOM. AQSACOM accepts no liability for any damage caused by any virus/worms transmitted by this email.

-----Original Message-----
From: Bikram MAJUMDAR
Sent: Friday, August 16, 2019 4:43 PM
To: Luca Ferrari <fluca1978(at)gmail(dot)com>; pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: RE: Question on pgwatch

Hi Luca,

I have installed docker (yum install ) on my linux server. Does it already come with the pgwatch public image? How do I download and install pgwatch docker image from github -- <https://github.com/cybertec-postgresql/pgwatch2>

Thanks and regards
Bikram Majumdar
Sr Software Developer/DBA, Aqsacom Inc.
c. 1.972.365.3737

Disclaimer. This electronic mail message contains CONFIDENTIAL information which is (a) CUSTOMER / SUPPLIER / PARTNER PRIVILEGED COMMUNICATION, WORK PRODUCT, PROPRIETARY IN NATURE, OR OTHERWISE PROTECTED BY LAW FROM DISCLOSURE, and (b) intended only for the use of the Addressee(s) named herein. If you are not an Addressee, or the person responsible for delivering this to an Addressee, you are hereby notified that reading, copying, or distributing this message is prohibited. If you have received this electronic mail message in error, please reply to the sender and take the steps necessary to delete the message completely from your computer system. Statement and opinions expressed in this e-mail are those of the sender, and do not necessarily reflect those of AQSACOM. AQSACOM accepts no liability for any damage caused by any virus/worms transmitted by this email.

-----Original Message-----
From: Luca Ferrari <fluca1978(at)gmail(dot)com>
Sent: Friday, August 16, 2019 7:24 AM
To: Bikram MAJUMDAR <Bikram(dot)Majumdar(at)aqsacom(dot)com>; pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question on pgwatch

On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR <Bikram(dot)Majumdar(at)aqsacom(dot)com> wrote:
> From where did you download docker for linux, and , the docker with the pgwatch container?
> And, any installation/configuration tips for pgwatch running on linux?

I'm not sure what you are effectively askin to me, however the starting point for bth projects are the related web sites:
- docker <https://www.docker.com/>
- pgwatch <https://pgwatch.com/> and here you can find detailed instruction from dowloading to run it <https://github.com/cybertec-postgresql/pgwatch2>

Luca