postgresql can't restart

[ben]

Hi, does any one know about this postgresql thing.
I don't use postgresql on my site. i use mysql but at 2:34 this morning it shutdown and has been having problems coming back up. Can someone please help me? Has someone tried to hack me. why would a service that i don't use just stop working. How do i turn it off? Do i need it for other reasons.

[awsolutions]

postgree is only needed if you have postgree databases. If not it doesn't really need to be running. However, the fact it turned off is odd and should be thoroughly looked into.

If you are familiar with shell check the logs, issue a restart see if you can get any further details.

If you are not contact me at advwebsolutions on aim.

[Lynix]

Yes the postgresql started after an upgrade from cpanel perhaps earlier today.. it keeps failing and does not restart due to no postmaster running.. Question is how do we get it to stop, apparently we dont need it or use it, even if you disable it from cpanel by unchecking etc it does not work it remains checked and it keeps on trying to restart.. so if anyone knows exactly what needs to be done so get this issue fixed post a reply. Thanks.

[dialdn]

Weird I have had the exact same problems this AM.

Any word on this would be great!

D

[Infopro]

http://forums.cpanel.net/showthread.php?t=28425

that should help you. it helped me, although I did not follow instructions completely and wiped out mysql.sock from /tmp
(and some other crap) :flush:


Good luck.

[Lynix]

Thanks Infopro, it worked with me. For everyone else incase they were not able to login to cpanel forums simply follow the below steps:

If postgresql on Cpanel refuses to start even after reinstalling it from /scripts, try the following steps :

1. Delete the postgre files in /tmp.
2. rm -rf /var/lib/pgsql/data
3. su - postgres
4. initdb
5. start postgre from ssh
6. Go back and try the WHM functions again.

After doing #4 the msg. ends with:

Success. You can now start the database server using:

/usr/bin/postmaster -D /var/lib/pgsql/data
or
/usr/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

Chose the first option or start Postgres from WHM.