[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [External] Re: [ADMIN] Nagios Alerting for Postgres Instance.
From:       "Gone, Sajan" <SGone () lb ! com>
Date:       2017-07-21 15:14:06
Message-ID: D5979210.C9F3%sgone () lb ! com
[Download RAW message or body]

Thanks Keith and John.


Thank You,
Sajan Gone
Database Administrator

From: Keith <keith@keithf4.com<mailto:keith@keithf4.com>>
Date: Friday, July 21, 2017 at 9:32 AM
To: John Scalia <jayknowsunix@gmail.com<mailto:jayknowsunix@gmail.com>>
Cc: Sajan Gone <sgone@lb.com<mailto:sgone@lb.com>>, pgsql-admin \
                <pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>>
Subject: [External] Re: [ADMIN] Nagios Alerting for Postgres Instance.

Look at the check_postgres module which works well with nagios and provides many of \
the important metrics to monitor for

https://bucardo.org/wiki/Check_postgres<https://urldefense.proofpoint.com/v2/url?u=htt \
ps-3A__bucardo.org_wiki_Check-5Fpostgres&d=DwMFaQ&c=spYp1tZ3AQD6dfuI6rqaeg&r=7n1bLwXDz \
epgjKSNziw-ng&m=ATcA7ApPWlZ80MaM4vY-aBchx7P9mHQSUlHY6BLw8CQ&s=nDHw3YCODNk4erq42rPzv6-lwGctlIs-xLTBGxTEDLk&e=>


On Fri, Jul 21, 2017 at 9:16 AM, John Scalia \
<jayknowsunix@gmail.com<mailto:jayknowsunix@gmail.com>> wrote: There are dozens of \
Nagios modules for PostgreSQL. You might be better off deciding what's important to \
you and look from there

--
Jay

On Jul 21, 2017 8:53 AM, "Gone, Sajan" <SGone@lb.com<mailto:SGone@lb.com>> wrote:
Hi,

    We have recently deployed a application in production on a Postgres instance \
which is of community edition. In our enterprise we use Nagios as an alerting system. \
Generally on our  DB systems we configure to receive alerting/warnings on CPU, memory \
and other system/OS resources plus DB related issues.

It would be helpful for me if some one can let me know, what sort of alerting is \
advisable to configure for Postgres processes.  Any sort of documentation on \
monitoring would also be very helpful.

 Many thanks in advance.

Thank You,
Sajan Gone


________________________________

Notice: This communication may contain privileged and/or confidential information. If \
you are not the intended recipient, please notify the sender by email, and \
immediately delete the message and any attachments without copying or disclosing \
them. LB may, for any reason, intercept, access, use, and disclose any information \
that is communicated by or through, or which is stored on, its networks, \
applications, services, and devices.


________________________________

Notice: This communication may contain privileged and/or confidential information. If \
you are not the intended recipient, please notify the sender by email, and \
immediately delete the message and any attachments without copying or disclosing \
them. LB may, for any reason, intercept, access, use, and disclose any information \
that is communicated by or through, or which is stored on, its networks, \
applications, services, and devices.


[Attachment #3 (text/html)]

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: \
after-white-space; color: rgb(0, 0, 0); font-family: Calibri, sans-serif;"> \
<div><span style="font-size: 16px;">Thanks Keith and John.&nbsp;</span></div> \
<div><span style="font-size: 16px;"><br> </span></div>
<div><span style="font-size: 16px;"><br>
</span></div>
<div>
<div><span style="font-size: 16px;">Thank You,</span></div>
<div><span style="font-size: 16px;">Sajan Gone</span></div>
<div><span style="font-size: 16px;">Database Administrator</span></div>
<div style="font-size: 14px;"><br>
</div>
</div>
<span id="OLK_SRC_BODY_SECTION" style="font-size: 14px;">
<div style="font-family:Calibri; font-size:11pt; text-align:left; color:black; \
BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; \
PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: \
medium none; PADDING-TOP: 3pt"> <span style="font-weight:bold">From: </span>Keith \
&lt;<a href="mailto:keith@keithf4.com">keith@keithf4.com</a>&gt;<br> <span \
style="font-weight:bold">Date: </span>Friday, July 21, 2017 at 9:32 AM<br> <span \
style="font-weight:bold">To: </span>John Scalia &lt;<a \
href="mailto:jayknowsunix@gmail.com">jayknowsunix@gmail.com</a>&gt;<br> <span \
style="font-weight:bold">Cc: </span>Sajan Gone &lt;<a \
href="mailto:sgone@lb.com">sgone@lb.com</a>&gt;, pgsql-admin &lt;<a \
href="mailto:pgsql-admin@postgresql.org">pgsql-admin@postgresql.org</a>&gt;<br> <span \
style="font-weight:bold">Subject: </span>[External] Re: [ADMIN] Nagios Alerting for \
Postgres Instance.<br> </div>
<div><br>
</div>
<div>
<div>
<div dir="ltr">Look at the check_postgres module which works well with nagios and \
provides many of the important metrics to monitor for<br> <br>
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__bucardo.org_wiki_Check-5 \
Fpostgres&amp;d=DwMFaQ&amp;c=spYp1tZ3AQD6dfuI6rqaeg&amp;r=7n1bLwXDzepgjKSNziw-ng&amp;m \
=ATcA7ApPWlZ80MaM4vY-aBchx7P9mHQSUlHY6BLw8CQ&amp;s=nDHw3YCODNk4erq42rPzv6-lwGctlIs-xLTBGxTEDLk&amp;e=">https://bucardo.org/wiki/Check_postgres</a><br>
 </div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Fri, Jul 21, 2017 at 9:16 AM, John Scalia <span \
dir="ltr"> &lt;<a href="mailto:jayknowsunix@gmail.com" \
target="_blank">jayknowsunix@gmail.com</a>&gt;</span> wrote:<br> <blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"> <div dir="auto">There are dozens of Nagios modules for \
PostgreSQL. You might be better off deciding what's important to you and look from \
there <div dir="auto"><br>
</div>
<div dir="auto">--</div>
<div dir="auto">Jay</div>
</div>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_extra"><br>
<div class="gmail_quote">On Jul 21, 2017 8:53 AM, &quot;Gone, Sajan&quot; &lt;<a \
href="mailto:SGone@lb.com" target="_blank">SGone@lb.com</a>&gt; wrote:<br \
type="attribution"> <blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"> <div \
style="word-wrap:break-word;color:rgb(0,0,0);font-family:Calibri,sans-serif"> \
<div><span style="font-size:16px">Hi,&nbsp;</span></div> <div><span \
style="font-size:16px"><br> </span></div>
<div><span style="font-size:16px">&nbsp; &nbsp; We have recently deployed a \
application in production on a Postgres instance which is of community edition. In \
our enterprise we use Nagios as an alerting system. Generally on our &nbsp;DB systems \
we configure to receive alerting/warnings  on CPU, memory and other system/OS \
resources plus DB related issues.&nbsp;</span></div> <div><span \
style="font-size:16px"><br> </span></div>
<div><span style="font-size:16px">It would be helpful for me if some one can let me \
know, what sort of alerting is advisable to configure for Postgres processes.&nbsp; \
Any sort of documentation on monitoring would also be very helpful.</span></div> \
<div><span style="font-size:16px"><br> </span></div>
<div><span style="font-size:16px">&nbsp;Many thanks in advance.&nbsp;</span></div>
<div><span style="font-size:16px"><br>
</span></div>
<div>
<div><span style="font-size:16px">Thank You,</span></div>
<div><span style="font-size:16px">Sajan Gone</span></div>
<div><br>
</div>
</div>
<br>
<hr>
<font size="1" color="Gray" face="Arial"><br>
Notice: This communication may contain privileged and/or confidential information. If \
you are not the intended recipient, please notify the sender by email, and \
immediately delete the message and any attachments without copying or disclosing \
them. LB may, for  any reason, intercept, access, use, and disclose any information \
that is communicated by or through, or which is stored on, its networks, \
applications, services, and devices.<br> </font></div>
</blockquote>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</span><br>
<hr>
<font face="Arial" color="Gray" size="1"><br>
Notice: This communication may contain privileged and/or confidential information. If \
you are not the intended recipient, please notify the sender by email, and \
immediately delete the message and any attachments without copying or disclosing \
them. LB may, for  any reason, intercept, access, use, and disclose any information \
that is communicated by or through, or which is stored on, its networks, \
applications, services, and devices.<br> </font>
</body>
</html>



[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic