DX Application Performance Management

 View Only
  • 1.  postrgesql is down

    Posted Aug 27, 2015 07:01 AM



    postgresql is down once after my VM is rebooted.

    I would like to know of how to perform start/stop.


    Please assist and let me know if any info needed.




  • 2.  Re: postrgesql is down

    Broadcom Employee
    Posted Aug 27, 2015 07:22 AM

    HI Sandeep,

    It would be useful to know which operating system you are running on and which version of APM this.

    If you installed the Postgres with our installer, it creates a Windows service (the name would be something like pgsql) or a service in Red Hat - you could run the chkconfig --list command to get a list of services and there could be something like postgresql or pgsql.

    Then you need to see if you can start the Windows service or in Linux run a command like service <servicename> start

    many thanks,


  • 3.  Re: postrgesql is down

    Posted Aug 27, 2015 07:26 AM

    Hi Dave,

    Thanks for your quick response.

    Here below are the details.


    OS:RHEL 6




  • 4.  Re: postrgesql is down

    Posted Aug 27, 2015 07:50 AM


    I am not an Admin and doesn't have root priviliege to issue the above.

    Please can you direct me the proper dierectory and the procedure to be followed to start/stop.




  • 5.  Re: postrgesql is down

    Broadcom Employee
    Posted Aug 27, 2015 08:35 AM

    Ok well you can check the documentation:



    There is a section in there that tells you what to do for start and stop

    Start the APM Database on PostgreSQL


    The database is installed by default to /opt/database but it could be anywhere on the file system so references to <APM_Db_Home>/ in the documentation should probably be replaced by /opt/database

  • 6.  Re: postrgesql is down

    Posted Nov 29, 2015 03:07 AM


    first you must check where is this file:


    in *nix systems you can do it by using this:

         find / -name postgresql-9.2

    in my system it returned:


    now to start/restart/stop postgres, just ran the next instruction using root:

         /etc/rc.d/init.d/postgresql-9.2 start

         /etc/rc.d/init.d/postgresql-9.2 stop

         /etc/rc.d/init.d/postgresql-9.2 restart

    To check what is going on with your DB, you must read the file postgresql-<year>-<month>-<day>.log located on the pg_log directory.