pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joel Fradkin <jfradkin@wazagua.com>
To: 'Scott Marlowe' <smarlowe@g2switchworks.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: connectivity to database been an issue for me.
Date: Wed, 30 Mar 2005 12:34:15 -0500
Message-ID: <000401c5354e$b2643500$797ba8c0@jfradkin> (raw)
In-Reply-To: <1112202293.31277.44.camel@state.g2switchworks.com>

You've got a networking problem, not postgresql, I'd bet.  Do the logs
on the server show anything odd, like crashing backends?  

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. 
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.




view thread (8+ messages)  latest in thread

Message-ID: <000401c5354e$b2643500$797ba8c0@jfradkin>
Permalink:  ../000401c5354e$b2643500$797ba8c0@jfradkin/
Also on:    postgresql.org/message-id/000401c5354e$b2643500$797ba8c0@jfradkin

 · 

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: jfradkin@wazagua.com, smarlowe@g2switchworks.com
  Subject: Re: connectivity to database been an issue for me.
  In-Reply-To: <000401c5354e$b2643500$797ba8c0@jfradkin>
  References: <1112202293.31277.44.camel@state.g2switchworks.com> <000401c5354e$b2643500$797ba8c0@jfradkin>

* 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