Postgres cannot access the server configuration file

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

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

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

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

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

Hi,

To find where “initdb” command is, execute:

# find / -iname initdb