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 E6E7852A10 for ; Wed, 30 Mar 2005 18:34:11 +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 70781-08 for ; Wed, 30 Mar 2005 17:34:08 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id 7C58B52965 for ; Wed, 30 Mar 2005 18:34:07 +0100 (BST) Received: from jfradkin ([66.15.127.235]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IE6009YVE4TGP72@vms044.mailsrvcs.net> for pgsql-admin@postgresql.org; Wed, 30 Mar 2005 11:34:05 -0600 (CST) Date: Wed, 30 Mar 2005 12:34:15 -0500 From: "Joel Fradkin" Subject: Re: connectivity to database been an issue for me. In-reply-to: <1112202293.31277.44.camel@state.g2switchworks.com> To: "'Scott Marlowe'" Cc: Message-id: <000401c5354e$b2643500$797ba8c0@jfradkin> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook, Build 10.0.6626 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.566 tagged_above=0 required=5 tests=AWL X-Spam-Level: * X-Archive-Number: 200503/491 X-Sequence-Number: 16989 You've got a networking problem, not postgresql, I'd bet. Do the logs on the server show anything odd, like crashing backends? =20 I do not see any crashes and when connected from inside the data center = I don't have any issues. Times I see an issue are when we pump any data (large result set, = restore, etc) over the DSL connection the ping to inside the data center or just = to a public site like yahoo starts to time out. So I am guessing I am losing connectivity from my development site (using verizon DSL). I use the = same connection to my current data center running MSSQL and have experienced = some issue, but nothing like I get with PGadmin. I have seen using enterprise manager doing work I occasionally see it drop the connection. I am not suggesting this is a postgres issue, I believe it is when the pipe is = over the 1.5 down or 394 up I lose connection (should happen if it is a pcanywhere transfer, ftp, sql data set etc.). But I will say I do not = seem to get disconnected from MSSQL using enterprise manager very often, = while I get disconnected from pgadmin every time I ask for large data set. This might be because the postgres is on a much faster box and is pumping = more data. But the question is two items.=20 1. Is there a posgres admin tool not so fussy about connection = (re-connects automatically if its just a blip in connectivity; like a ping timing out = is just one ping several are fine then blip time out, back to fine for 6 or = 7 pings then blip time out.)? 2. does anyone have experience with this type of issue, will getting = either 2 mb connectivity with breakfree, or a point to point T1 to the data = center help with losing connectivity when larger data sets are requested. My main concern is with getting replication set up and if this issue = will have a disasterous effect on trying to establish that.