Re: postgresql question - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: postgresql question
Date
Msg-id 4D39A8A902000025000399F5@gw.wicourts.gov
Whole thread Raw
In response to postgresql question  (Dennis Hoffman <dennis.hoffman@seagate.com>)
Responses Re: postgresql question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Dennis Hoffman <dennis.hoffman@seagate.com> wrote:

> If I do nothing other than remove the file permissions ( change
> back to 700 from 750 ), the Postmaster starts just as it should.
> Why does the Postmaster not start with the group permissions
> changed?

That's intentional, as a security measure.

> Is this a bug?

It is considered a feature.

> What can I do?

I'd be tempted to write a script which was owned by root which
calculated the size as desired, and grant sudo rights to merlin to
execute that particular script as the user with rights.

-Kevin

pgsql-admin by date:

Previous
From: Dennis Hoffman
Date:
Subject: postgresql question
Next
From: Tom Lane
Date:
Subject: Re: postgresql question