CABI postgres fails to start Unable to start Default Postgres database - has group or world access

Products

• CA Spectrum

Issue/Introduction

When trying to start CABI using the startServers.sh script postgres fails to start


Unable to start Default Postgres database

 

 

 

Environment

Release : 21.2

Component : Spectrum Reporting

Cause

 

The postgresql/data directory had full permissions for group/other  drwxrwxrwx when only the owner should have permissioms  (0700)

 

xxxxxxxxxx/CA Buisniuess Intelligence/postgresql/logs/log.txt

Resolution

 

The postgresql/data directory had full permissions for group/other which caused the database to 
   fail to start.

The postgres log file  /CA/IM/data/CA/SharedComponents/CA Business Intelligence/postgresql/logs/log.txt showed the following error

FATAL :  data directory "/CA/IM/data/CA/SharedComponents/CA Business Intelligence/postgresql/data" has group or world access

DETAIL: Permissions should be u=rvx (0700).


The postgresql/data folder had full permissions for owner/group/other  drwxrwxrwx

Changed the permissions to 700 recursively on the data folder

cd /CA/IM/data/CA/SharedComponents/CA Business Intelligence/postgresql/
chmod -R 700 data/

After this, both postgres and apache-tomcat started right up.