From: | PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com> |
---|---|
To: | Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk> |
Cc: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: monitoring PostgreSQL |
Date: | 2017-07-24 13:47:21 |
Message-ID: | CAPgXFMQFgJ6C_=E0=U5VK4DDutngw+7jKkpwj=MO7tPAD5nPWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Jul 24, 2017 at 5:50 PM, PAWAN SHARMA <er(dot)pawanshr0963(at)gmail(dot)com>
wrote:
>
> On Mon, Jul 24, 2017 at 5:20 PM, Tim Clarke <tim(dot)clarke(at)manifest(dot)co(dot)uk>
> wrote:
>
>> We use nagios for all alerting, it'll do what you need.
>>
>> Tim Clarke
>>
>>
>> On 24/07/17 12:38, Achilleas Mantzios wrote:
>> > pgbadger is a very nice reporting tool, overall, albeit not exactly at
>> > the system side, but more to the DBA side.
>> > For system level monitoring maybe take a look here :
>> > https://wiki.postgresql.org/wiki/Monitoring#check_postgres .
>> > Also you might want to write a script that parses logs for FATAL and
>> > PANIC and sends out emails.
>> >
>> > On 24/07/2017 14:27, PAWAN SHARMA wrote:
>> >> Hi All,
>> >>
>> >>
>> >> Please provide me a list of tools which we can use for monitoring
>> >> PostgreSQL.
>> >>
>> >> -Monitor all the services and health of server
>> >> -Able to send critical and warning alert on mail.
>> >>
>> >> OS: Redhat-7
>> >> PostgreSQL Version: 9.5.7
>> >>
>> >>
>> >> -Pawan
>> >
>> >
>> > --
>> > Achilleas Mantzios
>> > IT DEV Lead
>> > IT DEPT
>> > Dynacom Tankers Mgmt
>>
>>
>>
> Hi Tim,
>
> Thanks for update,
>
> Please share the steps, how to configure Nagios??
>
Hi Tim,
Facing below issue
[abc(at)test:/home/psharm89/nrpe-2.15]#
Redirecting to /bin/systemctl restart xinetd.service
Failed to restart xinetd.service: Unit xinetd.service failed to load: No
such file or directory.
[abc(at)test:/home/psharm89/nrpe-2.15]#
[abc(at)test:/home/psharm89/nrpe-2.15]#
#-> less /etc/xinetd.d/nrpe
# default: on
# description: NRPE (Nagios Remote Plugin Executor)
service nrpe
{
flags = REUSE
socket_type = stream
port = 5666
wait = no
user = nagios
group = nagios
server = /usr/local/nagios/bin/nrpe
server_args = -c /usr/local/nagios/etc/nrpe.cfg --inetd
log_on_failure += USERID
disable = no
only_from = 127.0.0.1
}
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Clarke | 2017-07-24 13:58:22 | Re: monitoring PostgreSQL |
Previous Message | Tim Uckun | 2017-07-24 13:15:56 | Re: Dealing with ordered hierarchies |