Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

PostgreSQL metadata DB does't start when restarting TSDS

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

PostgreSQL metadata DB does't start when restarting TSDS


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.