Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

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 12.6.0.738Copyright (c) SolarWinds Worldwide, LLCWeb Help Desk 12.6.0.738Copyright (c) SolarWinds Worldwide, LLCUsing XX:MaxPermSize=256Using additional JVM options: -XX:+DisableAttachMechanism -Dsun.rmi.transport.tcp.maxConnectionThreads=0Checking if port 80 is availablePort 80 is already in use by ::ffff:172.19.138.163:55007 ::ffff:127.0.0.1:47404.Checking if port 443 is availablePort 443 is already in use by ::ffff:127.0.0.1:49392.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/tomcatUsing CATALINA_HOME:   /usr/local/webhelpdesk/bin/tomcatUsing CATALINA_TMPDIR: /usr/local/webhelpdesk/bin/tomcat/tempUsing JRE_HOME:        /usr/local/webhelpdesk/bin/jreUsing CLASSPATH:       /usr/local/webhelpdesk/bin/tomcat/bin/bootstrap.jar:/usr/local/webhelpdesk/bin/tomcat/bin/tomcat-juli.jarUsing CATALINA_PID:    /usr/local/webhelpdesk/log/.whd.pidTomcat started.

Find more posts tagged with

Accepted answers

All comments

chipwoods

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.

libit

Hi @chipwoods,

I ran into this symptom, too. (WebHelpDesk 12.7.2.39, 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. </code></p><p>Two years later - hope your instance got resolved! <code>

wfire

Helloi have a similar problemI am in the 1st centos + whd installation1) after installatio there is no connection to create the embedded database (connection refused)2) after restart here is the error

ble.
Checking if port 8443 is available
Port 8443 is available.

/usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data is missing. Use "service postgresql-9.2 initdb" to initialize the cluster first.
 [ÉCHOUÉ]
Starting the Web Help Desk on port 8081...

Starting an SSL connection to the Web Help Desk on port 8443...
(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

3) I think there is a permission problem for the database

[web@Host-002 ~]$ sudo ls -la /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data
total 4
drwx------. 3 postgres postgres 39 8 nov. 20:02 .
drwxr-xr-x. 3 root root 39 8 nov. 20:02 ..
-rw-r--r--. 1 root root 130 8 nov. 20:02 pg_hba.conf
drwx------. 2 postgres postgres 6 8 nov. 20:02 pg_log

4) when i want to do initdb i have an error> progstl is not in the same folder when yes. I have no idea what to do thank you

vivek101

Hi Chipwoods,

After restarting your virtual appliance, it seems that you had trouble initiating the Web Help Desk (WHD). The failure to start the PostgreSQL service, which controls the WHD database, is indicated by the error message.

This might be due to the fact that other processes are already using ports 80 and 443, which are necessary for WHD to function. Before trying to start WHD again, you might want to find out whatever process is using these ports and stop it.

Another possibility is that the PostgreSQL configuration or database files may be problematic. You can try looking through the PostgreSQL logs for any error messages that might point to the failure's primary cause. It is also important to make sure the virtual appliance has access to enough CPU, memory, and disc space.

Asking for help from the virtual appliance and/or WHD's vendor or support group may be helpful if you're still unable to address the problem.

Thank you.