check_postgresql.pl for zabbix

Поиск
Список
Период
Сортировка
От Bèrto ëd Sèra
Тема check_postgresql.pl for zabbix
Дата
Msg-id CAKwGa_9DpJjW3ZPicdv9-HCVqxtHKqgtpfTtjWTwdouhMt_x7Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: check_postgresql.pl for zabbix
Список pgsql-admin
Hi all,

I'm implementing a PG monitoring system on zabbix, using http://bucardo.org/wiki/Check_postgres 

Everything's fine, however I cannot seem to use action=checkpoint without some intervention on permissions. 

The data directory is 
drwx------+ 11 postgres postgres 4096 Apr  2 13:37 /var/lib/pgsql/data

so putting zabbix in the postgres group won't have any effect, and there is not enough information for us to be sure that we can add read permission to the group without impact, once the template I'm making is ported to a large number of boxes, some of which may have local policies we are not aware of.

I'm left with the option of giving the zabbix agent daemon a limited sudo right, which I quite do not like because it will need to be replicated on all single boxes... is anyone aware of an alternative solution?

Cheerio
Bèrto

--
==============================
If Pac-Man had affected us as kids, we'd all be running around in a darkened room munching pills and listening to repetitive music.

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

Предыдущее
От: superman0920
Дата:
Сообщение: about multiprocessingmassdata
Следующее
От: Matheus de Oliveira
Дата:
Сообщение: Re: check_postgresql.pl for zabbix