Insights Hub Service PostgresSQL connection failed or Stopped instances

ERR psycopg2.OperationalError: could not connect to server: Connection refused

Cloud Foundry has a parachute component that monitors every service instance to evaluate the ephemeral and persistent disk usage. If a disk usage reaches the configured threshold Parachute stops all of this instance's processes and writes a message into the log directory:

Limit reached for: <persistent/ephemeral> disk

If necessary, you can update the threshold to 90 or 95%.

cf update-service <serviceName> -c '{"max_disk_threshold": "90"}'

For more information: https://documentation.mindsphere.io/MindSphere/paas/paas-cloudfoundry-backingservices.html#restart-stopped-instances

Notes:  This is only a temporary solution. The service instance is stopped when the threshold is reached again. For a long-term solution, the service instance must be updated to a larger plan size if available.