When I try to start my postgresql server on CentOS I get a message to say that it has failed to start it. I have made sure to initialise the db using "service postgresql initdb". Does anyone have any suggestions to fix this?
closed as unclear what you're asking by dr01, GAD3R, Archemar, Dmitry Grigoryev, Anthony Geoghegan Apr 24 '17 at 20:28
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
As per discussion in the comments you have problem with creating temporary file in
< 2017-04-24 05:05:13.196 CDT > FATAL: could not create lock file "/tmp/.s.PGSQL.5432.lock"
and the permission of
/tmp directory is wrong
When using "ls -ld /tmp" it stated the permission as drwxrwxr-t
so the solution is to change the permission of
/tmp to make it writable for the World
chmod 1777 /tmp