Thread: secure connections
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?
Thanks
CPK
2008/9/7 c k <shreeseva.learning@gmail.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
2008/9/7 Filip Rembiałkowski <plk.zuber@gmail.com>: > 2008/9/7 c k <shreeseva.learning@gmail.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