topol
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
dcook56
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
topol
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
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
Lubos
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
jaig
6
Hi,
To find where “initdb” command is, execute:
# find / -iname initdb