X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 58140537A2 for ; Thu, 31 Mar 2005 09:09:44 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44955-02 for ; Thu, 31 Mar 2005 08:09:39 +0000 (GMT) Received: from mail.tanto.de (mail.tanto.de [213.61.178.43]) by svr1.postgresql.org (Postfix) with ESMTP id DE9C953782 for ; Thu, 31 Mar 2005 09:09:38 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by mail.tanto.de (Postfix) with ESMTP id 62D4223CE0; Thu, 31 Mar 2005 10:09:51 +0200 (CEST) Received: from mail.tanto.de ([127.0.0.1]) by localhost (mail.tanto.de [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10446-07; Thu, 31 Mar 2005 10:09:51 +0200 (CEST) Received: from tucholsky.office.tanto.de (tucholsky.office.tanto.de [10.0.0.35]) by mail.tanto.de (Postfix) with ESMTP id 411F523BF5; Thu, 31 Mar 2005 10:09:51 +0200 (CEST) Received: from tucholsky.office.tanto.de (morus@localhost [127.0.0.1]) by tucholsky.office.tanto.de (8.12.3/8.12.3/Debian-7.1) with ESMTP id j2V8Br4B012970; Thu, 31 Mar 2005 10:11:53 +0200 Received: (from morus@localhost) by tucholsky.office.tanto.de (8.12.3/8.12.3/Debian-7.1) id j2V8Br6I012966; Thu, 31 Mar 2005 10:11:53 +0200 From: Morus Walter MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16971.45257.133152.867195@tanto-xipolis.de> Date: Thu, 31 Mar 2005 10:11:53 +0200 To: pgsql-admin@postgresql.org, "Joel Fradkin" Subject: Re: connectivity to database been an issue for me. In-Reply-To: <000001c53547$5385b970$797ba8c0@jfradkin> References: <000001c53547$5385b970$797ba8c0@jfradkin> X-Mailer: VM 7.03 under 21.4 (patch 6) "Common Lisp" XEmacs Lucid X-Virus-Scanned: by amavisd-new at mail.tanto.de Q&A postmaster@tanto.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/499 X-Sequence-Number: 16997 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