I am trying to monitor replication lag using zabbix. I have written a simple script in ruby to get the lag it goes like this. require 'date' require 'yaml' y = YAML.load `/usr/lib/postgresql/8.3/bin/pg_controldata /var/lib/postgresql/8.3/main` last_checkpoint = DateTime.parse( y['Time of latest checkpoint']) hours, mins, secs, fractions = Date::day_fraction_to_time(DateTime.now - last_checkpoint) puts hours * 60 * 60 + mins * 60 + secs When I try to run this script as the zabbix user (or any user other than postgres or root) I get the error pg_controldata: could not open file "/var/lib/postgresql/8.3/main/global/pg_control" for reading: Permission denied This is because everything under the 8.3 directory is readable by the postgres user only (not group permissions). Is there any harm to giving the postgres group the same rights as the postgres group and adding the zabbix user to the postgres group? What is the rationale for not giving the group any permissions at all? Thanks. BTW I think it's really cool that the output of pg_controldata is a YAML parseable format. I am pretty sure that's by accident but don't change it :) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
