Losing my database connection

[Aryan Ariel Rodriguez Chalas]

Hi every one!.

I'm having toubles with my PostgreSQL Database
Connection. I don't know why, but after more or less
10 minutes I lose the connection to a PostgreSQL
Database which is running in a server in a remote
site. This means that, if I'm not doing any query to
the Database on the server, my connections loses
everty 10 minutes. I haven't tested still what will
happens if I stay making queries to the Database on
the server for 10 minutes without any stop. But
anyway, I think it will do the same.

I Expect If somebody unserstood, please, I'll thank
very much some of help.

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org

[Tom Lane]

Post by Aryan Ariel Rodriguez Chalas
I'm having toubles with my PostgreSQL Database
Connection. I don't know why, but after more or less
10 minutes I lose the connection to a PostgreSQL
Database which is running in a server in a remote
site. This means that, if I'm not doing any query to
the Database on the server, my connections loses
everty 10 minutes.

This sounds like a firewall problem. If there's a firewall box between
you and the database server, and the firewall does address translation
(NAT), then it probably has a timeout after which it will drop the
translation info for an idle connection. Ten minutes sounds
unreasonably short though :-(. You should be able to adjust that
timeout somewhere in the firewall's settings ... if not, get a new
firewall.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly