postgresql failed

I did a reboot of WHD this afternoon and the reboot failed. This is on a virtual appliance. The initial screen is asking me to create new databases. I logged onto the console and when I attempt to start WHD I get "Starting postgresql-9.2 service: [FAILED]". I have plenty of drive space. Any ideas?

Output of startup:

Web Help Desk
Copyright (c) SolarWinds Worldwide, LLC

Web Help Desk
Copyright (c) SolarWinds Worldwide, LLC

Using XX:MaxPermSize=256

Using additional JVM options: -XX:+DisableAttachMechanism -Dsun.rmi.transport.tcp.maxConnectionThreads=0
Checking if port 80 is available
Port 80 is already in use by ::ffff: ::ffff:
Checking if port 443 is available
Port 443 is already in use by ::ffff:
Starting postgresql-9.2 service:                           [FAILED]
Starting the Web Help Desk on port 80...

Starting an SSL connection to the Web Help Desk on port 443...
(See README.txt for information regarding SSL connections.)

Using CATALINA_BASE:   /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_HOME:   /usr/local/webhelpdesk/bin/tomcat
Using CATALINA_TMPDIR: /usr/local/webhelpdesk/bin/tomcat/temp
Using JRE_HOME:        /usr/local/webhelpdesk/bin/jre
Using CLASSPATH:       /usr/local/webhelpdesk/bin/tomcat/bin/bootstrap.jar:/usr/local/webhelpdesk/bin/tomcat/bin/tomcat-juli.jar
Using CATALINA_PID:    /usr/local/webhelpdesk/log/
Tomcat started.
  • when I attempted to start it manually, I got :

    "usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data is missing. Use "service postgresql-9.2 initdb" to initialize the cluster first."

    The data directory is not missing. it seems to be a symlink to /data1/data which is there but admin did not have permissions. it was owned by postgres user. when I went in as root, there was stuff in there but I wasn't sure what to look for. 

    I'm just trying to not lose my data.

  • Hi ,

    I ran into this symptom, too. (WebHelpDesk, CentOS 7)

    When starting webhelpdesk, postgresql-9.2 fails to start, so webhelpdesk cannot be accessed:

    Starting postgresql-9.2 service:                           [FAILED]

    Verify that the following directory exists, has contents, and the contents are owned by the postgres user:

    ls -la /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data

    View the contents of the embedded postgres startup log:

    tail -20 /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/pgstartup.log

    You should see startup messages that end in "ok." Instead, I saw this message:

    LOG:  could not bind IPv4 socket: Address already in use
    HINT:  Is another postmaster already running on port 20293? If not, wait a few seconds and retry.

    Check to see if an instance of webhelpdesk's embedded postgres is already running:

    ps aux | grep postgres

    It was. Identify the PID, and kill the outstanding process:

    kill -9 <PID>

    Restart webhelpdesk:

    service webhelpdesk start

    Starting postgresql-9.2 service:                           [  OK  ]

    WebHelpDesk now starts, and the web component can be accessed.

    Two years later - hope your instance got resolved!