pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Losing my database connection
2+ messages / 2 participants
[nested] [flat]

* Losing my database connection
@ 2004-07-05 03:45 Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
  2004-07-05 04:35 ` Re: Losing my database connection Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Aryan Ariel Rodriguez Chalas @ 2004-07-05 03:45 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Losing my database connection
  2004-07-05 03:45 Losing my database connection Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
@ 2004-07-05 04:35 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-07-05 04:35 UTC (permalink / raw)
  To: Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>; +Cc: pgsql-admin

=?iso-8859-1?q?Aryan=20Ariel=20Rodriguez=20Chalas?= <wimogan@yahoo.com> writes:
> 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-05 04:35 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-05 03:45 Losing my database connection Aryan Ariel Rodriguez Chalas <wimogan@yahoo.com>
2004-07-05 04:35 ` Tom Lane <tgl@sss.pgh.pa.us>

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