PostgreSQL metadata DB does't start when restarting TSDS

Created
October 08, 2021 23:27

Date Posted: 2018-02-26
Product: TIBCO Spotfire®

Problem:

Solution:

PostgreSQL metadata DB does't start when restarting TSDS, and this error appears on the command line:

[tsds@tsds632 data]$ chorus_control.sh start
[production] supervisord started as pid 55801
postgres: ERROR (spawn error) These type of errors get logged in the $CHORUS_HOME/shared/log/postgres-supervisord.log file:

FATAL: data directory "/home/tsds/install/current/postgres-db" has group or world access
DETAIL: Permissions should be u=rwx (0700).

which indicate that the $CHORUS_DATA/db directory permissions were changed from the default 700. Manually set the correct permissions: "chmod 700 $CHORUS_DATA/db" and restart TSDS.