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

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(at)gmail(dot)com]
Sent: 23 August 2013 11:12
To: Birchall, Austen
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Linux group access to ..../psql/data & subdirectories

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