X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 76699D1B191 for ; Wed, 23 Jun 2004 11:59:46 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70591-08 for ; Wed, 23 Jun 2004 14:59:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id EF3C6D1B1C9 for ; Wed, 23 Jun 2004 11:59:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5NExiXr002377; Wed, 23 Jun 2004 10:59:44 -0400 (EDT) To: =?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= Cc: pgsql-admin@postgresql.org Subject: Re: Problems with the connection to a Remote Database. In-reply-to: <20040623073600.74218.qmail@web41008.mail.yahoo.com> References: <20040623073600.74218.qmail@web41008.mail.yahoo.com> Comments: In-reply-to =?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= message dated "Wed, 23 Jun 2004 02:36:00 -0500" Date: Wed, 23 Jun 2004 10:59:43 -0400 Message-ID: <2376.1088002783@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/306 X-Sequence-Number: 13966 =?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= writes: > Hi every body, my best regards for every one who reads > this message. I'm writing this message in order to get > some help with a problem I'm having with the > connection I make to a remote Database using > PostgreSQL on a Linux Operating System. The matter is > that when I make my connection every query I make > works pretty well during a few minutes after making > the connection, but if I leave the connection > established and go doing something, when I come back > to continue making queries, after more or less 10 > minutes, the connection seems to be loosen and it says > that I have to reset the connection to continue > working. Sounds like you have a firewall with a very short activity timeout between you and the remote system. You need to fix the firewall. (The timeout is likely associated with discarding the NAT mapping for your connection; you may be able to adjust it in the firewall's NAT settings.) Or, if you can't do that, program your application to send dummy queries every so often ... regards, tom lane