Re: - what protocol for an Internet postgres

Ok,

Now I have a better vision of what can be accomplished with the
options that you gave me.

Thanks a lot (Richard, Doug and Tom).

-Fernando

At 12:37 p.m. 14/05/2003 -0400, Tom Lane wrote:
>Doug McNaught <doug(at)mcnaught(dot)org> writes:
> > Fernando Flores Prior <fprior(at)tlaloc(dot)imta(dot)mx> writes:
> >> 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. :)
>
>However, from a security standpoint I don't think there's any question
>that you want to use SSL encryption for any database connection that
>passes over the open Internet. I seem to recall that the ODBC driver
>(still) doesn't support SSL --- if so, that would be reason enough not
>to use it. Or to invest the effort to fix it.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster