Postgres Pro
Downloads
Home   >   mailing lists

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

From Birchall, Austen
Subject Re: Linux group access to ..../psql/data & subdirectories
Date
Msg-id 4E154FB60786D74BB4DFDC97BF991CAC0900B4@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk
Whole thread Raw
In response to Re: Linux group access to ..../psql/data & subdirectories  (raghu ram <raghuchennuru@gmail.com>)
Responses Re: Linux group access to ..../psql/data & subdirectories
List pgsql-novice
Tree view

Hi Raghu

 

chmod 700 data

 

should that be

 

chmod 750 data.

 

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

 

Austen

 

p.s. Unfortunately I don’t have a sandpit at the moment so I can’t easily try this out otherwise I would have done so before replying

 

 

 

 

From: raghu ram [mailto:raghuchennuru@gmail.com]
Sent: 23 August 2013 11:12
To: Birchall, Austen
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Linux group access to ..../psql/data & subdirectories

 

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: raghu ram
Date:
Subject: Re: Linux group access to ..../psql/data & subdirectories
Next
From: David Johnston
Date:
Subject: Re: Linux group access to ..../psql/data & subdirectories