Postgres Pro
Downloads
Home   >   mailing lists

Re: Linux group access to ..../psql/data & subdirectories - Mailing list pgsql-novice

From raghu ram
Subject Re: Linux group access to ..../psql/data & subdirectories
Date
Msg-id CALnrrJTFun7-1JLkwMJBsvP+EOCpfKZifrs42CkV-RAO=2sDnw@mail.gmail.com
Whole thread Raw
In response to Linux group access to ..../psql/data & subdirectories  ("Birchall, Austen" <austen.birchall@metoffice.gov.uk>)
Responses Re: Linux group access to ..../psql/data & subdirectories
List pgsql-novice
Tree view

On Fri, Aug 23, 2013 at 3:34 PM, Birchall, Austen <austen.birchall@metoffice.gov.uk> 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).

 


Provide 700 permissions to Data Directory.

cd ..../pgsql

chmod 700 data

and then start the cluster using pg_ctl utility.


Thanks & Regards
Raghu Ram
skypeid: raghu.ramedb   

pgsql-novice by date:

Previous
From: "Birchall, Austen"
Date:
Subject: Linux group access to ..../psql/data & subdirectories
Next
From: "Birchall, Austen"
Date:
Subject: Re: Linux group access to ..../psql/data & subdirectories