Created by James Hurrell on Dec 01, 2022

End of Life Notice

CAST Storage Service (com.castsoftware.css) is End of Life and is no longer supported or distributed. Customers previously using CAST Storage Service must migrate to a standard PostgreSQL installation. CAST recommends PostgreSQL 18.x.

Summary: some troubleshooting techniques for specific issues that may be encountered when using PostgreSQL

An existing connection was forcibly closed by the remote host

This error may be be accompanied by the following in the 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 PostgreSQL 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.