DX Application Performance Management

Expand all | Collapse all

postrgesql is down

  • 1.  postrgesql is down

    Posted 08-27-2015 07:01 AM

    All,

     

    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.

     

    Thanks,

    Sandeep



  • 2.  Re: postrgesql is down

    Posted 08-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,

    David



  • 3.  Re: postrgesql is down

    Posted 08-27-2015 07:26 AM

    Hi Dave,

    Thanks for your quick response.

    Here below are the details.

     

    OS:RHEL 6

    APM:9.7.1.16

     

    Sandeep



  • 4.  Re: postrgesql is down

    Posted 08-27-2015 07:50 AM

    Dave,

    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.

     

    Thanks,

    Sandeep



  • 5.  Re: postrgesql is down

    Posted 08-27-2015 08:35 AM

    Ok well you can check the documentation:

    https://wiki.ca.com/display/APMDEVOPS97/How+to+Install+and+Configure+the+APM+Database

     

    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 11-29-2015 03:07 AM

    Hi,

    first you must check where is this file:

         postgresql-9.2

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

         find / -name postgresql-9.2

    in my system it returned:

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

    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.