Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Web Help Desk (WHD) > Embedded PostgreSQL service fails to restart

Embedded PostgreSQL service fails to restart

Created by Nicholas Templin, last modified by MindTouch on Jun 23, 2016

Views: 197 Votes: 0 Revisions: 6

Overview

Embedded PostgreSQL service fails to restart in Web Help Desk.

This issue normally happens on Virtual Appliance deployment of Web Helpdesk.

Cause: 

The root partition of the Virtual Appliance (VA) is out of disk space as backup files can take up storage space.

Resolution

Free up the disk space, for example, by moving your postgre database backup folder (/usr/local/webhelpdesk/pgsql9/Backups) to a separate system, or a networked hard drive. Backups must be handled by the user themselves.

 

Here are the steps to move the backup files to a different partition:

1.    Connect to the Virtual Appliance using an SSH client like PuTTY as an “admin” (default password is “admin”)
2.    Change to the user “root”
    command: sudo su -

 

3.    Check if PostgreSQL is running which is most probably not
    command: ps -ef | grep webhelpdesk | grep postgres
 
If you don’t see anything that looks like: “/usr/local/webhelpdesk/bin/pgsql/usr/pgsql-9.2/bin/postmaster -p 20293 -D /usr/local/webhelpdesk/bin/pgsql/var/lib/pgsql/9.2/data” then PostgreSQL service is not running

 

4.    Check for the drive spaces of the partition
    command: df -h

 

At this point, you should see the Use% in percentage for every partition. You will then see that the root partition is at 100%. Usually, the number 1 culprit are the backup files of PostgreSQL that WHD is writing to the default location “/usr/local/webhelpdesk/pgsql9/Backups/”

 

5.    Change to the backup location and check the size of the total size of the backup files:
    cd /usr/local/webhelpdesk/pgsql9/Backups/
 
    command: ls -la         ** This command will list all of the backup files
 
    command: du -sh       **  This command is used to see the total file size of all backup files
 
6.    At this point, you will have to educate the customer that there is another partition that should be used for the backups and that is “/data1/backup” so, let’s move those backups to it
    
    command: mv * /data1/backup/
    
    And to list the files moved in /data1/backup: 
    command: ls -la /data1/backup

 

7.    After it is being moved, you should see a change of the drive space in the root partition

    command: df -h
 
8.    Restart Web Help Desk
    
    Stop WHD
    command: service webhelpdesk stop
    
    Start WHD
    command: service webhelpdesk start
 
9.    Browse or open your WHD site and login as an admin then change the PostgreSQL DB backup location from “/usr/local/webhelpdesk/pgsql9/Backups” to “/data1/backup”. Ignore the info message after saving it.

Last modified

Tags

Classifications

Public