Oliver Jowett wrote:
I'm currently trying to find a clean way to deal with network-dead clients that are in a transaction and holding locks etc.Have you come across the pgpool connection-pooling project? http://pgpool.projects.postgresql.org/
I've looked at it, haven't used it.
Might be easier to put a timeout+disconnect in there.
It seems like I have the same design issues even if the code lives in pgpool. Also, I'm reluctant to introduce another bit of software into the system just for the sake of timeouts; we have no other need for pgpool functionality.
-O
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]