pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsecure connections
3+ messages / 3 participants
[nested] [flat]
* secure connections
@ 2008-09-07 20:32 c k <shreeseva.learning@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: c k @ 2008-09-07 20:32 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] secure connections
@ 2008-09-08 00:27 Filip Rembiałkowski <plk.zuber@gmail.com>
parent: c k <shreeseva.learning@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Filip Rembiałkowski @ 2008-09-08 00:27 UTC (permalink / raw)
To: c k <shreeseva.learning@gmail.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [GENERAL] secure connections
@ 2008-09-08 16:04 Alejandro D. Burne <alejandro.dburne@gmail.com>
parent: Filip Rembiałkowski <plk.zuber@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Alejandro D. Burne @ 2008-09-08 16:04 UTC (permalink / raw)
To: Filip Rembiałkowski <plk.zuber@gmail.com>; +Cc: c k <shreeseva.learning@gmail.com>; pgsql-general@postgresql.org; 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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-09-08 16:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-07 20:32 secure connections c k <shreeseva.learning@gmail.com>
2008-09-08 00:27 ` Filip Rembiałkowski <plk.zuber@gmail.com>
2008-09-08 16:04 ` Alejandro D. Burne <alejandro.dburne@gmail.com>
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