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 Sent: Friday, August 16, 2019 7:24 AM To: Bikram MAJUMDAR ; pgsql-general Subject: Re: Question on pgwatch On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR 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
RE: Question on pgwatch
Hi Luca, When I go to the URL link for pgwatch that you have given I see the following : How do I get to pgwatch docker download and install on my linux server? [cid:image001.png@01D55453.A5A43AC0] 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 ; pgsql-general 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 mailto:fluca1...@gmail.com>> Sent: Friday, August 16, 2019 7:24 AM To: Bikram MAJUMDAR mailto:bikram.majum...@aqsacom.com>>; pgsql-general mailto:pgsql-gene...@postgresql.org>> Subject: Re: Question on pgwatch On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR mailto:bikram.majum...@aqsacom.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
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 :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 ; pgsql-general 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 Sent: Friday, August 16, 2019 7:24 AM To: Bikram MAJUMDAR ; pgsql-general Subject: Re: Question on pgwatch On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR 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
Re: Question on pgwatch
Hi George, So nice for your response. Thanks. But, my question is how does it get the IP address 172.17.0.2 ? And, how does one run psql command to connect/login to the test database ( pgwatch configuration database) to add any database ? Thanks and regards, Bikram On Fri, Aug 23, 2019 at 2:00 AM Georg H. wrote: > 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 :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 > > > > > >
pgwatch2 monitoring dashboards
Hi Good Morning Teams, We are trying to configure pgwatch2 to monitor our postgress database named cemtore ( version 10.3). We have installed the pgwatch2 docker container from GitHub and followed the steps under the section 'Steps to configure your database for monitoring' for monitoring statements and CPU loads etc, that are provided through the helper functions. All the steps - 1.Creation of the pgwatch2 role 2. Creation of all the helper functions as the superuser cemtore were completed. 3. Added our database (cemtore) in the pgwatch2 admin interface for monitoring using the pgwatch2 role But, pgwatch2monitoring dashboards do not show us the statement activities or CPU load etc - and the pgwatch2 log shows errors that it can not access the helper functions - for e.g, [cemtore:stat_statements_calls]: pq: relation "pg_stat_statements" does not exist etc. However, when we use the superuser cemtore for monitoring in the admin interface, instead of pgwatch2, everything shows up. We are using postgress 10.3 - do we need to grant any extra access privileges ,for e.g granting pg_monitor role to pgwatch2 to monitor using pgwatch2 ? Any help will be greatly appreciated. Thanks and regards, Bikram Majumdar Sr Software Developer/DBA, Aqsacom Inc. c. 1.972.365.3737 e. bikram.majum...@aqsacom.com<mailto:bikram.majum...@aqsacom.com> s. BIKRAM MAJUMDAR [cid:image001.png@01D56FB8.D57A10F0]<http://www.aqsacom.com/> 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.
Re: Christopher Browne
So sorry to hear this news. On Wed, Nov 4, 2020, 17:29 Steve Singer wrote: > > It is with much sadness that I am letting the community know that Chris > Browne passed away recently. > > Chris had been a long time community member and was active on various > Postgresql mailing lists. He was a member of the funds committee, the > PgCon > program committee and served on the board of the PostgreSQL Community > Association of Canada. Chris was a maintainer of the Slony > replication system and worked on various PG related tools. > > I worked with Chris for over 10 years and anytime someone had a problem he > would jump at the chance to help and propose solutions. He > always had time to listen to your problem and offer ideas or explain how > something worked. > > I will miss Chris > > Steve > > > >
