Re: [GENERAL] secure connections

From: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>
To: "c k" <shreeseva(dot)learning(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] secure connections
Date: 2008-09-08 00:27:44
Message-ID: 92869e660809071727x5fb35b51q6bd0e74fedd736ca@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jumping 2008-09-08 03:35:43 update to 8.3.3
Previous Message c k 2008-09-07 20:32:05 secure connections

Browse pgsql-general by date

  From Date Subject
Next Message Artacus 2008-09-08 01:35:51 psql scripting tutorials
Previous Message Asko Oja 2008-09-07 23:18:15 Re: Efficient processing of staging data