Hi! I asked same thing in the list formerly, http://archives.postgresql.org/pgsql-general/2011-06/msg00888.php And because of lack of answers now I asked here also: http://stackoverflow.com/questions/6534654/postgresql-session-timeout I'm very wondering that I don't (and can't) found a system variable that define the timeout of the client session. Maybe I'm a real lama, or search with wrong terms... :-) The manual often refers to "Session end" - when the resources released, but never I saw a section that describe when it happens. The RDBMS-s needs some rule to mark a Session inactive or/and dead. Commonly they are uses a "Timeout" parameter that control how many minutes has ellapsed to session marked as Dead. FireBird and ElevateDB do this too. If the client is do anything, this time period extends again. The cleanup is needed for remove the locks, unfinished (limbo or started) transactions, and decrease the deadlock, or lock situations; and to never reach the maximum connections. So: is anybody here that can tell me how this working in PGSQL? And if there is no control, when the Session ends? Practical example (real): A client program died on a transaction, and it leaves many locks in the DataBase. If Session Timeout is 5 minutes, then we can tell the other users who got "Row lock", or "Transaction Timeout" errors to wait 6-7 minutes and then trying again, because after 5 minutes the problematic session is cleaned up, and locks/transactions removed from the objects. Thanks for your help: dd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
