Dear List,
I've been using PostgreSQL for quite while, but I'd need some direction on how to handle an opened socket to the database in longer periods. I open the connection to my database with PQconnectdb(). I access the database, everything is fine. However, if I don't access the database for a long time (measured in days), the connection is broken. I get this error message: SQL action failed: 'FATAL: terminating connection due to administrator command SSL connection has been closed unexpectedly. I tried to check the connection by PQstatus() before calling PQexec(), but this doesn't detect the broken connection. How can I detect this problem? Is it wise to terminate the connection each time the PQexec() finished? Should I keep the connection for say 1hour, then terminate it? Is there a common practice? Any guides are welcome. Thank you, Levente -- Levente Kovacs CTO, CSO http://levente.logonex.eu -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
