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.
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
Thanks for your quick response.
Here below are the details.
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.
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
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:
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.
Retrieving data ...