pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Morus Walter <morus.walter@tanto.de>
To: pgsql-admin@postgresql.org, "Joel Fradkin" <jfradkin@wazagua.com>
Subject: Re: connectivity to database been an issue for me.
Date: Thu, 31 Mar 2005 10:11:53 +0200
Message-ID: <16971.45257.133152.867195@tanto-xipolis.de> (raw)
In-Reply-To: <000001c53547$5385b970$797ba8c0@jfradkin>
References: <000001c53547$5385b970$797ba8c0@jfradkin>

Joel Fradkin writes:
> Hi,
> 
>  
> 
> We are in development stage of implementing postgres.
> 
> Our data center is in Tampa and we are in Bardenton and I am using DSL at my
> office (384 up, 1.5 down).
> 
> Data center is 2 meg ea way.
> 
> When I use pgadmin to connect it is ok, but as soon as I do any querry that
> has much data I get disconeected.
> 
> I was able to test pinging an outside web page (yahoo.com) and could see as
> soon as I start the transimission from a query in pgadmin the pinging gets
> disrupted (also I lose the connection to pgadmin).
> 
>  
> 
> I am thinking of T1 to data center (but is like 600 a month) or even upping
> the office to breakfreee which is pretty cheap and is 2 mb ea way.
> 
> Before I spend $ I thought I would ask if there are any tools less subject
> to disconnect from temporary connection loss?
> 
> If any one else experienced the same type of issues and what they did to
> resolve the issue.
> 
As others already pointed out, this is likely to be a networking problem
that has nothing to do with postgresql.

What comes in my mind regarding DSL is that a common error is to use
a too large MTU. Since there is some repackaging of network packets in
the ppp over ethernet protocol, one needs to make sure that the raw packages
are small enough to allow for the overhead.
Otherwise the effect is, that small packages (e.g. your ping) pass, while
large packages hang the connection.
Don't ask me for details of the configuration, I do that ~ once every two
years (on linux).

Morus



view thread (8+ messages)  latest in thread

Message-ID: <16971.45257.133152.867195@tanto-xipolis.de>
Permalink:  ../16971.45257.133152.867195@tanto-xipolis.de/
Also on:    postgresql.org/message-id/16971.45257.133152.867195@tanto-xipolis.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: morus.walter@tanto.de, jfradkin@wazagua.com
  Subject: Re: connectivity to database been an issue for me.
  In-Reply-To: <16971.45257.133152.867195@tanto-xipolis.de>
  References: <000001c53547$5385b970$797ba8c0@jfradkin> <16971.45257.133152.867195@tanto-xipolis.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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