Re: - what protocol for an Internet postgres connection - Mailing list pgsql-general

From Doug McNaught
Subject Re: - what protocol for an Internet postgres connection
Date
Msg-id m3znlpecci.fsf@varsoon.wireboard.com
Whole thread Raw
In response to - what protocol for an Internet postgres connection  (Fernando Flores Prior <fprior@tlaloc.imta.mx>)
Responses Re: - what protocol for an Internet postgres connection  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Fernando Flores Prior <fprior@tlaloc.imta.mx> writes:

> Hi Doug,
>
> So,  it is safe then to use ODBC for an Internet connection ?
> I'm in doubt about that, mainly because of the lag involved
> on this kind of network and its transient failures that may
> cause a disconnection.

It's as safe as any other API--as I said, there's only one wire
protocol used by all libraries.  Lag will just slow things down but
should not cause any data loss.  If your connection drops too often
due to packet loss there isn't much you can do about that at the PG
level--get a better network connection.  :)

-Doug

pgsql-general by date:

Previous
From: "alex b."
Date:
Subject: Re: COPY versus INSERT
Next
From: Doug McNaught
Date:
Subject: Re: Questions regarding stored procedures