"carlos gustavo" <cgcl.comp@gmail.com> writes: > How can Postgres detect the connection lost and remove all locks made by > this connection? It's a configuration in Postgres or have another way to > lock a registry? It is not Postgres' responsibility to detect a lost network connection, it is the network stack's responsibility. When the network code reports to the backend that the connection is lost, we'll clean up and exit the session appropriately. I think your real complaint is that you think the network code's timeout for declaring the connection lost is too long. On some platforms you can shorten the timeout by making the tcp_keepalive settings more aggressive, but be aware that doing so violates various RFCs and may result in less-reliable connections. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly