Re: [GENERAL] A question about the permissions

2009-07-28 Thread Tim Uckun
> On lots of systems, giving group permissions is nearly as bad as giving > world permissions (eg, all the users might be in a "users" group). > So we don't do it by default.  If you want to poke holes in the security > of your own installation, go right ahead. I decided to see if I could do it wi

Re: [GENERAL] A question about the permissions

2009-07-27 Thread Tom Lane
Tim Uckun writes: > What is the rationale for not giving the group any permissions at all? On lots of systems, giving group permissions is nearly as bad as giving world permissions (eg, all the users might be in a "users" group). So we don't do it by default. If you want to poke holes in the sec

[GENERAL] A question about the permissions

2009-07-27 Thread Tim Uckun
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 c