Re: Beating Oracle - Mailing list pgsql-interfaces

From Bruce Momjian
Subject Re: Beating Oracle
Date
Msg-id 200202282358.g1SNwk504209@candle.pha.pa.us
Whole thread Raw
In response to Beating Oracle  (Bruce Badger <bbadger@BadgerSE.com>)
List pgsql-interfaces
Bruce Badger wrote:
> I posted a question a while back but got no response :-(
> 
> Due to network glitch, a PostgreSQL connection over IP is being dropped.
> 
> In the same situation, Oracle can keep it's connections going.
> 
> Is there any way to keep PostgreSQL connections alive across glitches, 
> or perhaps re-connect to an existing backend connection?
> 
> I have people using a mix of PostgreSQL and Oracle at the moment.  I 
> suspect they will drop PostgreSQL if there is no answer to this issue.
> 
> BTW I am the author of the Smalltalk PostgreSQL library 
> (http://sourceforge.net/projects/st-postgresql)

Wow, the TCP connection gets dropped and Oracle somehow reestablishes
the connection?  That is a nice feature.

TCP has it's own restart logic that will handle the dropping of some
packets, but if the TCP connection itself shuts down, PostgreSQL has no
way of reestablishing it.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-interfaces by date:

Previous
From: Bruce Badger
Date:
Subject: Beating Oracle
Next
From: Tom Lane
Date:
Subject: Re: Beating Oracle