From: Tom Lane <tgl@sss.pgh.pa.us>
To: Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Problems with the connection to a Remote Database.
Date: Wed, 23 Jun 2004 10:59:43 -0400
Message-ID: <2376.1088002783@sss.pgh.pa.us> (raw)
In-Reply-To: <20040623073600.74218.qmail@web41008.mail.yahoo.com>
References: <20040623073600.74218.qmail@web41008.mail.yahoo.com>
=?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= <wimogan@yahoo.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, wimogan@yahoo.com
Subject: Re: Problems with the connection to a Remote Database.
In-Reply-To: <2376.1088002783@sss.pgh.pa.us>
References: <20040623073600.74218.qmail@web41008.mail.yahoo.com> <2376.1088002783@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox