PSQL not starting

Products

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

Issue/Introduction

APM PostgresSQL not starting after server rebooted.

Environment

Release : 10.7.0

 

Resolution

Change the status of the recording in the database by updating ts_status inside ts_recording_sessions.

update ts_recording_sessions set ts_status='Stopped' 

where ts_id = 700000000000000013;

You should now be able to open the Recording page in CEM