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

Started by Joseph Shraibmanabout 16 years ago5 messagesgeneral
Jump to latest
#1Joseph Shraibman
jks@selectacast.net

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.

#2Magnus Hagander
magnus@hagander.net
In reply to: Joseph Shraibman (#1)
Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

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/

#3Richard Huxton
dev@archonet.com
In reply to: Joseph Shraibman (#1)
Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

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

#4Joseph Shraibman
jks@selectacast.net
In reply to: Magnus Hagander (#2)
Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

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.

Show quoted text
#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Magnus Hagander (#2)
Re: Pg 8.4.3 does not start up with "Permissions should be u=rwx (0700)

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