Article ID: 4364, created on Mar 24, 2008, last review on Apr 25, 2014

  • Applies to:
  • Sphera

Symptoms

Resolution


This means that the postgres DB which is in charge of the GUI is not running properly.


 


In order to fix this please use the following procedure:


 


1. Search for user sphsvc in passwd file under /etc (it must be exists from SD3.7)


2. Check if there is a process called postmaster running under this user (sphsvc) or run the command ps -fu sphsvc


3. If not do the following:


a. su - sphsvc


b. remove the data/postmaster.pid file


c. go to bin directory


d. run pg_ctl start (using full path)


 


Or if you have existed back to root, you can run the command:


su - sphsvc -c "/usr/local/hostdir/sphera_db/bin/pg_ctl start"


 


4. Repeat #2 to check if the process is up, and if postmaster still not running try to start pg_ctl in following way:


su - sphsvc -c "/usr/local/hostdir/sphera_db/bin/pg_ctl start -l /tmp/pg.log"


After getting message like "postmaster successfully started" check the log file /tmp/pg.log


If something like "Lock file "/usr/local/accounts/[P.VDS]/etc/hd/tmp/.s.PGSQL.5432.lock" already exists." exists in log, remove* this lock file and try (3) again.


 


* rm /usr/local/accounts/[P.VDS]/etc/hd/tmp/.s.PGSQL.5432.lock


 


NOTE:


Message from the pg_ctl "postmaster successfully started" DOESEN'T MEAN ANYTHING.


5f478287f7e74fe9b07217d8131cd741 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF