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.