Summary: some troubleshooting techniques for specific issues that may be encountered when using CAST Storage Service/PostgreSQL
An existing connection was forcibly closed by the remote host
This error may be be accompanied by the following in the CAST Storage Service/PostgreSQL log:
FATAL: terminating connection due to idle-in-transaction timeout
If this situation occurs, you can try increasing the following value in the postgresql.conf file and then restarting the instance:
idle_in_transaction_session_timeout
See https://www.postgresql.org/docs/current/runtime-config-client.html for more information.
Windows Service fails to start
If your CAST Storage Service Windows Service fails to start, it may be due to multiple instances of the postgres.exe running in background. To resolve the issue, kill all instances of the postgres.exe that are visible in Windows Task Manager, then try restarting the Windows Service.