PostgreSQL metadata DB does't start when restarting TSDS
Article ID: KB0082475
Updated On:
| Products | Versions |
|---|---|
| Spotfire Data Science | 6.x |
Description
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)
[tsds@tsds632 data]$ chorus_control.sh start
[production] supervisord started as pid 55801
postgres: ERROR (spawn error)
Issue/Introduction
PostgreSQL metadata DB does't start when restarting TSDS
Resolution
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.
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.
Feedback
Yes
No
Powered by
