Postgres Restart

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• DX Application Performance Management

Issue/Introduction

What is the command(s) to restart the postgres database in APM?

Environment

DX APM 10.*

Resolution

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

1. Locate and navigate to the directory that contains the PostgreSQL startup script for your operating system: <APM_Db_Home>/bin/pg_ctl 
    
2. To check status of the database, run the following command: 
   pg_ctl -D <APM_Db_Home>/data status 
    
3. 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 
    
4. To stop the database, run the following command: 
   pg_ctl -D <APM_Db_Home>/data stop 
    
5. 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>

Additional Information

Techdocs - Manage the APM database