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@mcnaught.org> writes:
> > Fernando Flores Prior <fprior@tlaloc.imta.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