Re: connectivity to database been an issue for me.

Well the issue seems to occur for any traffic not limited to any one
machine.

Pinging Yahoo for instance the ping is timing out when the line gets full
load.
I spoke to Verizon and they admitted they sold more bandwidth then the hard
wires in the area support.

I am going to see if we can slow down the traffic at the fire wall, but also
plan on getting a 2mb breakfree wireless account as it is just 100.00 a
month and much better connectivity.

My real question was if it would be better to get a T1 to the data center or
if going over the internet was ok if I get the expanded bandwidth; based on
real world experience doing a similar thing. I hate to recommend an
expensive solution just to end up with the same issues. I tried loading the
line with various types of communication to different machines, so it is not
a postgres issue at all (sorry for voicing the question in a pg forum, but I
figured you guys deal with a bit of the networking as well).

Unfortunatley the T1 is a bit expensive (T1>500.00 a month).

Joel Fradkin


-----Original Message-----
From: Morus Walter [mailto:morus.walter@tanto.de]
Sent: Thursday, March 31, 2005 3:12 AM
To: pgsql-admin@postgresql.org; Joel Fradkin
Subject: Re: [ADMIN] connectivity to database been an issue for me.

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