Re: postgresql question

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-admin(at)postgresql(dot)org>, "Dennis Hoffman" <dennis(dot)hoffman(at)seagate(dot)com>
Subject: Re: postgresql question
Date: 2011-01-21 21:39:21
Message-ID: 4D39A8A902000025000399F5@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dennis Hoffman <dennis(dot)hoffman(at)seagate(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Lister 2011-01-21 21:48:24 Should autovacuum do a database wide vacuum near transaction limit?
Previous Message Dennis Hoffman 2011-01-21 21:19:25 postgresql question