Skip site navigation (1) Skip section navigation (2)

Re: check_postgresql.pl for zabbix

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: check_postgresql.pl for zabbix
Date: 2012-04-04 11:24:40
Message-ID: CAJghg4+24v+-Kz4C_Y5KwyNWswLry7-fTpTigMNkhPdMMwoKbA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Give read permissions to the group on the data directory and archives:

chmod g+r -R /var/lib/pgsql/data

I think just that will solve the problem, as you said that the agent is
already been executed with postgres group.

Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
LCAD<http://www.lcad.icmc.usp.br/>
Instituto de Ciências Matemáticas e de Computação -
ICMC<http://www.icmc.usp.br/>
Universidade de São Paulo - USP <http://www.sc.usp.br/>




On Wed, Apr 4, 2012 at 6:53 AM, Bèrto ëd Sèra <berto(dot)d(dot)sera(at)gmail(dot)com>wrote:

> 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.
> See http://bucardo.org/check_postgres/check_postgres.pl.html#checkpoint
>
> 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.
>

In response to

Responses

pgsql-admin by date

Next:From: MirrorXDate: 2012-04-04 11:51:49
Subject: alter index's tablespace (from default) after pg_upgrade --link
Previous:From: Bèrto ëd SèraDate: 2012-04-04 09:53:40
Subject: check_postgresql.pl for zabbix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group