The Postresql Fails to Start or Hangs During FM Installation

The Postresql fails to start or hangs during FM Installation
Solution ID: 20
Created: 7/8/2008
DETAILS:
When postresql fails to start or hangs there are a couple of simple checks and
balances to go through:
1. df -h on / or /tmp if tmp is separate FS, to determine if postresql has enough
space to start
2. ps -f | grep postmaster , check to see if multiple postmaster threads are
running perhaps one is hung and kill -ALL postmaster then try restart of
fusionserver
3. check the /var/log/pglog for errors -connection errors to sql? if so try putting
"set -x" in /usr/local/ibrix/init/ibrix_postresql startup script and try to run
./ibrix_postresql start
4. check the /usr/local/ibrix/log/fusionmanager.log do you see "unexpected EOF
on client connection errors" when postresql is started? if yes, then as root su ibrix
ensure ibrix user account is active otherwise if not it will prompt you to change
the "ibrix" password. Upon changing the ibrix user password you will then be able
to /etc/init.d/fusionmanager restart to get postresql and fusionmanager services
running again. If you encountered the user ibrix expired issue then the customer
has some sort of aging policy setup for all users.
5. check also to make sure /var/log exists? on the FM pgsql and pglog must exist
in this directory in order for postresql and fusionserver to start simply recreate
/var/log as root, recreate pgsql as postgres with 700 perms and pglog as ibrix
with 644 perms then reboot. i.e.
chown postgres:postgres pgsql
chmod 700 pgsql
chown ibrix:ibrix pglog
chmod 644 pglog
IBRIX_S00000020.pdf
Last modified: 7/8/2008