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

On Fri, Aug 23, 2013 at 12:27 PM, Birchall, Austen
<austen.birchall@metoffice.gov.uk> wrote:
> should that be
>
>
>
> chmod 750 data.
>

No. From te documentation:
http://www.postgresql.org/docs/current/interactive/creating-cluster.html

Because the data directory contains all the data stored in the
database, it is essential that it be secured from unauthorized access.
initdb therefore revokes access permissions from everyone but the
PostgreSQL user.



> However even after doing this wouldn’t the 700 permissions on the plsql
> directory on leaf above still prevent access?
>

Of course. But you don't need to have access to the pgdata directory,
or at least you can split things so that if you need access to same
part (e.g., configuration files or logs) you can have right to it.