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

Re: 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: for zabbix
Date: 2012-04-04 11:24:40
Message-ID: (view raw or whole 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.

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 <>

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
> 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


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: for zabbix

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