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.
Matheus de Oliveira
Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho -
Instituto de Ciências Matemáticas e de Computação -
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
> 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?
> 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
pgsql-admin by date
|Next:||From: MirrorX||Date: 2012-04-04 11:51:49|
|Subject: alter index's tablespace (from default) after pg_upgrade --link|
|Previous:||From: Bèrto ëd Sèra||Date: 2012-04-04 09:53:40|
|Subject: check_postgresql.pl for zabbix|