[BitBucket user: Toshko Andreev] [BitBucket date: 2016-02-22.07:09:50] I've been running Orthanc with the PostgreSQL plugins for some time now and it appears that after about 10 hours of inactivity an exception occurs with Postgre: ``` #!Log E0220 03:20:51.562601 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. E0220 06:51:03.924868 PluginsManager.cpp:163] Exception in database back-end: Error in PostgreSQL: no connection to the server ``` Orthanc at that point becomes broken and cannot work until you restart the service (Windows 7 x64).
[BitBucket user: Sébastien Jodogne] [BitBucket date: 2016-02-24.09:44:27] This issue was discussed on the mailing list: https://groups.google.com/d/msg/orthanc-users/RQOqFB-zDmc/qqSJoVzqBAAJ This timeout problem can be solved by enabling keep alive (e.g. to 120 seconds) in the configuration of the PostgreSQL server: http://dba.stackexchange.com/questions/97534/is-there-a-timeout-option-for-remote-access-to-postgresql-database