1. Verify that the PostgreSQL service is running
2. Restart the server
Below list summarize the available commands in Windows and Linux:
In Linux/Solaris
- Locate and navigate to the directory that contains the PostgreSQL startup script for your operating system: <APM_Db_Home>/bin/pg_ctl
- To check status of the database, run the following command:
pg_ctl -D <APM_Db_Home>/data status
- To start the database, run the following command:
pg_ctl -D <APM_Db_Home>/data -l <APM_Db_Home>/data/pg_log/postmaster.log start
- To stop the database, run the following command:
pg_ctl -D <APM_Db_Home>/data stop
- To restart the database run the following command:
pg_ctl -D <APM_Db_Home>/data -l <APM_Db_Home>/data/pg_log/postmaster.log restart
In Windows
To start/stop the PostgreSQL service,
Select Control Panel > Administrative Tools > Services > pgsql-<version> - PostgreSQL Server <version>