Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 49912632B31; Thu, 29 Jul 2010 17:22:23 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 93757-09; Thu, 29 Jul 2010 20:22:14 +0000 (UTC) X-Greylist: delayed 00:05:24.26633 by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from remote.stepsoftware.com.br (step.funcitec.rct-sc.br [189.8.192.142]) by mail.postgresql.org (Postfix) with ESMTP id 9739D632346; Thu, 29 Jul 2010 17:22:14 -0300 (ADT) Received: from SBS.step.local ([fe80::3df9:2e60:f833:73b7]) by SBS.step.local ([fe80::3df9:2e60:f833:73b7%10]) with mapi; Thu, 29 Jul 2010 17:16:45 -0300 From: Kananda To: "pgsql-general@postgresql.org" , "pgsql-admin@postgresql.org" , "pgsql-cluster-hackers@postgresql.org" Date: Thu, 29 Jul 2010 17:16:44 -0300 Subject: PostgreSQL keepalives help Thread-Topic: PostgreSQL keepalives help Thread-Index: AQHLL1r2cVfbQweWN0u1mWv+dyYpew== Message-ID: <4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3@SBS.step.local> Accept-Language: pt-BR Content-Language: pt-BR X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: pt-BR Content-Type: multipart/alternative; boundary="_000_4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3SBSsteplocal_" MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201008/13 X-Sequence-Number: 35262 --_000_4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3SBSsteplocal_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 connect= ion to the server,the TCPIP connection is still considered! So, the record = stay allocated for the client in my database. I need the records are free for edit, in few minutes. Therefore I set the K= EEPALIVE configuration in my "postgresql.conf": tcp_keepalives_idle =3D 60 # TCP_KEEPIDLE, in seconds; tcp_keepalives_interval =3D 60 # TCP_KEEPINTVL, in seconds; tcp_keepalives_count TCP_KEEPCNT =3D 5 #; After making these settings and restart the server, the system continues to= function the same way: Just breaks the connection TCPIP after two hours an= d then deallocates the records in PostgreSQL. I need a efficient and safe w= ay for the PostgreSQL understand that is to break these connections as conf= igured! I need help, urgent! Thanks, Kananda S Silveira - Desenvolvedora .NET / Analista de Banco de Dados STEP SOFTWARE Tecnologia e Projetos LTDA kananda@stepsoftware.com.br / +55(48)84= 17-8121 --_000_4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3SBSsteplocal_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hy,
 
I have a system working w= ith the client-server structure and PostgreSQL 8.4.
My problem is that if a client who is editing a record and lose his connect= ion to the server,the TCPIP connection is still considered! So, the record = stay allocated for the client in my database.
I need the records are free for edit, in few minutes. Therefore I set the K= EEPALIVE configuration in my "postgresql.conf":
 
tcp_keepalives_idle =3D 6= 0 # TCP_KEEPIDLE, in seconds;
tcp_keepalives_interval =3D 60 # TCP_KEEPINTVL, in seconds;
tcp_keepalives_count TCP_KEEPCNT =3D 5 #;
 
After making these settin= gs and restart the server, the system continues to function the same way: J= ust breaks the connection TCPIP after two hours and then deallocates the re= cords in PostgreSQL. I need a efficient and safe way for the PostgreSQL understand that is to break these connecti= ons as configured! I need help, urgent!
 
Thanks,
 
Kananda S Silveira - Desenvolvedora .NET= / Analista de Banco de Dados
STEP SOFTWARE Tecnologia e Projetos LTDA<= /strong>
kananda@stepsof= tware.com.br / +55(4= 8)8417-8121
--_000_4A704C139DFD804DB74FFB9CC0BE79FC790B5631C3SBSsteplocal_--