Обсуждение: Problems with the connection to a Remote Database.
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. That's a big problem I'm having, because I have developed an aplication that connects to a remote Database while on internet and by default I lose my connection very often while it is supposed not to do that. I would like to have an alive connection during more or less 20 hours without losing it unless I have internet troubles or my computer desconets itself from internet due some reason. If somebody read this message and understood something, I would thank if it is possible to tell me how I can solve this problem. Please write me to wimogan@hotmail.com . Expecting for answers .... Ariel Rodriguez _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.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