Re: [GENERAL] secure connections

2008/9/7 Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>:
> 2008/9/7 c k <shreeseva(dot)learning(at)gmail(dot)com>:
>> Hello,
>> I have a question regarding secure connections between pg clients and pg
>> server. As per manual for 8.3 we can use openssl for this purpose. does odbc
>> driver supports it and how? Is there any other method for this?
>
> Yes the ODBC driver (as well as all decent postgres clients) does
> support SSL. You can choose SSL mode: disable/prefer/allow/require.
>
> Other method? Encrypted tunnels. VPNs. this kind of stuff.
>
> Remember that establishing SSL session is resource - expensive. This
> can be important if you plan lots of connections.
>
> cheers
>
> --
> Filip Rembiałkowski
>

You can use stunnel + pgbouncer in lots of connections, I'll be using
it without big resources on that machine.

Greetings

Alejandro