From: Alejandro D. Burne <alejandro.dburne@gmail.com>
To: Filip Rembiałkowski <plk.zuber@gmail.com>
Cc: c k <shreeseva.learning@gmail.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] secure connections
Date: Mon, 8 Sep 2008 13:04:01 -0300
Message-ID: <8398dc6d0809080904w44a2c2cbw3f2f0f417bb211f0@mail.gmail.com> (raw)
In-Reply-To: <92869e660809071727x5fb35b51q6bd0e74fedd736ca@mail.gmail.com>
References: <d8e7a1e30809071332y7dbd40b9m6d7e46c679e7904c@mail.gmail.com>
<92869e660809071727x5fb35b51q6bd0e74fedd736ca@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alejandro.dburne@gmail.com, plk.zuber@gmail.com, shreeseva.learning@gmail.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] secure connections
In-Reply-To: <8398dc6d0809080904w44a2c2cbw3f2f0f417bb211f0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox