Postgres Restart
search cancel

Postgres Restart

book

Article ID: 11050

calendar_today

Updated On:

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