Thread: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

From
Joseph S
Date:
I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
printed on STDERR

FATAL:  data directory "path-to-my-data-dir" has group or world access
DETAIL:  Permissions should be u=rwx (0700).

This change was not documented in the release notes, and I don't think
permission != 700 should be a fatal error.  I purposely set o+x to let
any user be able to read the log files.

Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

From
Magnus Hagander
Date:
On Mon, Mar 15, 2010 at 21:08, Joseph S <jks@selectacast.net> wrote:
> I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
> printed on STDERR
>
> FATAL:  data directory "path-to-my-data-dir" has group or world access
> DETAIL:  Permissions should be u=rwx (0700).
>
> This change was not documented in the release notes, and I don't think
> permission != 700 should be a fatal error.  I purposely set o+x to let any
> user be able to read the log files.

There has been no change there. From what I can tell, that part of the
 code hasn't been touched since 2004. That shouldn've have worked in
8.4.2 either - but it's only checked on server startup, so if you
changed the mode after startup you wouldn't have noticed.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

From
Richard Huxton
Date:
On 15/03/10 20:08, Joseph S wrote:
>
> This change was not documented in the release notes, and I don't think
> permission != 700 should be a fatal error. I purposely set o+x to let
> any user be able to read the log files.

What Magnus said but also - put your log files somewhere else. That way
you can have a more permissive system for them.

--
   Richard Huxton
   Archonet Ltd

Magnus Hagander wrote:

> There has been no change there. From what I can tell, that part of the
>  code hasn't been touched since 2004. That shouldn've have worked in
> 8.4.2 either - but it's only checked on server startup, so if you
> changed the mode after startup you wouldn't have noticed.
>
Hmm.  I don't remember changing the permissions but I suppose it could
have been after the last time I restarted the postmaster (months ago).
Thank you.
>


Magnus Hagander <magnus@hagander.net> writes:
> On Mon, Mar 15, 2010 at 21:08, Joseph S <jks@selectacast.net> wrote:
>> I upgraded from 8.4.2 to 8.4.3, and I couldn't start postgres. This was
>> printed on STDERR
>>
>> FATAL: �data directory "path-to-my-data-dir" has group or world access
>> DETAIL: �Permissions should be u=rwx (0700).
>>
>> This change was not documented in the release notes, and I don't think
>> permission != 700 should be a fatal error. �I purposely set o+x to let any
>> user be able to read the log files.

> There has been no change there. From what I can tell, that part of the
> code hasn't been touched since 2004.

The restriction was introduced in 7.2 ...

            regards, tom lane