pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
`postgresql.conf' has wrong permissions???
3+ messages / 3 participants
[nested] [flat]

* `postgresql.conf' has wrong permissions???
@ 2001-08-03 13:08  rocael@usa.net
  0 siblings, 1 reply; 3+ messages in thread

From: rocael@usa.net @ 2001-08-03 13:08 UTC (permalink / raw)
  To: pgsql-sql

Hi,
I have a trouble when I try to start my postgres server (pg7.1 installed from
source), it has been running postgres ok, then my linux redhat 7.1 box was
rebooted (without stoping postgres), now I tried to run again the postgres
server and I got this message:
FATAL 1:  configuration file `postgresql.conf' has wrong permissions

I tried to run it as usual with this commands:
as root
su -l postgres -c '/usr/local/pgsql/bin/postmaster -B 1000 -o "-S 2000" -S -D
/usr/local/pgsql/data'

as postgres
[postgres@localhost pgsql]$ bin/postmaster -D data/

in both cases I got the same error message, this is the first time I have this
trouble, I have stopped and restarted that DB server a lot of times.

my directories permissions says:
ls -la /usr/local/
drwxr-x--x    9 postgres web          4096 Jul 30 18:07 pgsql

ls -la /usr/local/pgsql
drwxrwxrwx    2 postgres web          4096 Jun 29 23:15 bin
drwxrwxrwx    5 postgres web          4096 Aug  3 09:19 data
drwxrwxrwx    3 postgres web          4096 Jun 29 23:15 doc
-rwxrwxrwx    1 postgres web           747 Jun 29 17:22 .emacs
drwxrwxrwx    4 postgres web          4096 Jun 29 23:15 include
drwxrwxrwx    2 postgres web          4096 Jul  2 10:09 lib
drwxrwxrwx    4 postgres web          4096 Jun 29 23:15 man
-rwxrwxrwx    1 postgres web            46 Jul 30 20:29 .psql_history
-rwxrwxrwx    1 postgres web          3728 Jun 29 17:22 .screenrc
drwxrwxrwx    2 postgres web          4096 Jun 29 23:15 share


ls -la /usr/local/pgsql/data/
drwxrwxrwx    5 postgres web          4096 Aug  3 09:19 .
drwxr-x--x    9 postgres web          4096 Jul 30 18:07 ..
drwxrwxrwx   10 postgres web          4096 Jul 26 12:46 base
drwxrwxrwx    2 postgres web          4096 Jul  2 10:52 global
-rwxrwxrwx    1 postgres web          7399 Jun 29 23:15 pg_hba.conf
-rwxrwxrwx    1 postgres web          1118 Jun 29 23:15 pg_ident.conf
-rwxrwxrwx    1 postgres web             4 Jun 29 23:15 PG_VERSION
drwxrwxrwx    2 postgres web          4096 Aug  2 23:09 pg_xlog
-rwxrwxrwx    1 postgres web          3137 Jun 29 23:15 postgresql.conf
-rwxrwxrwx    1 postgres web            93 Jul 30 22:31 postmaster.opts


I just did chmod 777 -R /usr/local/pgsql
Is not working...

One thing to note is that before I rebooted linux I did this:
chmod 755 -R /usr/local/pgsql
I did this when postgresql was alredy running, and the reason is because I
needed that for a driver works well.

Please help me, I don't know what to do now!

Thank you,
Greetings,
Rocael.





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: `postgresql.conf' has wrong permissions???
@ 2001-08-03 21:07  Tom Lane <tgl@sss.pgh.pa.us>
  parent: rocael@usa.net
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2001-08-03 21:07 UTC (permalink / raw)
  To: rocael@usa.net; +Cc: pgsql-sql

<rocael@usa.net> writes:
> FATAL 1:  configuration file `postgresql.conf' has wrong permissions

> One thing to note is that before I rebooted linux I did this:
> chmod 755 -R /usr/local/pgsql

That was a bad idea.  700 is the most permission you should have on the 
/usr/local/pgsql/data directory.  I am not sure why the code is so picky
about postgresql.conf and not about the data directory as a whole ---
but it will refuse to start up if postgresql.conf has more than 744
permissions.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: `postgresql.conf' has wrong permissions???
@ 2001-08-15 16:25  fimbulvetr <fimbulvetr@lycos.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: fimbulvetr@lycos.com @ 2001-08-15 16:25 UTC (permalink / raw)
  To: pgsql-sql

tgl@sss.pgh.pa.us (Tom Lane) wrote in message news:<25631.996872872@sss.pgh.pa.us>...
> <rocael@usa.net> writes:
> > FATAL 1:  configuration file `postgresql.conf' has wrong permissions
>  
> > One thing to note is that before I rebooted linux I did this:
> > chmod 755 -R /usr/local/pgsql
> 
> That was a bad idea.  700 is the most permission you should have on the 
> /usr/local/pgsql/data directory.  I am not sure why the code is so picky
> about postgresql.conf and not about the data directory as a whole ---
> but it will refuse to start up if postgresql.conf has more than 744
> permissions.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

I experienced this problem as well, I changed permissions on
/usr/local in order to get our samba share to work, and the next day
the database would not start.
744 will allow the postmaster to start again.
Dan



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-08-15 16:25 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-03 13:08 `postgresql.conf' has wrong permissions??? rocael@usa.net
2001-08-03 21:07 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-08-15 16:25   ` fimbulvetr <fimbulvetr@lycos.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox