Обсуждение: BUG #7821: constant disconnection with external network
The following bug has been logged on the website: Bug reference: 7821 Logged by: Alessandro Linguanoto Email address: alessandro@nwsoftware.com.br PostgreSQL version: 9.0.6 Operating system: Windows Description: = I use PostgreSQL 9.0.6 and I=C2=B4m with a problem using PostgreSQL with ex= ternal network, by internet (cloud). If the user open the application and don=C2=B4t use the application by minu= tes, the connection with database is lost, but if the user to use application constantly, the connection with database isn't interrupted. = Is there some setting to avoid this kind of problem?
alessandro@nwsoftware.com.br wrote: > I use PostgreSQL 9.0.6 and I´m with a problem using PostgreSQL with external > network, by internet (cloud). > > If the user open the application and don´t use the application by minutes, > the connection with database is lost, but if the user to use application > constantly, the connection with database isn't interrupted. > > Is there some setting to avoid this kind of problem? This is very likely to be caused by a firewall; reconfiguring the firewall is one solution. You might be able to keep the connections alive by configuring the TCP keepalive parameters. http://www.postgresql.org/docs/9.2/interactive/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS -Kevin