Re: [GENERAL] secure connections - Mailing list pgsql-admin

From Alejandro D. Burne
Subject Re: [GENERAL] secure connections
Date
Msg-id 8398dc6d0809080904w44a2c2cbw3f2f0f417bb211f0@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] secure connections  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Ben Kim
Date:
Subject: Re: problem with pg_stat_activity view
Next
From: "Kasia Tuszynska"
Date:
Subject: moving tablespaces on windows - is it possible?