How to start/stop only the PosgreSQL service in CABI/JasperReports

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

There are scenarios where only the PostgreSQL (postgres) service needs to be started or stopped in CABI/JasperReports.

Environment

CABI/JasperReports 7.9.x

Resolution

Start only the PostgreSQL service (it starts with the Postgres account):

su postgres -c '"/opt/CA/SharedComponents/CA Business Intelligence/postgresql/bin/pg_ctl" start -D "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/data" -l "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/logs/logfile1"'

 

Stop only the PostgreSQL service (it stops with the Postgres account):

su postgres -c '"/opt/CA/SharedComponents/CA Business Intelligence/postgresql/bin/pg_ctl" stop -D "/opt/CA/SharedComponents/CA Business Intelligence/postgresql/data"'

See my demonstration below:

You can also run startServer.sh/stopServers.sh with postgres parameter:

cd /opt/CA/SharedComponents/CA Business Intelligence/

./startServers.sh postgres

./stopServers.sh postgres

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/dx-netops/23-3/ca-business-intelligence-for-netops/upgrading-ca-business-intelligence-jasperreports-server.html#concept.dita_0fcadc944d63c171c8b55704df2d32bf0cb3910c_checkservers

See my demonstration below: