Thread
-
`postgresql.conf' has wrong permissions???
rocael@usa.net — 2001-08-03T13:08:13Z
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.
-
Re: `postgresql.conf' has wrong permissions???
Tom Lane <tgl@sss.pgh.pa.us> — 2001-08-03T21:07:52Z
<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
-
Re: `postgresql.conf' has wrong permissions???
fimbulvetr <fimbulvetr@lycos.com> — 2001-08-15T16:25:18Z
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