pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedQuestion on pgwatch
17+ messages / 5 participants
[nested] [flat]
* Question on pgwatch
@ 2019-08-12 21:57 Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-12 21:57 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; +Cc: bikramma@gmail.com <bikramma@gmail.com>
Hi,
I am trying to configure pgwatch to monitor our postgres database. I am wondering if we can install/configure and run it from a windows server to monitor our postgres database which runs on a linux server.
Does pgwatch only runs on linux platforms?
And can we install and run it on the same linux server where the postgres database is running?
Thanks and regards,
Bikram Majumdar
Sr Software Developer/DBA, Aqsacom Inc.
c. 1.972.365.3737
e. bikram.majumdar@aqsacom.com<mailto:bikram.majumdar@aqsacom.com>
s. BIKRAM MAJUMDAR
[cid:image001.png@01D5512E.FC118610]<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.
Attachments:
image001.png (image/png, 10.0K) download
view image
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-13 14:48 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
0 siblings, 1 reply; 17+ messages in thread
From: Luca Ferrari @ 2019-08-13 14:48 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; bikramma@gmail.com <bikramma@gmail.com>
On Mon, Aug 12, 2019 at 11:57 PM Bikram MAJUMDAR
<Bikram.Majumdar@aqsacom.com> wrote:
> Does pgwatch only runs on linux platforms?
According to the documentation it runs on docker by default, so it
depends on how simple it is to get running docker on windows
<https://docs.docker.com/docker-for-windows/;.
Another approach could be to run a linux virtual machine on the
windows box, since the pgwatch documentation explains how to install
it on a non-docker container.
Hope this helps.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
@ 2019-08-13 16:50 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-13 16:50 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; bikramma@gmail.com <bikramma@gmail.com>
Hi Luca,
Thanks a lot for your response.
So are you saying we can run pgwatch from windows also ?
From reading so far on pgwatch, I thought it can be installed and run only on linux platforms - but, I may be wrong.
Would you have a document on downloading and installing the windows version?
Another question:
Can we install and run it from the postgres database server itself?
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@gmail.com>
Sent: Tuesday, August 13, 2019 9:49 AM
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
Cc: pgsql-admin@lists.postgresql.org; bikramma@gmail.com
Subject: Re: Question on pgwatch
On Mon, Aug 12, 2019 at 11:57 PM Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com> wrote:
> Does pgwatch only runs on linux platforms?
According to the documentation it runs on docker by default, so it depends on how simple it is to get running docker on windows <https://docs.docker.com/docker-for-windows/;.
Another approach could be to run a linux virtual machine on the windows box, since the pgwatch documentation explains how to install it on a non-docker container.
Hope this helps.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-13 18:23 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:29 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 2 replies; 17+ messages in thread
From: Luca Ferrari @ 2019-08-13 18:23 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; bikramma@gmail.com <bikramma@gmail.com>
On Tue, Aug 13, 2019 at 6:50 PM Bikram MAJUMDAR
<Bikram.Majumdar@aqsacom.com> wrote:
> So are you saying we can run pgwatch from windows also ?
No, I wrote that pgwatch runs in a docker container, so as far as you
can run docker on windows you should be able to run pgwatch within
docker on top of windows.
> From reading so far on pgwatch, I thought it can be installed and run only on linux platforms - but, I may be wrong.
pgwatch runs on a linux stack, so if you need to run it on windows you
have either to runa virtual machine (running linux) or get a docker
linux container available and running.
> Can we install and run it from the postgres database server itself?
I think it is possible, but probably not the best solution.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
@ 2019-08-13 18:29 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
1 sibling, 0 replies; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-13 18:29 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; bikramma@gmail.com <bikramma@gmail.com>
Thanks a lot Luca.
Last question:
If we want to run on windows then, is there any guide/documentation available that you can refer me.
Thanks
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@gmail.com>
Sent: Tuesday, August 13, 2019 1:23 PM
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
Cc: pgsql-admin@lists.postgresql.org; bikramma@gmail.com
Subject: Re: Question on pgwatch
On Tue, Aug 13, 2019 at 6:50 PM Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com> wrote:
> So are you saying we can run pgwatch from windows also ?
No, I wrote that pgwatch runs in a docker container, so as far as you can run docker on windows you should be able to run pgwatch within docker on top of windows.
> From reading so far on pgwatch, I thought it can be installed and run only on linux platforms - but, I may be wrong.
pgwatch runs on a linux stack, so if you need to run it on windows you have either to runa virtual machine (running linux) or get a docker linux container available and running.
> Can we install and run it from the postgres database server itself?
I think it is possible, but probably not the best solution.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
@ 2019-08-13 18:46 ` Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
1 sibling, 1 reply; 17+ messages in thread
From: Scott Ribe @ 2019-08-13 18:46 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; +Cc: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; Luca Ferrari <fluca1978@gmail.com>
> On Aug 13, 2019, at 12:23 PM, Luca Ferrari <fluca1978@gmail.com> wrote:
>
> pgwatch runs on a linux stack, so if you need to run it on windows you
> have either to runa virtual machine (running linux) or get a docker
> linux container available and running.
Don't forget Windows Subsystem for Linux: https://docs.microsoft.com/en-us/windows/wsl/install-win10
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
@ 2019-08-13 18:57 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-13 18:57 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>; +Cc: Luca Ferrari <fluca1978@gmail.com>
Thanks a lot for your response and help.
Would you please tell me where I can get the locker with linux container for windows and how to install it on my windows machine?
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: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Tuesday, August 13, 2019 1:47 PM
To: pgsql-admin@lists.postgresql.org
Cc: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; Luca Ferrari <fluca1978@gmail.com>
Subject: Re: Question on pgwatch
> On Aug 13, 2019, at 12:23 PM, Luca Ferrari <fluca1978@gmail.com> wrote:
>
> pgwatch runs on a linux stack, so if you need to run it on windows you
> have either to runa virtual machine (running linux) or get a docker
> linux container available and running.
Don't forget Windows Subsystem for Linux: https://docs.microsoft.com/en-us/windows/wsl/install-win10
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-14 07:32 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Luca Ferrari @ 2019-08-14 07:32 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; +Cc: Scott Ribe <scott_ribe@elevated-dev.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
On Tue, Aug 13, 2019 at 8:57 PM Bikram MAJUMDAR
<Bikram.Majumdar@aqsacom.com> wrote:
> Would you please tell me where I can get the locker with linux container for windows and how to install it on my windows machine?
In my first email I sent you the link to get started with docker on
windows <https://docs.docker.com/docker-for-windows/;, then I believe
you have to do your own homework.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
@ 2019-08-16 12:23 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
0 siblings, 1 reply; 17+ messages in thread
From: Luca Ferrari @ 2019-08-16 12:23 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR
<Bikram.Majumdar@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
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
@ 2019-08-16 21:43 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-16 21:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-22 21:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
0 siblings, 2 replies; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-16 21:43 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; pgsql-general <pgsql-general@postgresql.org>
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@gmail.com>
Sent: Friday, August 16, 2019 7:24 AM
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Question on pgwatch
On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR <Bikram.Majumdar@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
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-16 21:57 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-17 15:52 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
1 sibling, 1 reply; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-16 21:57 UTC (permalink / raw)
To: Luca Ferrari <fluca1978@gmail.com>; pgsql-general <pgsql-general@postgresql.org>
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 <fluca1978@gmail.com>; pgsql-general <pgsql-general@postgresql.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@gmail.com<mailto:fluca1978@gmail.com>>
Sent: Friday, August 16, 2019 7:24 AM
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com<mailto:Bikram.Majumdar@aqsacom.com>>; pgsql-general <pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>>
Subject: Re: Question on pgwatch
On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com<mailto:Bikram.Majumdar@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
Attachments:
image001.png (image/png, 58.7K) download
view image
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-16 21:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-17 15:52 ` Luca Ferrari <fluca1978@gmail.com>
0 siblings, 0 replies; 17+ messages in thread
From: Luca Ferrari @ 2019-08-17 15:52 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; +Cc: pgsql-general <pgsql-general@postgresql.org>
On Fri, Aug 16, 2019 at 11:57 PM Bikram MAJUMDAR
<Bikram.Majumdar@aqsacom.com> wrote:
> 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?
I don't want to be harsh, but you should start doing your homework and
report about problems.
Since I'm not a pgwatch user, as already stated, I believe that you
should get the image with the following:
docker pull cybertec/pgwatch2
as reported here <https://hub.docker.com/r/cybertec/pgwatch2;.
Luca
^ permalink raw reply [nested|flat] 17+ messages in thread
* RE: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-22 21:50 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-23 07:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
1 sibling, 1 reply; 17+ messages in thread
From: Bikram MAJUMDAR @ 2019-08-22 21:50 UTC (permalink / raw)
To: pgsql-general <pgsql-general@postgresql.org>
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@gmail.com>; pgsql-general <pgsql-general@postgresql.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@gmail.com>
Sent: Friday, August 16, 2019 7:24 AM
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Question on pgwatch
On Wed, Aug 14, 2019 at 5:10 PM Bikram MAJUMDAR <Bikram.Majumdar@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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-22 21:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
@ 2019-08-23 07:00 ` Georg H. <georg-h@silentrunner.de>
2019-08-23 20:10 ` Re: Question on pgwatch Bikram Majumdar <bikramma@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Georg H. @ 2019-08-23 07:00 UTC (permalink / raw)
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
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
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-22 21:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-23 07:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
@ 2019-08-23 20:10 ` Bikram Majumdar <bikramma@gmail.com>
2019-08-23 21:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
0 siblings, 1 reply; 17+ messages in thread
From: Bikram Majumdar @ 2019-08-23 20:10 UTC (permalink / raw)
To: Georg H. <georg-h@silentrunner.de>; +Cc: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
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. <georg-h@silentrunner.de> 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 <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
>
>
>
>
>
>
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-22 21:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-23 07:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
2019-08-23 20:10 ` Re: Question on pgwatch Bikram Majumdar <bikramma@gmail.com>
@ 2019-08-23 21:00 ` Georg H. <georg-h@silentrunner.de>
2019-08-27 18:39 ` Re: Question on pgwatch Bikram Majumdar <bikramma@gmail.com>
0 siblings, 1 reply; 17+ messages in thread
From: Georg H. @ 2019-08-23 21:00 UTC (permalink / raw)
To: Bikram Majumdar <bikramma@gmail.com>; +Cc: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
Hi Bikram,
Am 23.08.2019 um 22:10 schrieb Bikram Majumdar:
> 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
>
>
the pgwatch2 configuration database resides within the docker container
when using the docker variant.
Whether you've exposed this port on container creation/start or you have
to go into the docker image (docker exec -it IMAGENAME /bin/bash) and
connect there with psql (pg_hba.conf should be in
/etc/postgresql/[version]/main or similiar).
regards
Georg
^ permalink raw reply [nested|flat] 17+ messages in thread
* Re: Question on pgwatch
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:46 ` Re: Question on pgwatch Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Re: Question on pgwatch Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-22 21:50 ` RE: Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-23 07:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
2019-08-23 20:10 ` Re: Question on pgwatch Bikram Majumdar <bikramma@gmail.com>
2019-08-23 21:00 ` Re: Question on pgwatch Georg H. <georg-h@silentrunner.de>
@ 2019-08-27 18:39 ` Bikram Majumdar <bikramma@gmail.com>
0 siblings, 0 replies; 17+ messages in thread
From: Bikram Majumdar @ 2019-08-27 18:39 UTC (permalink / raw)
To: Georg H. <georg-h@silentrunner.de>; +Cc: Bikram MAJUMDAR <bikram.majumdar@aqsacom.com>; pgsql-general <pgsql-general@postgresql.org>
Hi George,
Thanks for your all your quick help - I was able to login to the
configuration database (docker exec -it <container ID> /bin/bash).
I have some questions if you can help me in my understanding how one should
configure a database for monitoring.
*I was with the idea that, to configure our database for monitoring, we
just need to add it in the admin interface. And, the admin interface will
run the required psql scripts in our database to create the required
objects to collect the metrices.*
As I indicated in an earlier email, I was able to add our database
(database name - cemtore) in the admin interface by adding the IP
172.17.0.2 in the pg_hba.conf of our postgres' database. Our database
name is cemtore and we selected full monitoring for it in the admin
interface (see below under *admin_interface*)
=====*admin_interface*==========
[image: image.png]
I can see my database cemtore both in the pgwatch2 dashboard, and in the
configuration database of the pgwatch2 container (see below - 2nd screen
shot - *query output *from the configuration database of the container),
but, I am getting some errors in the *pgwatch2 log *of the admin interface
( see under *pgwatch2 log*). And the dashboard also does not show system
stats - system load,CPU utilization etc for the database cemtore (see
under *cemtore
dashboard*)
* What else do we have to do extra to monitor our database after adding it
in the * *pgwatch2 admin interface.*
* Any help will be greatly appreciated.*
[image: image.png]
==== *query output *==========
[image: image.png]
===*pgwatch2 log*=====
http://192.168.40.143:8080/logs/pgwatch2/200
2019/08/27 11:15:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:stat_ssl]: pq: function get_stat_activity() does not
exist
2019/08/27 11:15:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:stat_ssl]: 2794
2019/08/27 11:15:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:cpu_load]: pq: function get_load_average() does not
exist
2019/08/27 11:15:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:cpu_load]: 5587
2019/08/27 11:17:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:psutil_disk_io_total]: pq: function
get_psutil_disk_io_total() does not exist
2019/08/27 11:17:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:psutil_disk_io_total]: 2795
2019/08/27 11:17:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:psutil_disk]: pq: function get_psutil_disk() does
not exist
2019/08/27 11:17:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:psutil_disk]: 2795
2019/08/27 11:17:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:psutil_cpu]: pq: function get_psutil_cpu() does not
exist
2019/08/27 11:17:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:psutil_cpu]: 2795
2019/08/27 11:17:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:psutil_mem]: pq: function get_psutil_mem() does not
exist
2019/08/27 11:17:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:psutil_mem]: 2795
2019/08/27 11:18:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:backends]: pq: function get_stat_activity() does not
exist
2019/08/27 11:18:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:backends]: 5590
2019/08/27 11:19:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:kpi]: pq: function get_stat_activity() does not
exist
2019/08/27 11:19:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:kpi]: 2796
2019/08/27 11:19:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:wal_size]: pq: function get_wal_size() does not
exist
2019/08/27 11:19:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:wal_size]: 2796
2019/08/27 11:20:46 ERRO MetricGathererLoop: Failed to fetch metric
data for [cemtore:stat_statements_calls]: pq: relation
"pg_stat_statements" does not exist
2019/08/27 11:20:46 ERRO MetricGathererLoop: Total failed fetches for
[cemtore:stat_statements_calls]: 5592
=============*cemtore dashboard* ==============
[image: image.png]
Thanks and regards,
Bikram
ReplyForward
On Fri, Aug 23, 2019 at 4:00 PM Georg H. <georg-h@silentrunner.de> wrote:
> Hi Bikram,
> Am 23.08.2019 um 22:10 schrieb Bikram Majumdar:
>
> 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
>
>
> the pgwatch2 configuration database resides within the docker container
> when using the docker variant.
>
> Whether you've exposed this port on container creation/start or you have
> to go into the docker image (docker exec -it IMAGENAME /bin/bash) and
> connect there with psql (pg_hba.conf should be in
> /etc/postgresql/[version]/main or similiar).
>
> regards
>
> Georg
>
>
>
>
Attachments:
image.png (image/png, 66.0K) download
view image
image.png (image/png, 63.4K) download
view image
image.png (image/png, 50.6K) download
view image
image.png (image/png, 42.8K) download
view image
end of thread, other threads:[~2019-08-27 18:39 UTC | newest]
Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-12 21:57 Question on pgwatch Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 14:48 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-13 16:50 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:23 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-13 18:29 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-13 18:46 ` Scott Ribe <scott_ribe@elevated-dev.com>
2019-08-13 18:57 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-14 07:32 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-16 12:23 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-16 21:43 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-16 21:57 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-17 15:52 ` Luca Ferrari <fluca1978@gmail.com>
2019-08-22 21:50 ` Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>
2019-08-23 07:00 ` Georg H. <georg-h@silentrunner.de>
2019-08-23 20:10 ` Bikram Majumdar <bikramma@gmail.com>
2019-08-23 21:00 ` Georg H. <georg-h@silentrunner.de>
2019-08-27 18:39 ` Bikram Majumdar <bikramma@gmail.com>
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