Re: [GENERAL] PostgreSQL keepalives help

2010-07-30 Thread Richard Huxton
On 29/07/10 21:16, Kananda wrote: I need the records are free for edit, in few minutes. Therefore I set the KEEPALIVE configuration in my "postgresql.conf": tcp_keepalives_idle = 60 # TCP_KEEPIDLE, in seconds; tcp_keepalives_interval = 60 # TCP_KEEPINTVL, in seconds; tcp_keepalives_count TCP_K

[GENERAL] PostgreSQL keepalives help

2010-07-29 Thread Kananda
Hy, I have a system working with the client-server structure and PostgreSQL 8.4. My problem is that if a client who is editing a record and lose his connection to the server,the TCPIP connection is still considered! So, the record stay allocated for the client in my database. I need the records