pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
long term persistent tunnels
2+ messages / 2 participants
[nested] [flat]

* long term persistent tunnels
@ 2004-08-19 23:29 David Bear <David.Bear@asu.edu>
  2004-08-20 00:38 ` Re: long term persistent tunnels Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: David Bear @ 2004-08-19 23:29 UTC (permalink / raw)
  To: pgsql-admin

Now that I have ssh tunneling working I am wondering what pitfalls
away.

Assume I have a server called db1 running the postgresql backend.

Asume I have another server called web1 that will be connecting to db1
for data base operations.  If I setup an ssh tunnel should I be aware
of any problems with 1) spontaneously dropped connections...2) long
term time out -- 3)other?

any advice most appreciated.

-- 
David Bear
phone: 	480-965-8257
fax: 	480-965-9189
College of Public Programs/ASU
Wilson Hall 232
Tempe, AZ 85287-0803
 "Beware the IP portfolio, everyone will be suspect of trespassing"



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

* Re: long term persistent tunnels
  2004-08-19 23:29 long term persistent tunnels David Bear <David.Bear@asu.edu>
@ 2004-08-20 00:38 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-08-20 00:38 UTC (permalink / raw)
  To: David.Bear@asu.edu; +Cc: pgsql-admin

David Bear <David.Bear@asu.edu> writes:
> Asume I have another server called web1 that will be connecting to db1
> for data base operations.  If I setup an ssh tunnel should I be aware
> of any problems with 1) spontaneously dropped connections...2) long
> term time out -- 3)other?

In theory the connection won't be dropped until the client drops it or
the database is shut down.

In practice, the only major problems I've heard about have to do with
connections that go through a NAT (address-mapping) firewall.  A NAT
firewall has to keep a table of open connections, and some of them seem
to drop their entries for idle connections with unseemly haste (like
less than the RFC-mandated timeouts).

If you've got one of these suckers to deal with, the only solution is to
make sure there's some activity on the connection at least once every
few minutes.

If web1 and db1 are on the same LAN then you probably have nothing to
fear.

			regards, tom lane



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


end of thread, other threads:[~2004-08-20 00:38 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-19 23:29 long term persistent tunnels David Bear <David.Bear@asu.edu>
2004-08-20 00:38 ` 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