postgresql failed @ Sun Aug 22. A restart was attempted automagicly.

nybble

Well-Known Member
Jan 26, 2004
222
0
166
Err, I haven't touched this box and yet it failed? Any ideas? cPanel update **** something up?

<edit>Failed 80 times~ and counting</edit>
 
Last edited:

BenThomas

Well-Known Member
Feb 12, 2004
598
0
166
Houston, Texas USA
cPanel Access Level
Root Administrator
Have you investigated the problem any further?

It looks like its failing because it's not even starting. So every time chkservd runs, it will send you a message that it has failed. Try starting postgresql manually and see why its failing.

What is the content of /etc/chkserv.d/postgresql?

Do you have postgresql configured to listen on TCP sockets?
 

nybble

Well-Known Member
Jan 26, 2004
222
0
166
/scripts/restartsrv postgresql
Waiting for postgresql to restart..............finished.


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


Better yet, is there a way to turn off postgresql? (So users cant use it and it's not running)
 
Last edited:

BenThomas

Well-Known Member
Feb 12, 2004
598
0
166
Houston, Texas USA
cPanel Access Level
Root Administrator
Sure, just touch /etc/disablepostgresql, then uninstall it. Then rename the postgresql directory (usually /var/lib/pgsql). Let me know if that doesn't remove all remnants of it in the WHM/cPanel.
 

nybble

Well-Known Member
Jan 26, 2004
222
0
166
I just asked one of my admins to fix it and they did.... err, nice of them not to tell me what's wrong :)
 

nybble

Well-Known Member
Jan 26, 2004
222
0
166
Nah, it only had to be started up :) it managed to fail after the cpanle update (figures)

Maybe you guys should make something like SIM.
 

nybble

Well-Known Member
Jan 26, 2004
222
0
166
The cpanel update stops postgres, you need to start it again.


type "service postgres start" in the command prompt.
 

DrChaos

Active Member
Dec 23, 2001
33
0
306
nybble said:
The cpanel update stops postgres, you need to start it again.


type "service postgres start" in the command prompt.

We are having the same issue after updates and tried that and the result is "postgres: unrecognized service"
 

nybble

Well-Known Member
Jan 26, 2004
222
0
166
try "postgresql" or "postgres" and even try adding a d to the end.

eg.

postgresd =\
 

Lyttek

Well-Known Member
Jan 2, 2004
772
4
168
Same problem, also after cpupdate.

trying to start the service manually (service postgresql start) returns:


Initializing database: su: user postgres does not exist
[FAILED]
Starting postgresql service: su: user postgres does not exist
[FAILED]


I can remember setting a password for postgre when first configuring this box, but I don't believe I (or anyone else) actually using it...
 

Lyttek

Well-Known Member
Jan 2, 2004
772
4
168
Ok, more checking showed that some of the packages weren't showing up as being installed... reinstalled postgresql and all is well.

I used the instructions from this thread