Re: [GENERAL] monitoring PostgreSQL

Поиск
Список
Период
Сортировка
От PAWAN SHARMA
Тема Re: [GENERAL] monitoring PostgreSQL
Дата
Msg-id CAPgXFMQFgJ6C_=E0=U5VK4DDutngw+7jKkpwj=MO7tPAD5nPWw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] monitoring PostgreSQL  (PAWAN SHARMA <er.pawanshr0963@gmail.com>)
Ответы Re: [GENERAL] monitoring PostgreSQL
Список pgsql-general


On Mon, Jul 24, 2017 at 5:50 PM, PAWAN SHARMA <er.pawanshr0963@gmail.com> wrote:

On Mon, Jul 24, 2017 at 5:20 PM, Tim Clarke <tim.clarke@manifest.co.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@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@test:/home/psharm89/nrpe-2.15]# 

[abc@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 
}



В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Uckun
Дата:
Сообщение: Re: [GENERAL] Dealing with ordered hierarchies
Следующее
От: Tim Clarke
Дата:
Сообщение: Re: [GENERAL] monitoring PostgreSQL