Postgres cannot access the server configuration file


#1

Hi Linuxcareer,

I’m trying to setup my postreSQL server. After installation I’m unable to start my server and the following error message appears:

postgres cannot access the server configuration file "/opt/PostgreSQL/9.2/data/:/opt/PostgreSQL/9.2/data/postgresql.conf": No such file or directory

Moreover, I can see in my logs following error messages relater to PostgreSQL:

FATAL:  data directory "/opt/PostgreSQL/9.2/data" has group or world access
 Permissions should be u=rwx (0700). 

Can anyone provide more information on how to fix this problem?

thank you


#2

su - postgresql
initdb -D /var/lib/postgres/data/

Hi Linuxcareer,

I’m trying to setup my postreSQL server. After installation I’m unable to start my server and the following error message appears:

postgres cannot access the server configuration file "/opt/PostgreSQL/9.2/data/:/opt/PostgreSQL/9.2/data/postgresql.conf": No such file or directory

Moreover, I can see in my logs following error messages relater to PostgreSQL:

FATAL:  data directory "/opt/PostgreSQL/9.2/data" has group or world access
 Permissions should be u=rwx (0700). 

Can anyone provide more information on how to fix this problem?

thank you


#3

Hi,

this is what I’ve got:

# su - postgres
$ initdb -D /var/lib/postgres/data/
-su: initdb: command not found

it seems that the command is missing…

thanks


#4

Dear topol,

can you please provide some information like which distro you are using for postgres db? Also please provide hardware arch.

It can help us to narrow down the issue you are getting.

Thanks,
bnhashmi


#5

Hi,

To fix your problem make sure that your directories have correct permissions. Do:

chown -R postgres /opt/PostgreSQL/9.2/data
chmod -R 0700 /opt/PostgreSQL/9.2/data 

hope this helps

Lubos


#6

Hi,

To find where “initdb” command is, execute:

# find / -iname initdb

#7

#8