From hutger@gmail.com Wed Nov 14 09:51:23 2007 Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id CE9932E2002 for ; Wed, 14 Nov 2007 05:51:23 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 39224-02 for ; Wed, 14 Nov 2007 05:51:12 -0400 (AST) Received: from ag-out-0708.google.com (ag-out-0708.google.com [72.14.246.248]) by postgresql.org (Postfix) with ESMTP id 261562E0F8F for ; Wed, 14 Nov 2007 05:51:12 -0400 (AST) Received: by ag-out-0708.google.com with SMTP id 26so230766agb for ; Wed, 14 Nov 2007 01:51:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:x-mimeole; bh=//yhVs0rBTrurfBROs5cp1lCycbvkvOdXfGAPRoWSxU=; b=ZcOMLOHNy3xVNFf8Sj4ZB4ENXBhkJgrz/vK6jHa+VfYfBUYeduvHFsbPxvm9gVYQtIyY18xiKWR2NaHaHIni7+xawXXsUckf2LnDcaZ54u/VnHx1ZftG5dhxRYY3Egd4SWEOOsUlPhMblWHlRYmre4MfUSAiuiH6xgIqNj4sNrI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:message-id:mime-version:content-type:x-mailer:thread-index:x-mimeole; b=prYAmV0T0y92fJGv/tjQEvkZHSYeieAw5Mvb2l1Znlb+BxB02Yxl1n8Q/xU2eM1iCfwEHWtixQ+Fq+46O92ZFh2fh+pEf6bbrxQKjH7Mc3tK8CB978tbZdhBM5LXtNnQY6gagAlT6s2Nb2ebOJ30C8H2TsPEegccnbWNRszPYWc= Received: by 10.90.63.16 with SMTP id l16mr2765705aga.1195033870843; Wed, 14 Nov 2007 01:51:10 -0800 (PST) Received: from hutger ( [189.70.180.141]) by mx.google.com with ESMTPS id 32sm717215aga.2007.11.14.01.51.06 (version=TLSv1/SSLv3 cipher=RC4-MD5); Wed, 14 Nov 2007 01:51:09 -0800 (PST) From: "Hutger Hauer" To: Subject: Monitoring Tool Date: Wed, 14 Nov 2007 06:50:59 -0300 Message-ID: <000301c826a3$e04dd0e0$0501010a@hutger> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01C8268A.BB0098E0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: AcgmKM1bkPf/MDmVSn2AKbFNInMWaQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/118 X-Sequence-Number: 27361 This is a multi-part message in MIME format. ------=_NextPart_000_0004_01C8268A.BB0098E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Dear all, I'm looking for a monitoring tool that helps me to pick performance informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB or table, such as MRTG does. Does someone know a tool that can provide me such information? Thanks in advance. Hutger ------=_NextPart_000_0004_01C8268A.BB0098E0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Dear all,

 

I’m looking for a monitoring tool that helps me = to pick performance informations (heap blocks, buffer hits, etc) about a = specific PostgreSQL DB or table, such as MRTG does.

 

Does someone know a tool that can provide me such information?

 

Thanks in advance.

 

Hutger

 

 

 

 

------=_NextPart_000_0004_01C8268A.BB0098E0-- From cedric.villemain@dalibo.com Wed Nov 14 10:12:09 2007 Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E00DD2E196F for ; Wed, 14 Nov 2007 06:12:09 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 98690-07 for ; Wed, 14 Nov 2007 06:12:02 -0400 (AST) Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by postgresql.org (Postfix) with ESMTP id 9E1CC2E0F8F for ; Wed, 14 Nov 2007 06:12:05 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id B0BB957806D; Wed, 14 Nov 2007 11:12:03 +0100 (CET) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id VfwyR4oxg31S; Wed, 14 Nov 2007 11:12:03 +0100 (CET) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id 8E86A578072; Wed, 14 Nov 2007 11:12:03 +0100 (CET) Received: from [192.168.0.12] (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by pyrrha.dalibo.net (Postfix) with ESMTP id D46A657806D; Wed, 14 Nov 2007 11:12:00 +0100 (CET) Message-ID: <473AC9EF.5060900@dalibo.com> Date: Wed, 14 Nov 2007 11:11:59 +0100 From: =?ISO-8859-1?Q?C=E9dric_Villemain?= User-Agent: Mozilla-Thunderbird 2.0.0.6 (X11/20071009) MIME-Version: 1.0 To: Hutger Hauer CC: pgsql-admin@postgresql.org Subject: Re: Monitoring Tool References: <000301c826a3$e04dd0e0$0501010a@hutger> In-Reply-To: <000301c826a3$e04dd0e0$0501010a@hutger> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/119 X-Sequence-Number: 27362 Hutger Hauer a écrit : > Dear all, > > > > I'm looking for a monitoring tool that helps me to pick performance > informations (heap blocks, buffer hits, etc) about a specific PostgreSQL DB > or table, such as MRTG does. > > > > Does someone know a tool that can provide me such information? > > Have a look at munin, it is simple to use. http://munin.projects.linpro.no/ > > > Thanks in advance. > > > > Hutger > > > > > > > > > > > From pierreochsenbein@gmail.com Thu Sep 13 11:48:34 2018 Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0Q7C-0002e4-Is for pgsql-admin@arkaria.postgresql.org; Thu, 13 Sep 2018 11:48:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0Q7A-0004gy-Bz for pgsql-admin@arkaria.postgresql.org; Thu, 13 Sep 2018 11:48:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0Q79-0004gl-MY for pgsql-admin@lists.postgresql.org; Thu, 13 Sep 2018 11:48:52 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g0Q76-0008AT-MM for pgsql-admin@lists.postgresql.org; Thu, 13 Sep 2018 11:48:51 +0000 Received: by mail-io1-xd33.google.com with SMTP id 75-v6so2833431iou.11 for ; Thu, 13 Sep 2018 04:48:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=VuJMfRbFbrVP1G7zUuZOEl7YfFl1x70ZUWqmq/QUXJs=; b=M7ss4ycK4JHaz8tmyiwZ4Z4vPIHo8S2TLohFJAxxfCI1h1yFgyQK7n3tMVsM9LSr7K dAJRDfjboqU78/jw3Ny8jVwz9HodjCgVARefSlkOx3yMiTsPGnWLDz39DYp54urp6s4P UKrsfu8N+yyfW6P0m9EoyI4iJ45RW7znODTAJuhapneGtD4CAjksvID5ARFoaDYKGM8Q M0R/rOaetxiu2q9p7i/hfSJmC/tP9F45lZCHTQAR8fujNbX2bFtrL1eHTJKV7TW7aX+d kwaZmYnsLK+JxBsJP6eNBHmragnFudHJkv4bW1vwiMM+tPwGSbi1xT1EkWKXdWqgF6BT a8eQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=VuJMfRbFbrVP1G7zUuZOEl7YfFl1x70ZUWqmq/QUXJs=; b=j5TvEKfU3qp9I7edihcGigF2Jc6oZb4x24oWtzlu3JFEUP7MkKPeNkeEflff5+7kkO +4NdZBKFnsfoFBzOtpbqkvu19tC70eUZZZEGc1bA4KXK7t66Wb5cnWjo2BSv/wsSLeFA 689BcqPPmzDvMarOp8jeNL8/gCx9Jw4I9NmqNO7YO/iWuRv6Z9y+dnH+o7/uz/BOVe67 5cyMw4AfF94Wpv5BRxO4JjxwhYZ+qeNkmffi4+HlRf07dKgwWLIEgM/vwMx3QDPcyEJO uZlvQtJJuPUkelzKtRmo5NBdN80Vn91JOCFbL45LzAmCnubQpWqeexnCp/NrWnq3IaK6 /nkQ== X-Gm-Message-State: APzg51AKWGTbAhzaxWwXiBRx+FgKbBGGoegZaa4zvbUxITPyQ/Uxy62/ AqipPU4dqIe2njF7xi8A30ByY3sBe+OqN5CMlH48j8qD X-Google-Smtp-Source: ANB0VdaKJZxntZVrBh22u88d3Nn1A5YVsZMlw5SZ/Ngw5YI5lLStrN5OZHSvQcgBoUP0qX5ZekUEKg+oGA4RirEp1bs= X-Received: by 2002:a6b:bbc1:: with SMTP id l184-v6mr5505394iof.83.1536839326390; Thu, 13 Sep 2018 04:48:46 -0700 (PDT) MIME-Version: 1.0 From: Pierre Ochsenbein Date: Thu, 13 Sep 2018 13:48:34 +0200 Message-ID: Subject: monitoring tool To: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000002061c40575bf4a8b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000002061c40575bf4a8b Content-Type: text/plain; charset="UTF-8" Hi Guy's, What is for you the best monitoring tool for PostgreSQL which we can monitor a lot of databases? Cheers, Pierre --0000000000002061c40575bf4a8b Content-Type: text/html; charset="UTF-8"
Hi Guy's,

What is for you the best monitoring tool for PostgreSQL which we can monitor a lot of databases?

Cheers,
Pierre
--0000000000002061c40575bf4a8b-- From tflatley@gmail.com Thu Sep 13 12:43:01 2018 Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0Qxp-0004uF-RL for pgsql-admin@arkaria.postgresql.org; Thu, 13 Sep 2018 12:43:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g0Qxn-0004U8-L3 for pgsql-admin@arkaria.postgresql.org; Thu, 13 Sep 2018 12:43:15 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g0Qxn-0004U1-8S for pgsql-admin@lists.postgresql.org; Thu, 13 Sep 2018 12:43:15 +0000 Received: from mail-oi0-x243.google.com ([2607:f8b0:4003:c06::243]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g0Qxk-0002Kt-CV for pgsql-admin@lists.postgresql.org; Thu, 13 Sep 2018 12:43:14 +0000 Received: by mail-oi0-x243.google.com with SMTP id k12-v6so9246047oiw.8 for ; Thu, 13 Sep 2018 05:43:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=dsER3YzFGLaHPBoku6jeyVqqT3YTo2fzV1h4qIHjsXM=; b=ogGm+qgQjQDYYzdR5M5a/CfbDS2b0abKK530CP+aM1MxBiR/YJnLIprichkhHPiTdq 0DHx/E4G6OFxJYGetRv/sofLMXsnhVVDQU3fB6fwCFNvlCadXs0klhCbBJCb4grsTu6y /tf8cJnDw1gaJIZ9UDPSvNbLFm8qcYGyNWHNANqbDMzs9jW+a8aZDVKqy4xbcPtV8oKv OdF/5GnqOncFYJi1O4lH88QlDttTYiOScrvBNBKhHQXUgJdGNYopP3DaZN5706rHzoFI /UJaDxV9FPOjF9UmPRCc1BnyB7mF46H42VeADFthrdKbN4GXazJ+L8JTrIfi1CyngmCA MLSw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=dsER3YzFGLaHPBoku6jeyVqqT3YTo2fzV1h4qIHjsXM=; b=jTxfz4ob5INJeC32xxLFnS+pGU0R9qLkNzk9dqMykMpXu2t+vvKw/giIWYAJZPbxV/ i0JuaHq/OOs11rpSxkhYmVvYycBaPebT9g63BfdBDdGnwCucKNY3z1rjspxuzj8dKaji sCmLP6Ng79A/Gz6LB7RA/ymynckZTL/n26+2+uQGyixfGuJjwPQwkzMOlsPc/XSJNNCI tm/d/OYaBFJ5Bv5xEbj187C4AuId2STea+sqQDquILRbIw5yMdKON2cOqhnI59+HbBnv ReboQLVUZlbS/k3IggpzbBplSQpo5RDVecFOg2GOZQykieKv6PbarOv43aJdvQ/oA7ZZ hGRQ== X-Gm-Message-State: APzg51CTaCefMeqdA7GE2K/hkP51zkSBh3kDz78UXWJGLUHN6jo86cGF 1qt+U9A1NU4UtAZ+7Kd2FYB+cE6sJcG7vtrMSOk= X-Google-Smtp-Source: ANB0VdbObOO/rd7mro9I/MjupSIuXzyiKQ4wicUCugW/Gy9EZA6Kbgk7+8UVTuIMYNLOOH+KIEfPO7dRR9Vcw65JY4s= X-Received: by 2002:aca:fc8e:: with SMTP id a136-v6mr5979680oii.123.1536842591251; Thu, 13 Sep 2018 05:43:11 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: flatley Date: Thu, 13 Sep 2018 08:43:01 -0400 Message-ID: Subject: Re: monitoring tool To: pierreochsenbein@gmail.com Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ba31cf0575c00c04" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000ba31cf0575c00c04 Content-Type: text/plain; charset="UTF-8" 1) pgwatch2 - excellent metrics / performance dashboard - easy to configure https://www.cybertec-postgresql.com/en/products/pgwatch2/ 2) pghero - great for highlighting problems at the db level - easy to configure as well - https://github.com/ankane/pghero pgdash is supposed to be very good - https://pgdash.io/ netdata is an awesome product - more of a system monitoring tool but it does have a postgres plugin - this tool is very slick - https://github.com/firehol/netdata/wiki datadog is another system wide metrics tool - very impressive - https://docs.datadoghq.com/integrations/postgres/ On Thu, Sep 13, 2018 at 7:49 AM Pierre Ochsenbein < pierreochsenbein@gmail.com> wrote: > Hi Guy's, > > What is for you the best monitoring tool for PostgreSQL which we can > monitor a lot of databases? > > Cheers, > Pierre > --000000000000ba31cf0575c00c04 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
1) pgwatch2 - excellent metrics / performance da= shboard - easy to configure=C2=A0=C2=A0https://www.cybertec-postgresql.com/en/pr= oducts/pgwatch2/
2) pghero -=C2=A0 great for highlighting pro= blems at the db level - easy to configure as well -=C2=A0https://github.com/ankane/pghero
<= br>
pgdash is supposed to be very good -=C2=A0https://pgdash.io/
netdata is an awesome product = - more of a system monitoring tool but it does have a postgres plugin - thi= s tool is very slick=C2=A0 =C2=A0-=C2=A0=C2=A0https://github.com/firehol/netdata/wiki
datadog is another system wide metrics tool - very impressive -=C2=A0https://docs.data= doghq.com/integrations/postgres/
On Thu, Sep 13, 2018 at 7:49 A= M Pierre Ochsenbein <pierr= eochsenbein@gmail.com> wrote:
Hi Guy's,

What is for = you the best monitoring tool for PostgreSQL which we can monitor a lot of d= atabases?

Cheers,
Pierre
--000000000000ba31cf0575c00c04-- From pierreochsenbein@gmail.com Fri Jan 11 15:53:36 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzAu-0007rT-7z for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 15:56:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzAs-0000t3-Ug for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 15:56:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzAs-0000sv-Hb for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 15:56:46 +0000 Received: from mail-it1-x133.google.com ([2607:f8b0:4864:20::133]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzAp-0001iK-RH for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 15:56:44 +0000 Received: by mail-it1-x133.google.com with SMTP id h65so3478282ith.3 for ; Fri, 11 Jan 2019 07:56:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=JpUoH1lN64A3LAwStzEDVeRh4+SJ0WhxA1JZ2pYmkkE=; b=N8HSBPRJaDsAqi1Cdo4M0FIenjI4ciswUDNvI4Rs12ST6jhmw9soJzq6Gcb8ptJJbN 44TG8tPHjH6oIjIDHJOSErw/jlwP41xg4ewoWXn/GzX9CBGKlEH/Uq+mZzeBzlg2xqPA nzFO/P+b4dhZow//Uxu/mNUnsR8/JpKm0EUePT4nSsPPekF4ugruP+mRCkzy2ZT6+WoL IUcrMlNa6sukZoK/X6Fpt6aeG/YG0PPsq3QTUn11oGmMYLMWLcmJ14NbzdCRsd5MsXzJ BtPKvtHVAJjoefDnDiwCGvsUTixYB8jRoN3GL9xKRdgIQhgx4jznITTjBwKTipvZkbj2 VfZg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=JpUoH1lN64A3LAwStzEDVeRh4+SJ0WhxA1JZ2pYmkkE=; b=oV6db7EziQdpyj8JU4/DKcqya90coubqzf5WEoYQDikE0Segsb2ViC7tch/3u6aYHw vPSCtfa85QjdXxG3S3Xro5SYh4vDwXGTy7YyaOu8ymgZfsVHGg4FjZNXSX8kofJIx0zi mogyZHLAvH3ROh2MAVFbIH/YkhxMiqLzzD+nL5t+DEVQk6LgPiJgPuST6deCjaAIfv51 wPZgPoXZUHBeiLOma6FBVBT1qY8kSblzLZheIkAqmQDCNipziJJE+dZLiyQ0kvsVjQUd bZj+blGqr5hs1giEyofHG1j6aWNmnZgUfUZ7PpJ3+dN3OMiKd42Gcg0ln9Mq/ivRQPcO 3vSQ== X-Gm-Message-State: AJcUukcyViqUinw6L4Oecc1iKHqocHcV7MH+5iS/wD9K/TU11vyiqPtX S2yCF+I7EBs20FVBDSCVywndJJts9zm51jhHbmiUwSYw X-Google-Smtp-Source: ALg8bN7tT8/1uEr2ALzpQkKbG8I223kL4JTPUCQ8rti6kBXvHYCQWM+Jli98TsjG4ZydVAj4Lkkb8pkwb9qN2IClb2s= X-Received: by 2002:a24:cfc4:: with SMTP id y187mr1523329itf.144.1547222080881; Fri, 11 Jan 2019 07:54:40 -0800 (PST) MIME-Version: 1.0 From: Pierre Ochsenbein Date: Fri, 11 Jan 2019 16:53:36 +0100 Message-ID: Subject: Monitoring tool To: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000850b13057f30b699" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000850b13057f30b699 Content-Type: text/plain; charset="UTF-8" Hey guys, What is for you the best Monitoring/altering for PostgreSQL? Nagios? Thx --000000000000850b13057f30b699 Content-Type: text/html; charset="UTF-8"
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx
--000000000000850b13057f30b699-- From shreeyansh2014@gmail.com Fri Jan 11 16:04:30 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzKN-0008NT-2z for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:06:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzKL-00022q-Kz for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:06:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzKL-0001wf-7j for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:06:33 +0000 Received: from mail-yb1-xb30.google.com ([2607:f8b0:4864:20::b30]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzKI-0001vM-JW for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 16:06:32 +0000 Received: by mail-yb1-xb30.google.com with SMTP id 2so6016142ybw.4 for ; Fri, 11 Jan 2019 08:06:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=oyfSVbDHW+v833Hs51bKFCL/AgAR1nznVHiQl8lmdAA=; b=YMOjksS/yBJZXBq0fcytU/cqYyzveR3QGdhrirok+9hh5pA0DvDStThgpqFghrEKzY jqwhrJ2OI6TlS7YbXkJlbfCYs5VzUClLjjAW7/E26JSdt47DER1PC96nDXjoL99G68p1 bEF2aSS+DorufZNVXX+/gfCGmcF47d3Xm8f9sUvLPwoTnB4pkVStghBbFIH6n+ldDvEm W5c00ZzRslJUsyEvIj+nR3WoRuAa0TEehxWKUhbtDfJw7HrDlnM4TqtSQKwjIgBGKneS PyMgJDzNbXLRxM3ypre0CzrRhlYrebtCc8Rgi+Yu1f21qWxQ9nEqDR/xF16hxsvOVACf W/hw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=oyfSVbDHW+v833Hs51bKFCL/AgAR1nznVHiQl8lmdAA=; b=ac9SgojDwfPj43vsO2927qCQApwuKgAhbI+IJkn5cqAS4rfWZFAUviSHAfxGlZPOZY GcWW0ZrtW0qUZlgYKN02PKuC/nJo58HMcG/7mLLsXPKPzUuyQaQmgRp565A7R/QBy0W7 eK6LFunmZ9gg8La4+zmM8qB6m08o2bDAjWIcPTeYEUIsmJdU9PMcgLaGjm1CNaLu2VB2 cj/hfuwjCVdWrYGHS+5pYUCPill9gTT2Vd6n+/T3ZbDr/EYBEbikJHZPTA87w/82Wvjf w2c/m3a61CfQjKYVK44YVe9o2JMoFmDkjPbKRrxu9STz71al1xHkSTFAahilCbUSsBrJ b49A== X-Gm-Message-State: AJcUukfUIpUB9j+1fsqbXizi1auhls0IZthhDeBjOdqv6QSddzpAG/3y vEe1YxXGbmRU3pr/DJ/DeWzqhZv+Fncj1XdALUTyPQ== X-Google-Smtp-Source: ALg8bN57dhwULfLzzp83luhKy1TGaIFpyp+bTeiyCVG1CFQ9LMNLkJzd8W6Ix6SvO9xF4FKB7BZNi2O9iX0WW5TbdPI= X-Received: by 2002:a25:2b0a:: with SMTP id r10mr6388312ybr.315.1547222789049; Fri, 11 Jan 2019 08:06:29 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Shreeyansh Dba Date: Fri, 11 Jan 2019 21:34:30 +0530 Message-ID: Subject: Re: Monitoring tool To: Pierre Ochsenbein Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000bad79e057f30e0c1" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000bad79e057f30e0c1 Content-Type: text/plain; charset="UTF-8" Yes, Nagios is the best DB monitoring/alerting tool and its free opensource. Thanks & Regards, *Shreeyansh DBA Team* www.shreeyansh.com On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < pierreochsenbein@gmail.com> wrote: > Hey guys, > > What is for you the best Monitoring/altering for PostgreSQL? Nagios? > > Thx > --000000000000bad79e057f30e0c1 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes= , Nagios is the best DB monitoring/alerting tool and its free opensource.

<= div dir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature= ">
Thanks & Regards,
= Shreeyansh DBA Team
www.shreeyansh.com
=


On Fri, Jan= 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for Post= greSQL? Nagios?

Thx
--000000000000bad79e057f30e0c1-- From gilberto.castillo@etecsa.cu Fri Jan 11 16:32:35 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzji-0001mN-D9 for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:32:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzjh-0005B2-3V for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 16:32:45 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1ghzjg-0005Av-Rw for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 16:32:44 +0000 Received: from imx6.etecsa.cu ([200.55.152.141]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ghzjd-00030q-9m for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 16:32:44 +0000 Received: from mail.etecsa.cu (unknown [192.168.91.10]) by imx6.etecsa.cu (Postfix) with ESMTP id 306355EF; Fri, 11 Jan 2019 11:32:35 -0500 (CST) Received: from webmailrc.etecsa.cu (unknown [192.168.97.37]) (Authenticated sender: gilberto.castillo) by mail.etecsa.cu (Postfix) with ESMTPA id 1AEB03295EA3; Fri, 11 Jan 2019 11:32:35 -0500 (CST) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Date: Fri, 11 Jan 2019 11:32:35 -0500 From: gilberto.castillo@etecsa.cu To: Shreeyansh Dba Cc: Pierre Ochsenbein , pgsql-admin Subject: Re: [MASSMAIL]Re: Monitoring tool In-Reply-To: References: Message-ID: <77434576ab31646c5c836d1091d8fd40@etecsa.cu> X-Sender: gilberto.castillo@etecsa.cu User-Agent: Roundcube Webmail/1.2.5 X-KLMS-Rule-ID: 1 X-KLMS-Message-Action: clean X-KLMS-AntiSpam-Lua-Profiles: 133928 [Jan 11 2019] X-KLMS-AntiSpam-Version: 5.8.3.0 X-KLMS-AntiSpam-Envelope-From: gilberto.castillo@etecsa.cu X-KLMS-AntiSpam-Rate: 0 X-KLMS-AntiSpam-Status: not_detected X-KLMS-AntiSpam-Method: none X-KLMS-AntiSpam-Info: LuaCore: 232 232 27ac0ce265d8cfe64c397d431e1d2387c92c9415, Auth:dkim=none X-KLMS-AntiSpam-Interceptor-Info: scan successful X-KLMS-AntiPhishing: Clean, 2019/01/11 10:38:05 X-KLMS-AntiVirus: Kaspersky Security 8.0 for Linux Mail Server, version 8.0.1.721, bases: 2019/01/11 09:23:00 #9337516 X-KLMS-AntiVirus-Status: Clean, skipped List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Similarly CHECK_MK El 2019-01-11 11:04, Shreeyansh Dba escribió: > Yes, Nagios is the best DB monitoring/alerting tool and its free > opensource. > > Thanks & Regards, > SHREEYANSH DBA TEAM > www.shreeyansh.com [1] > > On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein > wrote: > >> Hey guys, >> >> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >> >> Thx > > > Links: > ------ > [1] http://www.shreeyansh.com From kokdemir@gmail.com Fri Jan 11 18:35:25 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1ef-0002Bq-VB for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 18:35:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gi1ed-0002fu-Dh for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 18:35:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1ed-0002fK-4r for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 18:35:39 +0000 Received: from mail-wr1-x42c.google.com ([2a00:1450:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1eb-0005zE-5B for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 18:35:38 +0000 Received: by mail-wr1-x42c.google.com with SMTP id j2so16314560wrw.1 for ; Fri, 11 Jan 2019 10:35:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=izeOIFkNQ0lXtVLMziMivJdo46RN7DXlOvJGQpYNdAs=; b=APQf3PU/yYzwcn1FCYpVD9nMcPntFAY6e8qRNuOKwMnJf7CrVWrVxJxQlS3uMrD86k V6NXn2TLrOf6j7rRc9Dm8asTo66dqvPBBRyWNMFzYywAXTbQXx1yfTSlZrITCulaFOis YcHgyY8LH5erJd3GByUKlip/mrbRFGkZ0+J5naaUUhsfDKb2GF9tXhzGEl+2qbbrmM9t 9sbvwSN8FrXDcoeJgFxPM2d0HeWp5taPoD84Gysaa54CnWBpBCh0obrOgRkxzNt4KceJ WOEKTXDCjqulWN0TiExHB3dsiaHLMru/4XOoClVr9M0Wf9t1dEbORelMBSY8IamV2kPN gMlQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=izeOIFkNQ0lXtVLMziMivJdo46RN7DXlOvJGQpYNdAs=; b=MmgbFnt1vktzyHo+Dc/oyNQH18WxzBlW8PFfnmv2+I3od9CNHdT/wMsonrLC2QkxOl y+Ec+Bg+4fLfJlTsjJd5eqcn0dgK7YhsF5vv1PTu+Zgf1o2S5LZCR2fDgLClhlN+ivPC RsKaeCS5ltcd9Mh3TDV4WzbM1UbR0m3gvmyjTooj1yllIgkcqXqE7NytSwftBQ0zFT6K SzlnOg+a/dlTmo5jDMhuJhXlgYiG54mboucPoLVHp1I2n6RSqm4yed0HUQWhqjLE3tOM cyiTHy6KdrUiZpr/Shh3WIc4Ts2KrwJNc8ChsKhqaLo1TWXonR/S/fqwn4fGNsKWQZAS q/FQ== X-Gm-Message-State: AJcUukdf4sthO7n71ihGjaRfDDPptuA7mIz2m2zBsPuy4UQa9oRfL9l5 0q5kxEAFv9UpkCu/xbof1KFtJJJG4B6fPeUvOfY= X-Google-Smtp-Source: ALg8bN5FMSTvpBhiQuxgYaB+X2b7Z18NXlC+hesTvlq/T9zJNtU0yB9sPE4qW6TlWT4axb2bpD/5j4Vxsg5bKlVyFn8= X-Received: by 2002:adf:e6ce:: with SMTP id y14mr15202807wrm.239.1547231736233; Fri, 11 Jan 2019 10:35:36 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ibrahim Edib Kokdemir Date: Fri, 11 Jan 2019 21:35:25 +0300 Message-ID: Subject: Re: Monitoring tool To: Pierre Ochsenbein Cc: pgsql-admin Content-Type: multipart/alternative; boundary="000000000000060478057f32f6cb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000060478057f32f6cb Content-Type: text/plain; charset="UTF-8" What exactly is your expectation from a monitoring system? If it is just a postgres server that you want to monitor and and regular alerts, nagios is the shortest path. But if you want more, for example enterprise level monitoring system (graphs, history, maps, predictions) and if you have many other servers along with postgres server(s), I personally suggest you zabbix, but zabbix needs some additional helpers like mamonsu or libzbxpgsql for for postgres monitoring. Regards, Ibrahim. On Fri, 11 Jan 2019, 18:56 Pierre Ochsenbein Hey guys, > > What is for you the best Monitoring/altering for PostgreSQL? Nagios? > > Thx > --000000000000060478057f32f6cb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
What exactly is your expectation fro= m a monitoring system? If it is just a postgres server that you want to mon= itor and and regular alerts, nagios is the shortest path. But if you want m= ore, for example enterprise level monitoring system (graphs, history, maps,= predictions) and if you have=C2=A0 many other servers along with postgres = server(s), I personally suggest you zabbix, but zabbix needs some additiona= l helpers like mamonsu or=C2=A0libzbxpgsql=C2=A0for=C2=A0 for postgres moni= toring.=C2=A0

Regards,
Ibrahim.

On Fri, 11 Jan 201= 9, 18:56 Pierre Ochsenbein <pierreochsenbein@gmail.com wrote:
Hey guys,

What is for you the best Monitoring/altering for Po= stgreSQL? Nagios?

Thx
--000000000000060478057f32f6cb-- From webervin@gmail.com Fri Jan 11 18:54:33 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1xJ-0003ZX-1D for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 18:54:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gi1xH-00078c-Hv for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 18:54:55 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1xH-00078T-49 for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 18:54:55 +0000 Received: from mail-lf1-x129.google.com ([2a00:1450:4864:20::129]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi1xE-0005rP-1g for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 18:54:53 +0000 Received: by mail-lf1-x129.google.com with SMTP id b20so11489921lfa.12 for ; Fri, 11 Jan 2019 10:54:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc:content-transfer-encoding; bh=+N1jvNyS1fQ45DGFDp2KgXScEUYsf+ihuLn6BdbFEyY=; b=M4tEl3yiaRc4Z9sTNd2PKwocE9FswOFKy2PzzdYAB/pOblEGbZwKTo5eRmJPy3jr/h +rPA0HeZDXb7CAcV14OTG0UYv2tD/KxzhAT6WgB9R1qha1wENS5iJNeVrs8rkAocJPzA X5nb6oPs8TS/mvzGgy/ukQGddAxtToST5YvO4H+1nqGwcyaxclm/I0O4LAZ6sCnYQXB3 gsFOdqO+xDgZAkqqMy1YKspWSFYwVykzOsazHH+/65LD71goth0482q3glHhXK5+3H5I gmbjVt8sUBJ5+xNybSgQzLi6j8Iw4j+i7fRwdAscAvskHbqYFwJcUAWmcG+/t5vb62qM 31+A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc:content-transfer-encoding; bh=+N1jvNyS1fQ45DGFDp2KgXScEUYsf+ihuLn6BdbFEyY=; b=ACDQZxS+T+KxdD9Wf/bfnk7LB7GaSV0p4NaByTDKsCiuotKe/RiKLhfP/P9TBhn88M EJpDLscsk/V2WOpafiiqXB8QJ+swsfVwJRviJz4/olYsnqPwUtcqxZAVJ1wfdhlhEqCv k1Vc6IrDW8K9nr3MICuCqCatCXj20T+u/eYBid97hAfRIm1qXehj3MlGDOCNHdCZL83v IA0g4nzzUQ/WKx+lr7D0Wpc+cQY38G0NlK32czKEJjDhajh0xUKp4S7yNQQNUpb/LamK Z6EBbhl1eQFERM9cYhrz3YFBEZBUlL4ihLMD1qziXpSryhE1hh62KJn1akiL8qqXABhD YHzw== X-Gm-Message-State: AJcUukdQCX8SZhowPmUdIcT3b5mFOeT8cvCM83Sq1GmrrmOnPtiQMqSp hKR0HApfQWMAVni3Ns9FpVRN4O/+46UeUOKY+Ik= X-Google-Smtp-Source: ALg8bN6Q3zs7sK84sEFT+EhKGi3yOBUiIuuP0fPwXebyiWE0BnhHGPVIgPwbl/TDwGuGeEBJ6szhQQio+qLLyMioKPM= X-Received: by 2002:a19:5402:: with SMTP id i2mr8497609lfb.128.1547232889472; Fri, 11 Jan 2019 10:54:49 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ervin Weber Date: Fri, 11 Jan 2019 20:54:33 +0200 Message-ID: Subject: Re: Monitoring tool To: Ibrahim Edib Kokdemir Cc: Pierre Ochsenbein , pgsql-admin Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hello, Pierre. In last postgresql.eu conference https://prometheus.io/ was mentioned in several talks. https://www.postgresql.eu/events/pgconfeu2018/schedule/session/2190-using-p= rometheus-and-grafana-for-postgresql-monitoring-in-tomtom/ for example. That said I had a lot of time invested in munin (and to teach it to use auto-discovery of everything), so personally did not yet switch to use prometheus. I'm most interested in advanced alert criteria that one could setup in prometheus, and if you are looking for best alerting - it is worth investigating. Nagios may still be more popular choice, because it is older, and more widespread. Yet when I was picking monitoring - I needed easy setup and ability to write own plugins with little effort, so I picked munin over nagios several years ago. Also there is opinion worth getting your attention, if you do research on nagios - saying that nagios may be too old for competition - https://www.slideshare.net/superdupersheep/stop-using-nagios-so-it-can-die-= peacefully Best, Ervin On Fri, 11 Jan 2019 at 20:35, Ibrahim Edib Kokdemir wr= ote: > > What exactly is your expectation from a monitoring system? If it is just = a postgres server that you want to monitor and and regular alerts, nagios i= s the shortest path. But if you want more, for example enterprise level mon= itoring system (graphs, history, maps, predictions) and if you have many o= ther servers along with postgres server(s), I personally suggest you zabbix= , but zabbix needs some additional helpers like mamonsu or libzbxpgsql for = for postgres monitoring. > > Regards, > Ibrahim. > > On Fri, 11 Jan 2019, 18:56 Pierre Ochsenbein > >> Hey guys, >> >> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >> >> Thx From prince.pathria@goevive.com Fri Jan 11 22:06:22 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi4xO-0007Ny-UZ for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 22:07:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gi4xL-0005JL-1G for pgsql-admin@arkaria.postgresql.org; Fri, 11 Jan 2019 22:07:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi4xK-0005Ix-F1 for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 22:07:10 +0000 Received: from mail-qt1-x82c.google.com ([2607:f8b0:4864:20::82c]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi4xG-0002JJ-Lv for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 22:07:09 +0000 Received: by mail-qt1-x82c.google.com with SMTP id t33so20541397qtt.4 for ; Fri, 11 Jan 2019 14:07:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=goevive.com; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=wIWEA86GGWlfXa0wXiouCQwT35Ngk/pBPXe/t9KFBE0=; b=VH8aUaTB610XxF9Daw8RPenUAFVxQKesFpvI3oV8Fm0Bcp6Fc02YrRKFyuiqqXZv/T ZWy3SeatQ+Ok44yt+6EX3b4zb2oEPQkuDuwa4Kl286BTfYl1/WA57xZBpGFJHMh57s8W xbSmHbemkFuSHrkJDt4o7TCuZcfv2Qq1JQPYk= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=wIWEA86GGWlfXa0wXiouCQwT35Ngk/pBPXe/t9KFBE0=; b=CmHUR6qd1vFkAqvFZgKhFSkBF0d+aIwvfOEVS4KJeXeIezTb+6rRZuC8wSYsYTA7dq WvL8ohYjuspK6S70ndEF+SJy5Q1CA3SEwHU5Js4Tl+x+qjaIdnxLFyIOAIBLbL7ooP8J kuUSh/O6p7OKxathUsd5Qs4m7WAsYapWezJBa/RCfuntuwSk6UqgO8xQylmGjinv5ZvA /7bPHJUeg3LmBD5kGcWV5/jhoLbayZHTuiqVYD0MsV+fqEROR8ZKn/ykPQRTKmDv6vCv SFs0jxb7IxKwYxxsb09gmwgkdX5ayFfHb+qvXt0S6c0AieLxfalxNNUD0ymuOWephEJX nF7g== X-Gm-Message-State: AJcUukcZ7x7H6GCs+RiGNmoRUJ4hDQ6AXSBNYA5cPXUeXShwCd1LeLt9 EJcL83Ns2oHipd6KjYTWKrflhsxO5VJyRyH2dijdng== X-Google-Smtp-Source: ALg8bN6jkhhZ5BaRHjmvRdDxSwTgSeTWUTMIsGAlVO0M84PIMm6sxJA48UM5SJY/VT/pQglrqAx05xS6vk5E35DxAlQ= X-Received: by 2002:ac8:44d4:: with SMTP id b20mr15140142qto.340.1547244424936; Fri, 11 Jan 2019 14:07:04 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Prince Pathria Date: Sat, 12 Jan 2019 03:36:22 +0530 Message-ID: Subject: Re: Monitoring tool To: Shreeyansh Dba Cc: Pierre Ochsenbein , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000545742057f35ea46" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000545742057f35ea46 Content-Type: text/plain; charset="UTF-8" On what stats should we actually keep a track on? On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba Yes, Nagios is the best DB monitoring/alerting tool and its free > opensource. > > Thanks & Regards, > *Shreeyansh DBA Team* > www.shreeyansh.com > > > On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < > pierreochsenbein@gmail.com> wrote: > >> Hey guys, >> >> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >> >> Thx >> > --000000000000545742057f35ea46 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On what stats should we actually keep a track on?
On Fri, 11 Jan, 2019, 9:36 PM= Shreeyansh Dba <shreeyansh2= 014@gmail.com wrote:
Yes, Nagios= is the best DB monitoring/alerting tool and its free opensource.

=
Thanks & R= egards,
Shreeyansh DBA Team
www.shreeyansh.co= m


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <= ;pierreochsenbein@gmail.com> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQ= L? Nagios?

Thx
--000000000000545742057f35ea46-- From Kaido.Vaikla@telia.ee Fri Jan 11 22:23:47 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giIfL-0006lw-D5 for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 12:45:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giIfK-00053L-3Q for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 12:45:30 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi5DU-0001mK-GM for pgsql-admin@lists.postgresql.org; Fri, 11 Jan 2019 22:23:52 +0000 Received: from edge1.elion.ee ([88.196.160.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi5DR-0002fz-LL for pgsql-admin@postgresql.org; Fri, 11 Jan 2019 22:23:52 +0000 Received: from MBX02.et.ee (80.235.4.98) by edge1.elion.ee (88.196.160.130) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1591.10; Sat, 12 Jan 2019 00:23:47 +0200 Received: from Breakdramon.et.ee (80.235.4.101) by MBX02.et.ee (80.235.4.98) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.1591.10; Sat, 12 Jan 2019 00:23:47 +0200 Received: from Breakdramon.et.ee ([fe80::d0a6:2a38:5506:1920]) by Breakdramon.et.ee ([fe80::d0a6:2a38:5506:1920%2]) with mapi id 15.01.1591.008; Sat, 12 Jan 2019 00:23:47 +0200 From: Kaido Vaikla To: Prince Pathria , Shreeyansh Dba CC: Pierre Ochsenbein , pgsql-admin Subject: RE: Monitoring tool Thread-Topic: Monitoring tool Thread-Index: AQHUqfoBveTEVoCSJ0ieKejxPS3m6aWqpGRA Date: Fri, 11 Jan 2019 22:23:47 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US, et-EE Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [194.126.96.50] x-c2processedorg: 7b1fd40b-7081-408c-8912-a93169e16698 Content-Type: multipart/alternative; boundary="_000_e567c0e85a8949c4b4e38b95f5f12921teliaee_" MIME-Version: 1.0 X-EsetResult: clean, is OK X-EsetId: 37303A291638F66B657763 X-ESET-NDR: 010063208CD5E210C4468E7756C0C39C1A93EDBF87C1F3683A5C0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_e567c0e85a8949c4b4e38b95f5f12921teliaee_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 QW5kLCB3aGF0IGlzIHlvdXIgYnVkZ2V0Pw0KT3Igc2hvdWxkIGl0IGJlIGEgZnJlZXdhcmU/DQoN CmJyDQpLYWlkbw0KDQpGcm9tOiBQcmluY2UgUGF0aHJpYSBbbWFpbHRvOnByaW5jZS5wYXRocmlh QGdvZXZpdmUuY29tXQ0KU2VudDogU2F0dXJkYXksIEphbnVhcnkgMTIsIDIwMTkgMTI6MDYgQU0N ClRvOiBTaHJlZXlhbnNoIERiYSA8c2hyZWV5YW5zaDIwMTRAZ21haWwuY29tPg0KQ2M6IFBpZXJy ZSBPY2hzZW5iZWluIDxwaWVycmVvY2hzZW5iZWluQGdtYWlsLmNvbT47IHBnc3FsLWFkbWluIDxw Z3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZz4NClN1YmplY3Q6IFJlOiBNb25pdG9yaW5nIHRvb2wN Cg0KT24gd2hhdCBzdGF0cyBzaG91bGQgd2UgYWN0dWFsbHkga2VlcCBhIHRyYWNrIG9uPw0KDQpP biBGcmksIDExIEphbiwgMjAxOSwgOTozNiBQTSBTaHJlZXlhbnNoIERiYSA8c2hyZWV5YW5zaDIw MTRAZ21haWwuY29tPG1haWx0bzpzaHJlZXlhbnNoMjAxNEBnbWFpbC5jb20+IHdyb3RlOg0KWWVz LCBOYWdpb3MgaXMgdGhlIGJlc3QgREIgbW9uaXRvcmluZy9hbGVydGluZyB0b29sIGFuZCBpdHMg ZnJlZSBvcGVuc291cmNlLg0KDQpUaGFua3MgJiBSZWdhcmRzLA0KU2hyZWV5YW5zaCBEQkEgVGVh bQ0Kd3d3LnNocmVleWFuc2guY29tPGh0dHA6Ly93d3cuc2hyZWV5YW5zaC5jb20+DQoNCg0KT24g RnJpLCBKYW4gMTEsIDIwMTkgYXQgOToyNiBQTSBQaWVycmUgT2Noc2VuYmVpbiA8cGllcnJlb2No c2VuYmVpbkBnbWFpbC5jb208bWFpbHRvOnBpZXJyZW9jaHNlbmJlaW5AZ21haWwuY29tPj4gd3Jv dGU6DQpIZXkgZ3V5cywNCg0KV2hhdCBpcyBmb3IgeW91IHRoZSBiZXN0IE1vbml0b3JpbmcvYWx0 ZXJpbmcgZm9yIFBvc3RncmVTUUw/IE5hZ2lvcz8NCg0KVGh4DQo= --_000_e567c0e85a8949c4b4e38b95f5f12921teliaee_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 Q2FsaWJyaTsNCglwYW5vc2UtMToyIDE1IDUgMiAyIDIgNCAzIDIgNDt9DQovKiBTdHlsZSBEZWZp bml0aW9ucyAqLw0KcC5Nc29Ob3JtYWwsIGxpLk1zb05vcm1hbCwgZGl2Lk1zb05vcm1hbA0KCXtt YXJnaW46MGNtOw0KCW1hcmdpbi1ib3R0b206LjAwMDFwdDsNCglmb250LXNpemU6MTIuMHB0Ow0K CWZvbnQtZmFtaWx5OiJUaW1lcyBOZXcgUm9tYW4iLHNlcmlmO30NCmE6bGluaywgc3Bhbi5Nc29I eXBlcmxpbmsNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOmJsdWU7DQoJdGV4dC1k ZWNvcmF0aW9uOnVuZGVybGluZTt9DQphOnZpc2l0ZWQsIHNwYW4uTXNvSHlwZXJsaW5rRm9sbG93 ZWQNCgl7bXNvLXN0eWxlLXByaW9yaXR5Ojk5Ow0KCWNvbG9yOnB1cnBsZTsNCgl0ZXh0LWRlY29y YXRpb246dW5kZXJsaW5lO30NCnNwYW4uRW1haWxTdHlsZTE3DQoJe21zby1zdHlsZS10eXBlOnBl cnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJBcmlhbCIsc2Fucy1zZXJpZjsNCgljb2xvcjpi bGFjazt9DQouTXNvQ2hwRGVmYXVsdA0KCXttc28tc3R5bGUtdHlwZTpleHBvcnQtb25seTsNCglm b250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjsNCgltc28tZmFyZWFzdC1sYW5ndWFnZTpF Ti1VUzt9DQpAcGFnZSBXb3JkU2VjdGlvbjENCgl7c2l6ZTo2MTIuMHB0IDc5Mi4wcHQ7DQoJbWFy Z2luOjcwLjg1cHQgNzAuODVwdCA3MC44NXB0IDcwLjg1cHQ7fQ0KZGl2LldvcmRTZWN0aW9uMQ0K CXtwYWdlOldvcmRTZWN0aW9uMTt9DQotLT48L3N0eWxlPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1s Pg0KPG86c2hhcGVkZWZhdWx0cyB2OmV4dD0iZWRpdCIgc3BpZG1heD0iMTAyNiIgLz4NCjwveG1s PjwhW2VuZGlmXS0tPjwhLS1baWYgZ3RlIG1zbyA5XT48eG1sPg0KPG86c2hhcGVsYXlvdXQgdjpl eHQ9ImVkaXQiPg0KPG86aWRtYXAgdjpleHQ9ImVkaXQiIGRhdGE9IjEiIC8+DQo8L286c2hhcGVs YXlvdXQ+PC94bWw+PCFbZW5kaWZdLS0+DQo8L2hlYWQ+DQo8Ym9keSBsYW5nPSJFVCIgbGluaz0i Ymx1ZSIgdmxpbms9InB1cnBsZSI+DQo8ZGl2IGNsYXNzPSJXb3JkU2VjdGlvbjEiPg0KPHAgY2xh c3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMS4wcHQ7Zm9udC1mYW1pbHk6 JnF1b3Q7QXJpYWwmcXVvdDssc2Fucy1zZXJpZjtjb2xvcjpibGFjazttc28tZmFyZWFzdC1sYW5n dWFnZTpFTi1VUyI+QW5kLCB3aGF0IGlzIHlvdXIgYnVkZ2V0Pzxicj4NCk9yIHNob3VsZCBpdCBi ZSBhIGZyZWV3YXJlPzxicj4NCjxicj4NCmJyPGJyPg0KS2FpZG88bzpwPjwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0iZm9udC1zaXplOjExLjBwdDtm b250LWZhbWlseTomcXVvdDtBcmlhbCZxdW90OyxzYW5zLXNlcmlmO2NvbG9yOmJsYWNrO21zby1m YXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8cCBj bGFzcz0iTXNvTm9ybWFsIj48Yj48c3BhbiBsYW5nPSJFTi1VUyIgc3R5bGU9ImZvbnQtc2l6ZTox MS4wcHQ7Zm9udC1mYW1pbHk6JnF1b3Q7Q2FsaWJyaSZxdW90OyxzYW5zLXNlcmlmIj5Gcm9tOjwv c3Bhbj48L2I+PHNwYW4gbGFuZz0iRU4tVVMiIHN0eWxlPSJmb250LXNpemU6MTEuMHB0O2ZvbnQt ZmFtaWx5OiZxdW90O0NhbGlicmkmcXVvdDssc2Fucy1zZXJpZiI+IFByaW5jZSBQYXRocmlhIFtt YWlsdG86cHJpbmNlLnBhdGhyaWFAZ29ldml2ZS5jb21dDQo8YnI+DQo8Yj5TZW50OjwvYj4gU2F0 dXJkYXksIEphbnVhcnkgMTIsIDIwMTkgMTI6MDYgQU08YnI+DQo8Yj5Ubzo8L2I+IFNocmVleWFu c2ggRGJhICZsdDtzaHJlZXlhbnNoMjAxNEBnbWFpbC5jb20mZ3Q7PGJyPg0KPGI+Q2M6PC9iPiBQ aWVycmUgT2Noc2VuYmVpbiAmbHQ7cGllcnJlb2Noc2VuYmVpbkBnbWFpbC5jb20mZ3Q7OyBwZ3Nx bC1hZG1pbiAmbHQ7cGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmcmZ3Q7PGJyPg0KPGI+U3ViamVj dDo8L2I+IFJlOiBNb25pdG9yaW5nIHRvb2w8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4NCjxkaXY+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj5PbiB3aGF0IHN0YXRzIHNob3VsZCB3ZSBhY3R1YWxseSBrZWVwIGEgdHJhY2sgb24/ PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxvOnA+Jm5ic3A7 PC9vOnA+PC9wPg0KPGRpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5PbiBGcmksIDEx IEphbiwgMjAxOSwgOTozNiBQTSBTaHJlZXlhbnNoIERiYSAmbHQ7PGEgaHJlZj0ibWFpbHRvOnNo cmVleWFuc2gyMDE0QGdtYWlsLmNvbSI+c2hyZWV5YW5zaDIwMTRAZ21haWwuY29tPC9hPiB3cm90 ZTo8bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0KPGJsb2NrcXVvdGUgc3R5bGU9ImJvcmRlcjpub25l O2JvcmRlci1sZWZ0OnNvbGlkICNDQ0NDQ0MgMS4wcHQ7cGFkZGluZzowY20gMGNtIDBjbSA2LjBw dDttYXJnaW4tbGVmdDo0LjhwdDttYXJnaW4tcmlnaHQ6MGNtIj4NCjxkaXY+DQo8ZGl2Pg0KPHAg Y2xhc3M9Ik1zb05vcm1hbCI+WWVzLCBOYWdpb3MgaXMgdGhlIGJlc3QgREIgbW9uaXRvcmluZy9h bGVydGluZyB0b29sIGFuZCBpdHMgZnJlZSBvcGVuc291cmNlLjxvOnA+PC9vOnA+PC9wPg0KPC9k aXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8 L2Rpdj4NCjxkaXY+DQo8ZGl2Pg0KPGRpdj4NCjxkaXY+DQo8ZGl2Pg0KPGRpdj4NCjxkaXY+DQo8 ZGl2Pg0KPGRpdj4NCjxkaXY+DQo8ZGl2Pg0KPGRpdj4NCjxkaXY+DQo8ZGl2Pg0KPGRpdj4NCjxk aXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+VGhhbmtzICZhbXA7IFJlZ2FyZHMsPGJy Pg0KPGI+U2hyZWV5YW5zaCBEQkEgVGVhbTwvYj48YnI+DQo8c3BhbiBzdHlsZT0iZm9udC1zaXpl OjcuNXB0Ij48YSBocmVmPSJodHRwOi8vd3d3LnNocmVleWFuc2guY29tIiB0YXJnZXQ9Il9ibGFu ayI+d3d3LnNocmVleWFuc2guY29tPC9hPjwvc3Bhbj48bzpwPjwvbzpwPjwvcD4NCjwvZGl2Pg0K PC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8 L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Rpdj4NCjwv ZGl2Pg0KPC9kaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZuYnNwOzwvbzpwPjwvcD4N CjwvZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8ZGl2 Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk9uIEZyaSwgSmFuIDExLCAyMDE5IGF0IDk6 MjYgUE0gUGllcnJlIE9jaHNlbmJlaW4gJmx0OzxhIGhyZWY9Im1haWx0bzpwaWVycmVvY2hzZW5i ZWluQGdtYWlsLmNvbSIgdGFyZ2V0PSJfYmxhbmsiPnBpZXJyZW9jaHNlbmJlaW5AZ21haWwuY29t PC9hPiZndDsgd3JvdGU6PG86cD48L286cD48L3A+DQo8L2Rpdj4NCjxibG9ja3F1b3RlIHN0eWxl PSJib3JkZXI6bm9uZTtib3JkZXItbGVmdDpzb2xpZCAjQ0NDQ0NDIDEuMHB0O3BhZGRpbmc6MGNt IDBjbSAwY20gNi4wcHQ7bWFyZ2luLWxlZnQ6NC44cHQ7bWFyZ2luLXJpZ2h0OjBjbSI+DQo8ZGl2 Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPkhleSBndXlzLDxvOnA+PC9vOnA+PC9wPg0K PC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+ DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5XaGF0IGlzIGZvciB5b3UgdGhl IGJlc3QgTW9uaXRvcmluZy9hbHRlcmluZyBmb3IgUG9zdGdyZVNRTD8gTmFnaW9zPzxvOnA+PC9v OnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8 L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj5UaHg8bzpwPjwv bzpwPjwvcD4NCjwvZGl2Pg0KPC9kaXY+DQo8L2Jsb2NrcXVvdGU+DQo8L2Rpdj4NCjwvYmxvY2tx dW90ZT4NCjwvZGl2Pg0KPC9kaXY+DQo8L2JvZHk+DQo8L2h0bWw+DQo= --_000_e567c0e85a8949c4b4e38b95f5f12921teliaee_-- From ramesh.esl@gmail.com Sat Jan 12 00:14:35 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi6wx-00071s-S5 for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 00:14:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gi6wv-0007JJ-AW for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 00:14:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi6wu-00075C-Rc for pgsql-admin@lists.postgresql.org; Sat, 12 Jan 2019 00:14:53 +0000 Received: from mail-qt1-x836.google.com ([2607:f8b0:4864:20::836]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gi6wq-0004ik-7n for pgsql-admin@postgresql.org; Sat, 12 Jan 2019 00:14:51 +0000 Received: by mail-qt1-x836.google.com with SMTP id i7so20807284qtj.10 for ; Fri, 11 Jan 2019 16:14:47 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=8sBtwavQeb2ITMy868i97zVns5B2+ypwKAUx7ER3uRA=; b=BFQuVHhe7lchisY9oZr9olI2nS66dYtHV+FvjCbFI4UFZEQhXCd+2Z12yxGfGU6PIu 0uBkWXLwgm2PiZga7dsjQZ/VGDk1ZYUYM19ZR0tGYZ7KOIt0nTrV4jA4wNTZPDKeRzqS ktYOadRxvO6dDrtJT84uYnxETS/F3zuN/TJFGchL98IFO10VUF1MSI2JQyTFAxoYQrj+ eKq9MLXPKpjP2eJgz//od6gMCDHd+HiZkF0wTSGoVf4eA5UJ0aTQx82OHBMi8o7FHjpl d75olHjyuYHBFovceJs1dd+5M9D/q7iVm82GLSixpjaQZhVHuLkrakSn90x9mKzGF6PH KDkQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=8sBtwavQeb2ITMy868i97zVns5B2+ypwKAUx7ER3uRA=; b=ZQLx+3bdKv2X9BxJuwe9xwkeGG0PR9j6GK3B+qG0CAr/E3+Lu7yKQ3Ppms79W4DeUw oYIjFZbll/IRFmlsfYyJ34wxQGnR0GEB3P6I6AStuvQipOn4lcmXQ+eHTBofurO2kfT0 hmv8k4zHhO1joObtYaPdeL5zQlWRNNch77Kp01LXwEN3TbNLrxRbmi9CZQfYpTG03RdA 0k76I+bfY4pwnWDQZmALleJV9itRuxNeP1GdWdinXvDnXyx24t7H0cd5mZp7XCF1pVcK Gt/RrqSszMZzTXiF0nJN9eeN3+Pf6Szf5kRIeY1NOjFpxjg5mQPB6UM7RCg/z0zBiNeN BWPA== X-Gm-Message-State: AJcUukciC7WaS3U3Gv9a+5F30JjClKvDrfm3Flb9o8PrCZztkanS8YnD v+zxX7yBkbKfFkKuAbEQHgpX9ALqs+iTC8BawjQ= X-Google-Smtp-Source: ALg8bN78oasHATGwaUpcWAqkGKBtSSAd2WTz0byIsafoBY3pUKyEn4ervZBMHHM3uKnsJasEvDetI7gieuJpKQbE/cI= X-Received: by 2002:aed:356d:: with SMTP id b42mr16295176qte.186.1547252087011; Fri, 11 Jan 2019 16:14:47 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Ramesh naik Date: Sat, 12 Jan 2019 08:14:35 +0800 Message-ID: Subject: Re: Monitoring tool To: Prince Pathria Cc: Pierre Ochsenbein , Shreeyansh Dba , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000064048057f37b35b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000064048057f37b35b Content-Type: text/plain; charset="UTF-8" Hi Pierre, Zabbix and nagios are old school monitoring tools. Try to setup your own monitoring stack using (node_exporter+ postgres_exporter), Prometheus and Grafana. Checkout pgmonitor from crunchydata https://github.com/CrunchyData/pgmonitor And check the latest slide pack on PostgreSQL monitoring using Prometheus n Grafana from Gregory Stark https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2166/slides/147/monitoring.pdf Regards, Ramesh On Sat, 12 Jan 2019 at 6:07 AM, Prince Pathria wrote: > On what stats should we actually keep a track on? > > On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba wrote: > >> Yes, Nagios is the best DB monitoring/alerting tool and its free >> opensource. >> >> Thanks & Regards, >> *Shreeyansh DBA Team* >> www.shreeyansh.com >> >> >> On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < >> pierreochsenbein@gmail.com> wrote: >> >>> Hey guys, >>> >>> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >>> >>> Thx >>> >> -- Regards, Ramesh Naik E +65 8202 7519 --000000000000064048057f37b35b Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Pierre,

Zabbix and nagios =C2=A0are old school monitoring tool= s.=C2=A0
Try to setup your own monitoring stack usin= g =C2=A0(node_exporter+ postgres_exporter), Prometheus and =C2=A0Grafana. = =C2=A0=C2=A0
C= heckout pgmonitor from crunchydata=C2=A0
And check the latest =C2=A0 sli= de pack =C2=A0on PostgreSQL monitoring using Prometheus n Grafana from Greg= ory Stark=C2=A0
Regards,
Ramesh=C2=A0


On Sat, 12 Jan 2019 at 6:07 AM, Prince Pathria <prince.pathria= @goevive.com> wrote:
On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreey= ansh Dba <= shreeyansh2014@gmail.com wrote:
Ye= s, Nagios is the best DB monitoring/alerting tool and its free opensource.<= /div>

=
<= div>
Thanks & Rega= rds,
Shreeyansh DBA Team
www.shreeyansh.com
=


Hey guys,
=
What is for you the best Monitoring/altering for PostgreSQL?= Nagios?

Thx
--
Regards,
Ramesh Naik E=C2=A0

+65 8202 7519


--000000000000064048057f37b35b-- From shreeyansh2014@gmail.com Sat Jan 12 05:26:34 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giBqe-0008Fe-U4 for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 05:28:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giBqb-0007Ms-FX for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 05:28:41 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giBqa-0007Ml-SC for pgsql-admin@lists.postgresql.org; Sat, 12 Jan 2019 05:28:41 +0000 Received: from mail-yb1-xb2c.google.com ([2607:f8b0:4864:20::b2c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giBqT-000342-9s for pgsql-admin@postgresql.org; Sat, 12 Jan 2019 05:28:39 +0000 Received: by mail-yb1-xb2c.google.com with SMTP id q2so6692218ybd.12 for ; Fri, 11 Jan 2019 21:28:33 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=JvBgETX7zeiqeMpCxghdAL0KXPS3T7WljAF16QfPAr8=; b=URVmmV+Uf6EJ3ZIey+FedLO5Sxt/xp2rurzPoy+nHRhVzKIPl7GniNs37AqfvDxOCr S7yYcQ+AfJShAXXDGQUZ64TmoWdUMdXqlgl3zVFwhn0yd+XL74Z8b0t4ocG4Rs7Dd98c BwGgD/hcb2djNYvHV06IODG2Sd6OrZNLscMFnnALHbDPxf2Ihw0Y0XM+q4y2FtFkjHP4 4ON6KDqPgMy84doFnSGXD0enIfAbprbj0c5v84Yp2kwqCO5yo9P2d0NIr3w6dCCaST3u OYlbk/9Nui8VD6IG8IixDVqooEbG9oFnQI5x0eVXUGFF2W68ik3la2+zUgZeZ5TDY0A4 t9Qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=JvBgETX7zeiqeMpCxghdAL0KXPS3T7WljAF16QfPAr8=; b=sMvApzRmnR6upNPypG3ZVU8g1jlMxHnh14sSogvM4RX8Kj00W1K/aLYDH2RddUUz6O 5zkVGx6jmGi812UnWYVAdCEZ6w4cJi5XGj1etrqRFzculybYaeThpW04G4jcLF7ujeXH ct3ZPMbk78N63kof/Ftu31K9zL0bYhtMxJkOcOD+LTdajB/TrGN9cZ/ged5002M3a8WU tJi7EcQ4S7GKmzcK/Nmqc5LIras9gUFfWbqQIMF6IkIlzoUSBH+JSkr6IS+ozYEZvGWH a5C+BzaDlbo7SddsN3otUniYbMnR9tWY8Dxulw9CuEieOuN5M4mz/caZXTdGH3p68gzS sYEQ== X-Gm-Message-State: AJcUukcd4TQy9F++sjwisw0IT2o/FZEMNRWj9ipQvxzLpYAwnvfD/lAO 5f9g62kBCNfD9ONuW+j7eVOTcF42piKbjXbyNjg= X-Google-Smtp-Source: ALg8bN595R8oFPL6Vo9UpS1b1hROzVPmjAEJEtwlBmfTPeDFc39qroUfRPDf/I7OsDffOdq3/RQ+S+62xO90u+5m0k4= X-Received: by 2002:a25:2b0a:: with SMTP id r10mr8390477ybr.315.1547270912443; Fri, 11 Jan 2019 21:28:32 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Shreeyansh Dba Date: Sat, 12 Jan 2019 10:56:34 +0530 Message-ID: Subject: Re: Monitoring tool To: Prince Pathria Cc: Pierre Ochsenbein , pgsql-admin Content-Type: multipart/alternative; boundary="0000000000001b89b8057f3c151e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --0000000000001b89b8057f3c151e Content-Type: text/plain; charset="UTF-8" There are various PostgreSQL plugins available for collecting the DB stats via Nagios. Like check_postgres, check_pgactivity etc. that you can configure as per your requirements or you can also create your own script for monitoring. Thanks & Regards, *Shreeyansh DBA Team* www.shreeyansh.com On Sat, Jan 12, 2019 at 3:37 AM Prince Pathria wrote: > On what stats should we actually keep a track on? > > On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba wrote: > >> Yes, Nagios is the best DB monitoring/alerting tool and its free >> opensource. >> >> Thanks & Regards, >> *Shreeyansh DBA Team* >> www.shreeyansh.com >> >> >> On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < >> pierreochsenbein@gmail.com> wrote: >> >>> Hey guys, >>> >>> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >>> >>> Thx >>> >> --0000000000001b89b8057f3c151e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
There are various PostgreSQL plugins available for collecting the DB s= tats via Nagios.=C2=A0 Like check_postgres, check_pgactivity etc. that you = can configure as per your requirements or you can also create your own scri= pt for monitoring.

=
Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.c= om


On Sat, Jan 12, 2019 at 3:37 AM Prince Pathria <<= a href=3D"mailto:prince.pathria@goevive.com">prince.pathria@goevive.com= > wrote:
On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shr= eeyansh Dba <shreeyansh2014@gmail.com wrote:
Yes,= Nagios is the best DB monitoring/alerting tool and its free opensource.

=
Thanks & Regards,
Shreeyansh= DBA Team
www.shreeyansh.com
=


On= Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbei= n@gmail.com> wrote:
Hey guys,

What is= for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx
--0000000000001b89b8057f3c151e-- From pierreochsenbein@gmail.com Sat Jan 12 14:57:39 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giKkP-0005Uq-OO for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 14:58:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giKkL-0003tc-Ff for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 14:58:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giKkL-0003of-1i for pgsql-admin@lists.postgresql.org; Sat, 12 Jan 2019 14:58:49 +0000 Received: from mail-io1-xd29.google.com ([2607:f8b0:4864:20::d29]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giKkI-00071L-7D for pgsql-admin@postgresql.org; Sat, 12 Jan 2019 14:58:47 +0000 Received: by mail-io1-xd29.google.com with SMTP id v10so14415072ios.13 for ; Sat, 12 Jan 2019 06:58:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=wLN3lhBis+PaJOfRqnRtZ+FhLsPRGIU1lXPkJjO8eio=; b=EC+kLQQEif/hliRE4LhLdDPi933G6wBrL8wk15ATgCpqxqFwkdZVbXr2k8XqWwWSU8 RH1Xe+RDdgPUxyo+PQxRbwDmb1kayVcJ4Go8LultYk+2qmlCOZB4QkeH2yqdeRoqAkHg SWD3JQxU3TJwYvV684IT0U++OZWnMafUrnhqpUdn5uClAQ4DGC2UOcoW6afpU3C7OohE vZtuYegqobH5d93EcPmyh2YKvnqUn2jUH60be651NX2+v0AYIm5VrL7xLerDYMke1qIv /Tlt3wCYpXvo7Ggs7MRHzD8cHn00fx2HnpelUKNPMK8tXCad7NCAV4TNL/JN0h0EB1fF assQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=wLN3lhBis+PaJOfRqnRtZ+FhLsPRGIU1lXPkJjO8eio=; b=qlxAV72TgPzADbF8B+MHWepRdkmpYa2qNDwNKomyo9ScHPfV07QdaAEffBUP1tSBqO 6K0n1W2/ifyO1g9594+U0hOoJnenSEHZuR7H2sIuVy6XgqJ8iG7nSHH/PLrCD63dz9jc Etg53i1UYJy6vnHRBCVJLnDZfd/XImkxsq6qkfvurMhaxnPalOnq76PSjL4s2KngxkHU wE+lhIeEtuvJONphRnPzc5g55J13v2e1lHYFQFNEDWpIZbOJjuPlTbuHOu39BHWHRw5v FPO8z5F2Yo6N94qFcKdcEeb0z3AnWyiFdtk29WRUpxjc1AgXBKMCfFXXUqXRIGtnegLC LF7g== X-Gm-Message-State: AJcUuke5Drpmh1wILMM0wrk4gnD+CqSG9XVVZAMMXgXsQhsZU22awbQr uKrhm4XzY8XaP/+HhEhrOG4PgPelASplt/mIHlE= X-Google-Smtp-Source: ALg8bN7RqMzNvyyzFRMcR5XBqSFDovehmhNQa4Qc5KxKQgGVGOSbADvUc26c8sAWnP2K2MaTl+bKacTpU6mYPPc2EO8= X-Received: by 2002:a6b:91d4:: with SMTP id t203mr12502763iod.267.1547305125021; Sat, 12 Jan 2019 06:58:45 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Pierre Ochsenbein Date: Sat, 12 Jan 2019 15:57:39 +0100 Message-ID: Subject: Re: Monitoring tool To: Kaido Vaikla Cc: Prince Pathria , Shreeyansh Dba , pgsql-admin Content-Type: multipart/alternative; boundary="000000000000561ed7057f440c7c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000561ed7057f440c7c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thanks a lot for your feedback guys ! I would like a free monitoring tool Le ven. 11 janv. 2019 =C3=A0 23:23, Kaido Vaikla a =C3=A9crit : > And, what is your budget? > Or should it be a freeware? > > br > Kaido > > From: Prince Pathria [mailto:prince.pathria@goevive.com] > Sent: Saturday, January 12, 2019 12:06 AM > To: Shreeyansh Dba > Cc: Pierre Ochsenbein ; pgsql-admin < > pgsql-admin@postgresql.org> > Subject: Re: Monitoring tool > > On what stats should we actually keep a track on? > > On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba wrote: > Yes, Nagios is the best DB monitoring/alerting tool and its free > opensource. > > Thanks & Regards, > Shreeyansh DBA Team > www.shreeyansh.com > > > On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < > pierreochsenbein@gmail.com> wrote: > Hey guys, > > What is for you the best Monitoring/altering for PostgreSQL? Nagios? > > Thx > --=20 Cordialement, *Pierre Ochsenbein* Mobile: +33668295394 pierreochsenbein@gmail.com --000000000000561ed7057f440c7c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thanks a lot for your feedback guys !
<= br>
I would like a free monitoring tool

Le=C2=A0ven. 11 janv. 2019 =C3=A0=C2= =A023:23, Kaido Vaikla <Kaido.V= aikla@telia.ee> a =C3=A9crit=C2=A0:
And, what is your budget?
Or should it be a freeware?

br
Kaido

From: Prince Pathria [mailto:prince.pathria@goevive.com]
Sent: Saturday, January 12, 2019 12:06 AM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql-admin <pgsql-admin@postgr= esql.org>
Subject: Re: Monitoring tool

On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail.com<mailto:= shreeyansh201= 4@gmail.com> wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource= .

Thanks & Regards,
Shreeyansh DBA Team
= www.shreeyansh.com<http://www.shreeyansh.com>


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenbein@gmail.com&l= t;mailto:pi= erreochsenbein@gmail.com>> wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx


--
Cordialement,
Pierre Ochsenbein
Mobile: +336682953= 94
--000000000000561ed7057f440c7c-- From bharattelange@gmail.com Sat Jan 12 16:19:01 2019 Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giM0H-0001WF-Sc for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 16:19:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1giM0E-0004zj-Th for pgsql-admin@arkaria.postgresql.org; Sat, 12 Jan 2019 16:19:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giM0E-0004zc-Al for pgsql-admin@lists.postgresql.org; Sat, 12 Jan 2019 16:19:18 +0000 Received: from mail-pf1-x434.google.com ([2607:f8b0:4864:20::434]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1giM0B-0000I2-AZ for pgsql-admin@postgresql.org; Sat, 12 Jan 2019 16:19:17 +0000 Received: by mail-pf1-x434.google.com with SMTP id z9so8377078pfi.2 for ; Sat, 12 Jan 2019 08:19:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=iHbd/nXnynvUkm6e3sfuO/YMgdi08YeyDqQ3z18XsGg=; b=uMr2z9gud4J2Mno6TPX70pEOzBIXzh2xsE4xGDYn3jJzXA1bC+WpIgi1MJi50i9XK7 uni74qx7a0kq4sJkMY90yvavlSQe4AGbvdQwCWhTMSQAE9y3oVEpTi6GGTMcFrpQi+z6 M7EhjpBfhowPPWVjER5YVrJwSuFQ7WYnFsEv1Zmt0PdAnQbRfcLWJveOmRPsH801931T f88Ygvfew0OTtmhA7t5XWuakguN6QSxlACQQIsuaaQVuIBY8Wtv8ZhPp1jum6a86tS/F eFFAo/9PoRQ3gJCduQYOlCieKW6ce1iHCQ2/WLetwYog9tW24otq1v4SElqergwxGGgs dVxQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=iHbd/nXnynvUkm6e3sfuO/YMgdi08YeyDqQ3z18XsGg=; b=ZCW06btXNNA4gfRNcnyGXqDf6JMqdbriXRvphKY6sZjaxxYFbItkibn2eMJFlAZnso NslOFhCpu1MZ79e67AuiDoCuLpng937sLB69gs5TXdi9eHlV78eDruHqYF+B83JWFkNm GWw8dQMcGbYcKL6JAUau+L18hw+XHe0r789HnBRJdKzHnkwvyp69s8S3nUPO0jk8soVW 7oDru0VpNJ0e2RdMMRpC6eVjY8at4yxx00sf5uatmWkfliv80reW/k1R224SppcNsmKz 0Vv39WQtYEctpnInlpxR558i3QQEBVPJ2SxsZhbMG3GdTddVq7BXRQ+GnxmTYCv7HpME 9meg== X-Gm-Message-State: AJcUukfJbegfhUUAUQ0gcTBUV5xKf25k62fPt8e90J/zYgf1B+z4v8rD j1tf2pvY04Q19J9r1vIaFyPQJ34Cl8sOcwizd7M= X-Google-Smtp-Source: ALg8bN64Y7CUQQm2cyMQr5RB9rX36VRV8I/y5ctaTh6ks8eUhHpTTNxNOW/F7h5OMhT+ruXFHWMS8LaE5T9Zfvgqv+U= X-Received: by 2002:a63:5b1f:: with SMTP id p31mr17068754pgb.56.1547309953903; Sat, 12 Jan 2019 08:19:13 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Bharat Telange Date: Sat, 12 Jan 2019 21:49:01 +0530 Message-ID: Subject: Re: Monitoring tool To: Pierre Ochsenbein Cc: Kaido Vaikla , Prince Pathria , Shreeyansh Dba , pgsql-admin Content-Type: multipart/alternative; boundary="00000000000028f4f1057f452c8d" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --00000000000028f4f1057f452c8d Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable In opensource, nagios and zabbix are already referred in trail mail. Similarly, pgwatch2 is also a good option. https://github.com/cybertec-postgresql/pgwatch2 Regards, Bharat On Sat, 12 Jan, 2019, 8:28 PM Pierre Ochsenbein Thanks a lot for your feedback guys ! > > I would like a free monitoring tool > > Le ven. 11 janv. 2019 =C3=A0 23:23, Kaido Vaikla = a > =C3=A9crit : > >> And, what is your budget? >> Or should it be a freeware? >> >> br >> Kaido >> >> From: Prince Pathria [mailto:prince.pathria@goevive.com] >> Sent: Saturday, January 12, 2019 12:06 AM >> To: Shreeyansh Dba >> Cc: Pierre Ochsenbein ; pgsql-admin < >> pgsql-admin@postgresql.org> >> Subject: Re: Monitoring tool >> >> On what stats should we actually keep a track on? >> >> On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba > wrote: >> Yes, Nagios is the best DB monitoring/alerting tool and its free >> opensource. >> >> Thanks & Regards, >> Shreeyansh DBA Team >> www.shreeyansh.com >> >> >> On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein < >> pierreochsenbein@gmail.com> wrote: >> Hey guys, >> >> What is for you the best Monitoring/altering for PostgreSQL? Nagios? >> >> Thx >> > > > -- > Cordialement, > > *Pierre Ochsenbein* > Mobile: +33668295394 > pierreochsenbein@gmail.com > --00000000000028f4f1057f452c8d Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
In opensource, nagios and zabbix are already referred in trail m= ail. Similarly, pgwatch2 is also a good option.=C2=A0

=

=
Regards,
Bharat

On Sat, 12 Jan, 2019, 8:28 PM Pierre Ochsenbein <pierreochsenbein@gmail.com wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px= #ccc solid;padding-left:1ex">
Thanks a lot for your f= eedback guys !

I would like a free monitoring = tool

Le=C2= =A0ven. 11 janv. 2019 =C3=A0=C2=A023:23, Kaido Vaikla <Kaido.Vaikla@t= elia.ee> a =C3=A9crit=C2=A0:
And, what is your budget?
Or should it be a freeware?

br
Kaido

From: Prince Pathria [mailto:prince.pathria@goevive.com]
Sent: Saturday, January 12, 2019 12:06 AM
To: Shreeyansh Dba <shreeyansh2014@gmail.com>
Cc: Pierre Ochsenbein <pierreochsenbein@gmail.com>; pgsql= -admin <pgsql-admin@postgresql.org>
Subject: Re: Monitoring tool

On what stats should we actually keep a track on?

On Fri, 11 Jan, 2019, 9:36 PM Shreeyansh Dba <shreeyansh2014@gmail= .com<mailto:shreeyansh2014@gmail.com> wrote:
Yes, Nagios is the best DB monitoring/alerting tool and its free opensource= .

Thanks & Regards,
Shreeyansh DBA Team
www.shreeyansh.com<http://www.shreeyansh.com<= /a>>


On Fri, Jan 11, 2019 at 9:26 PM Pierre Ochsenbein <pierreochsenb= ein@gmail.com<mailto:pierreochsenbein@gmail.com>> = wrote:
Hey guys,

What is for you the best Monitoring/altering for PostgreSQL? Nagios?

Thx


--
Cordialement,

Pierre Ochsenbein
Mobile: +33668295394
--00000000000028f4f1057f452c8d--