Cannot restart Postgresql!

NobeleeNa

Active Member
Hello,

I was intalling Postgresql in my server and after that I try to restart it to see if it's working or not and bellow is the result i found.

Attempting to restart postgresql
Waiting for postgresql to restart.... . . . . . . . . . . finished.

postgresql status


postgresql has failed, please contact the sysadmin (result was "postmaster is not running").

Can anyone help please?


Regards,

Bryan
 

WMS

Active Member
Jul 18, 2003
40
0
156
Moscow
/tmp

Check the permissions of your /tmp.
They HAVE to be 777.
If they are not, do the follwoing:

chmod 777 /tmp
chmod +t /tmp

To Cpanel Support:
WHY DO YOU CHANGE THE PERMISSIONS OF /tmp WHEN REBUILDING APACHE???????
 

casey

Well-Known Member
Jan 17, 2003
2,288
0
191
Is this on RHE or Fedora? If so, run the install script again and then initialize it manually:

initdb -D /var/lib/pgsql/data


Also be sure to configure postgres from WHM after initializing it.
 

sawbuck

Well-Known Member
Jan 18, 2004
1,365
10
168
cPanel Access Level
Root Administrator
WMS said:
Check the permissions of your /tmp.
They HAVE to be 777.
If they are not, do the follwoing:

chmod 777 /tmp
chmod +t /tmp

To Cpanel Support:
WHY DO YOU CHANGE THE PERMISSIONS OF /tmp WHEN REBUILDING APACHE???????
Would be happy to be corrected but would have to say that setting /tmp to 777 may create security problems. Better to go with 1777 to turn on the sticky bit.