Re: Linux group access to ..../psql/data & subdirectories

From: David Johnston <polobo(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Linux group access to ..../psql/data & subdirectories
Date: 2013-08-23 14:24:24
Message-ID: 1377267864538-5768387.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Birchall, Austen wrote
> 9.2 on Red Hat 6
>
> I would like users other than postgres to be able to 'see' the postgres
> owned files and directories that are under ....../psql/data
>
> However definitely a Linux group and giving group access:
>
> 750 to them gives me
>
>
> FATAL: data directory "........../pgsql/data" has group or world access
>
> DETAIL: Permissions should be u=rwx (0700).
>
>
> Is there any way around this?
>
> Austen
>
>
> Austen Birchall Senior Database Administrator
> Met Office

I would advise you to comment on WHY you feel that such is necessary.

I cannot speak to whether sub-directories can be made less-secure and still
allow the server to start but in short the "/pgsql/data" directory has
intentionally been setup so that it can only be accessed by root or postgres
while the server is running.

From my limited knowledge, if you disagree and want to change that policy
you will need to compile from source after locating and changing the
relevant code.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Linux-group-access-to-psql-data-subdirectories-tp5768373p5768387.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Luca Ferrari 2013-08-23 14:40:22 Re: Linux group access to ..../psql/data & subdirectories
Previous Message Birchall, Austen 2013-08-23 10:27:17 Re: Linux group access to ..../psql/data & subdirectories